Skip To Main Content
Grant Alter on Muck Rack

Grant Alter

As seen in: Microsoft Learn Blog, Amazon Web Services (AWS), DEV Community, EIN Presswire, SQL Server Central, IT Jungle
Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work. Claim your profile
Back to Grant Alter’s profile

Articles by Grant Alter

Glue cross-account setup

|
By Grant Alter
| DEV Community
This document will cover detailed steps on how to query glue DB catalog from Dremio in a cross-account setup using AWS Lake formation Use-case Account A - Dremio is deployed here and AWS Glue_DB_A is created and added as a source in Dremio Account B - AWS Glue_DB_B is created and data is located in the S3 bucket Customer wants to share Glue-DB B catalog with Glue-DB A and query the data located in account B from Dremio Setup Diagram Role of each of service in the given setup - Lake Formation...
Open in Who Shared Issue with article?

How to clone master user permissions in Amazon RDS for SQL Server | Amazon Web Services

|
By Grant Execute, Grant Select, Grant Alter, Grant Control
| Amazon Web Services (AWS)
When you create a new Amazon Relational Database Service (Amazon RDS) for SQL Server instance, the master user is granted certain privileges for that database instance. We strongly recommend that you do not use the master user directly in your applications. Instead, adhere to the principles of least privilege and best practices by using a database user created with the minimal permissions required for your application.
Open in Who Shared Issue with article?

Centos下脚本安装MySQL(tar.gz)-阿里云开发者社区

|
By Grant Alter, Grant option, Replication Slave
| dasizhe.cn
官网地址：https://downloads.mysql.com/archives/community/ 这里可以选择任意版本以及操作系统。 编写脚本文件：mysql-5.7.16-install.sh。 脚本下载地址：http://download.csdn.net/download/j080624/10159581 如下图所示： 也可以使用wget命令从服务器直接下载： 如下图所示，点击Download浏览器就会下载，只需要将下载的URL拼接到wget后面即可 如上图所示，在/opt/soft/mysql5.7目录下，执行如下命令： 如果提示无权限，则执行如下命令： 执行结果如下图： 最后一句表明，生成了临时默认密码，登录的时候需要使用。 使用默认密码登录数据库，提示如下： 修改密码： 再次查看数据库： 添加远程连接用户并赋予权限 如果发现有权限没有赋予，则使用如下： 如果不小心忘记默认登录密码，强力破解：http://blog.csdn.net/j080624/article/details/78286239 直接执行命令登录，提示如下：
Open in Who Shared Issue with article?

Delegating permission management using Roles vs WITH GRANT OPTION

|
By Grant Alter, Grant Select, Grant Insert, Andreas Wolter
| Microsoft Learn Blog
Background In SQL Server/Azure SQL, database-level permissions are almost always handled by either the database owner (which has the dbo-identity) or members of the db_owner or db_securityadmin-database roles. Here you can learn more about the differences: Principals (Database Engine), Database-Level Roles. Both roles can GRANT/DENY/REVOKE any permission within a database. Since that makes members of these roles super powerful, their membership should always be tightly controlled and audited.
Open in Who Shared Issue with article?

db_ddladmin Jr. - SQLServerCentral

|
By Kenneth Fisher, Grant Alter
| SQL Server Central
A while back I talked about the fact that you can grant someone CREATE PROCEDURE and ALTER on a schema in order to let them create a stored procedure in that schema. Rather than adding them to the db_ddladmin role and granting them the ability to create all kinds of objects in any schema in the database, among other things. GRANT CREATE PROCEDURE TO [Ken.Fisqher]; GRANT ALTER ON SCHEMA::[dbo] TO [Ken.Fisqher]; What if I want the user to be able to create VIEWS, TABLES, FUNCTIONS, etc.
Open in Who Shared Issue with article?

50 AMP Productions And Re-Logic Announce The Terraria Graphic Novel Series

|
By Grant Alter
| EIN Presswire
50 AMP’s first title, “TERRARIA,” is based on one of the top 10 best-selling video games of all time, created by RE-LOGIC, launching in September. ST. LOUIS, MISSOURI, UNITED STATES, August 10, 2022 / EINPresswire.com/ -- Founded by Grant Alter, 50 AMP PRODUCTIONS is a new publishing/ entertainment company that will be bringing some of the hottest properties to comics and graphic novels. The first project coming from 50 AMP PRODUCTIONS is based on “Terraria,” which has sold over 45 million copies.
Open in Who Shared Issue with article?

Building a pacemaker cluster to deploy a SQL Server availability group in Azure – SQLServerCentral

|
By Andrew Pruski, Grant Alter
| SQL Server Central
There are new Ubuntu Pro 20.04 images available in the Azure marketplace with SQL Server 2019 pre-installed so I thought I’d run through how to create a three node pacemaker cluster with these new images in order to deploy a SQL Server availability group. Disclaimer – The following steps will create the cluster but will not have been tested in a production environment. Any HA configuration for SQL Server needs to be thoroughly tested before going “live”.
Open in Who Shared Issue with article?

Guru: Use SQL To Replace Reports

|
By - Sql, Grant Alter, Ted Holt, Rrn Asc
| IT Jungle Verified
June 14, 2021 Ted Holt Does anybody write report programs anymore? If so, why? Reports are so twentieth-century. The people we serve want spreadsheets, Web pages, cell-phone apps and other modern conveniences. What we need is an easy way to make our report programs write the same information to modern interfaces without having to perform major surgery on them. Some 10 years or so ago, I built a scripting language to enable me to reformat spooled files into stream files in CSV format.
Open in Who Shared Issue with article?

Guru: Generate SQL for Dependents

|
By - Sql, Grant Delete, Grant Alter, Grant Select
| IT Jungle Verified
May 24, 2021 Paul Tuohy Way back in October 2014, in the article Find A View Of A View Of A View. . ., I detailed a stored procedure that, given the name of a table or a view, provides the full list of dependent views and all of their dependents and all of their dependents, etc. This is a stored procedure that has served me well in the world of DDL, where it is common to have views of views of views.
Open in Who Shared Issue with article?

System-Versioned Temporal Tables - A Case Study – SQLServerCentral

|
By Wagner Crivelini, Description Varchar, Grant Alter, Grant Select
| SQL Server Central
I recently faced an issue related to managing and maintaining my system-versioned temporal tables. Out of the blue, our dev/test database was full of weird tables. Dozens of them. With those long names, 'MSSQL_TemporalHistoryFor_' followed by several numbers and letters. The source was obvious: they were historical tables that work together with the temporal ones to keep track of data versioning. But why so many and what should we do with them?
Open in Who Shared Issue with article?

Loading data in Azure Synapse using Copy – SQLServerCentral

|
By Sucharita Das, Grant Alter, Grant Select
| SQL Server Central
Introduction Azure Synapse Analytics (formerly SQL DW) )is the next evolution of Azure SQL Data Warehouse. It is a combination of enterprise data warehousing and Big Data Analytics. A Synapse SQL Pool is the enterprise data warehousing feature that is generally available in Azure Synapse Analytics. This is a collection of analytic resources and the size and performance of the pool is determined by the selected Data Warehousing units (DWU).
Open in Who Shared Issue with article?

Install Php And Mysql On Ubuntu

|
By Grant All Privileges, Grant Alter, Grant Select
| restack.io
Learn how to install PHP and MySQL on Ubuntu for effective web development using PHP e-learning tools. The framework for autonomous intelligence To install PHP and MySQL on Ubuntu, you can use the following command in your terminal. This command will install PHP along with several essential extensions and MySQL server: sudo apt-get install php php-curl php-gd php-cli mysql-server php-mysql php-xml php-mbstring After installing PHP, you can proceed to install Matomo.
Open in Who Shared Issue with article?

Home Library Management Applications Database

|
By Grant All Privileges, Grant Alter, Import MySqldb
| restack.io
Learn how to create a library database using home library management applications effectively and efficiently. The framework for autonomous intelligence To set up a MySQL database for use with Python, follow these detailed steps: Install MySQL Log into the server that will host the database and open a terminal window. Install MySQL using your package manager.
Open in Who Shared Issue with article?

Install Server Manager for Minecraft

|
By Grant All Privileges, Grant Alter
| restack.io
Learn how to install and configure the Server Manager for effective Minecraft server management. The framework for autonomous intelligence To install Mattermost on RHEL 8, follow these detailed steps to ensure a successful setup. Begin by installing the 64-bit version of RHEL 8 on your server. You can find the official installation instructions in the Red Hat documentation. After the installation is complete, it is crucial to keep your system updated.
Open in Who Shared View Duplicates (3) Issue with article?

Mysqltuner Installation Guide

|
By Grant All Privileges, Grant Alter, Flush Privileges
| restack.io
Learn how to install Mysqltuner effectively for optimizing your MySQL database performance with our step-by-step guide. The framework for autonomous intelligence To install MySQL 5.7 on RHEL 7, follow these steps: Step 1: Log in to the Server Log in to the server that will host the database and open a terminal window.
Open in Who Shared Issue with article?
Show More