Week Starts On Saturday?
A function that emulates SET DATEFIRST 6 within a function for finding relevant date information.
2012-02-29 (first published: 2012-02-15)
561 reads
Scripts
Currently Running Process - 2005
This script will show the currently running queries in the system. It will give the entire script which is involved in the background.
2012-02-28 (first published: 2012-02-01)
1,426 reads
TSQL that lists all numbers from 1..100
This query shows how to write a T-SQL statement that lists all numbers between 1 and 100 ordered, without use of any DATABASE table with only ONE select statement.
2012-02-20 (first published: 2011-12-31)
2,322 reads
PowerShell SCript to export almost everything from a list of servers
Create a c:\servers.txt list of servers. No spaces or it wont work. Then copy the code into a ps1 file and edit the directroyfilename to show where you want the files to end up.
2012-02-17 (first published: 2012-01-23)
1,896 reads
Find storage including mount points Sql and windows utility
Find drive, freespace, usedspace and percent free for all drives and mounted volumes.
2012-02-16 (first published: 2011-12-15)
844 reads
Integer left and right shift
3 functions that implement the left (<<), right (>>) and unsigned right (>>>) shift operators, commonly found in C-style languages.
2012-02-15 (first published: 2011-12-30)
8,160 reads
2012-02-13 (first published: 2011-12-30)
1,734 reads
Data Driven Subscription - SQL Server Standard Edition
A simple example of using T-SQL and the Boomerang framework to create a data driven subscription.
2012-02-08 (first published: 2012-01-04)
1,966 reads
2012-02-07 (first published: 2011-12-15)
1,092 reads
2012-02-06 (first published: 2011-12-23)
1,585 reads
Blogs
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
A Front Door for the DBA Team – AgentDBA UI
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
Cleaning Up Azure MS Defender Billing
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers