Script DB Level Permissions v4.6
Script database and object level permissions for all database users
2022-01-12 (first published: 2021-06-11)
17,476 reads
S. Kusen
Script DB Level Permissions v4.3
Script database and object level permissions for all database users
2017-07-25 (first published: 2016-02-26)
14,444 reads
2015-08-06 (first published: 2010-11-02)
26,484 reads
Collect Data from Multiple Instances Using SSIS and Powershell
Use SSIS to pull data from multiple instances. Combine with powershell to run multiple instances simultaneously.
2015-02-23
8,423 reads
Automate Your Central Management Server Registrations
Easily register SQL Servers in your inventory to your CMS for easy multi-server queries.
2014-08-18
5,550 reads
SQL 2008 SP/CU Patching Through Windows Scheduled Tasks
Automate patch installations using the task scheduler and command line hotfix options for SQL.
2011-05-03
4,675 reads
T-Log Backup/Restore with Date & Time
Simple script formatting the date and naming a backup file path for a t-log and restoring those logs.
2010-12-29 (first published: 2010-12-15)
1,463 reads
Multi-Script, Multi-DB Deployments
A way to handle application releases involving multiple scripts and/or multiple databases.
2010-08-23
6,713 reads
Blogs
The PASS Summit on Tour in the Netherlands
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Azure SQL Managed Instance: Boost Performance with Read-Scale Out
By Arun Sirpal
The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature...
Free Cloud Environment Setup: A Beginner’s Guide
By Rohit Garg
Cloud computing is essential for modern development, data storage, and scalable applications. Setting up...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Sometimes, Troubleshooting Is Hard
Comments posted to this topic are about the item Sometimes, Troubleshooting Is Hard
Dimensional Modeling Case Study, Part 4 – Dynamic Time Duration Dimension
Comments posted to this topic are about the item Dimensional Modeling Case Study, Part...
Question of the Day
The Updated Columns List
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers