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,966 reads
Scripts
2017-07-18 (first published: 2015-10-16)
1,777 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)
533 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,141 reads
2017-06-05 (first published: 2016-08-15)
974 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,954 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,418 reads
2017-05-25 (first published: 2017-05-15)
1,668 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)
545 reads
2017-05-16 (first published: 2017-05-05)
938 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers