Add a login to multiple SQL Servers
This is a simple powershell script that will add a particular login to multiple SQL Server instances in a go.
2017-07-19 (first published: 2017-07-04)
1,937 reads
Scripts
2017-07-18 (first published: 2015-10-16)
1,751 reads
XML import from a Cross-tab Report
Source xml is a rendition of a cross-tab report. I show the evolution of a Spackle solution for import as a SQL resultset.
2017-06-08 (first published: 2017-06-01)
485 reads
PBM Policy / WMI query to see which CPUs are in power-saving mode
A simple PBM policy which uses WMI to find out if the CPUs in the target are running at their maximum clock speed.
2017-06-06 (first published: 2011-01-14)
2,083 reads
2017-06-05 (first published: 2016-08-15)
950 reads
Getting TEXT, NTEXT and IMAGE columns in Database
As per Microsoft documentation these types will be removed from future version
2017-06-02 (first published: 2017-05-31)
2,832 reads
Function to Round or Truncate DateTime
This Function is used to round to Second, Minute, Hour or Day or to Truncate to Second, Minute, Hour, Day, Month or Year and return Datetime Value
2017-05-31 (first published: 2017-05-23)
4,331 reads
2017-05-25 (first published: 2017-05-15)
1,609 reads
Compute Holiday Day of the Month for any Year
This script provides the day of the month for the standard bank holidays for any given year. This is especially useful for computing the workday after a holiday.
2017-05-24 (first published: 2017-05-10)
499 reads
2017-05-16 (first published: 2017-05-05)
904 reads
Blogs
Local LLM Models at SQL Saturday Boston 2025
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
3 things you must do to start data quality management right
As a data & AI strategist who’s seen countless projects succeed and fail, I...
Set Theory vs. Batch Mode in SQL Server
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Forums
SSC Website Deployment 24 Sept 2025
We are planning on a fairly big code deployment to set the stage for...
Timeout when expanding the table
Experts, I am hoping to get some help and feedback. I have a server...
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers