Last Sunday
Needed to return the week ending date as Sunday for daily transactions multiple times, for several aggregate reports. This function returns the last Sunday for past or future weeks.
2009-05-11 (first published: 2009-04-15)
681 reads
Scripts
Cluster Information
This script will display information about the instance(s) on your cluster. Name of nodes, active node and drive letters of the resources
2009-05-08 (first published: 2009-04-15)
1,437 reads
2009-05-07 (first published: 2009-03-27)
1,624 reads
Convert GMT/UTC to Local datetime
International Applications require timezone handling for different users Here is how to do this with SQL.
2009-05-06
4,202 reads
Easily calculate the size of your tables
This quick and dirty sql will tell you the number of rows in your tables, the size in MB of yout data, and the total size (including indexes)
2009-05-04 (first published: 2008-10-04)
1,712 reads
What SQL JOb's are running on 2005 Server
This script returns the information of all SQL Jobs that are running on the server with the latest status.
2009-05-01 (first published: 2009-04-08)
1,658 reads
Check if a sql server agent job ran
Checks if a sql server job ran successfully in the last xx minutes.
2009-04-29 (first published: 2009-04-02)
1,477 reads
2009-04-28
2,406 reads
usp_SQL_In_sp_who2
Ammends the sp_who2 procedure with the input buffer contents, ususally the SQL statement for that SPID
2009-04-24 (first published: 2009-03-27)
1,323 reads
2009-04-22 (first published: 2009-03-19)
1,070 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
Making an Impression
Comments posted to this topic are about the item Making an Impression
SQL Server Vector Support I
Comments posted to this topic are about the item SQL Server Vector Support I
Anyone have a SQL Server 2014 Developer Edition DVD?
Hi all, I’m looking for a SQL Server 2014 Developer Edition DVD. Does anyone...
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers