T-SQL Tuesday #120 – What were you thinking? – Invitation
In this month's T-SQL Tuesday, I want to know about things that you have seen someone do in SQL Server that has left you wonder "What were you thinking?"
The...
2019-11-05
10 reads
A Discussion of SQL Server-Related Topics
T-SQL Tuesday #120 – What were you thinking? – Invitation
In this month's T-SQL Tuesday, I want to know about things that you have seen someone do in SQL Server that has left you wonder "What were you thinking?"
The...
2019-11-05
5 reads
TSQL Tuesday #116 – SQL Server on Linux
You can now run SQL Server on Linux. With it being easy to install / update, and running exactly the same as in Windows, it is my choice for...
2019-07-13
26 reads
TSQL Tuesday #116 – SQL Server on Linux
You can now run SQL Server on Linux. With it being easy to install / update, and running exactly the same as in Windows, it is my choice for...
2019-07-13
6 reads
T-SQL Tuesday #115 – Notes to 20 year old Wayne
There’s a lot that goes on in June. From the 75th anniversary of D-Day, Fathers Day, to the official start of summer (though it feels like it already!)....
2019-06-28 (first published: 2019-06-11)
228 reads
T-SQL Tuesday #115 – Notes to 20 year old Wayne
There’s a lot that goes on in June. From the 75th anniversary of D-Day, Fathers Day, to the official start of summer (though it feels like it already!)....
2019-06-11
2 reads
Working with SQLSaturday SpeedPASSes – revamped!
In the Richmond, VA area, I am the organizer for our SQL Saturdays. Among other jobs that this entails, this also means that I am working with SQLSaturday SpeedPASSes....
2019-05-21
45 reads
Working with SQLSaturday SpeedPASSes – revamped!
In the Richmond, VA area, I am the organizer for our SQL Saturdays. Among other jobs that this entails, this also means that I am working with SQLSaturday SpeedPASSes....
2019-05-21
2 reads
Working with SQLSaturday SpeedPASSes – revamped!
In the Richmond, VA area, I am the organizer for our SQL Saturdays. Among other jobs that this entails, this also means that I am working with SQLSaturday SpeedPASSes....
2019-05-21
3 reads
Scalar UDF Inlining in SQL Server 2019 – Simpler functions
I recently published a post detailing the new Scalar UDF Inlining feature in SQL 2019 here. That post introduced the...
2019-03-26 (first published: 2019-03-11)
638 reads
Blogs
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
combining a param value with widcards in a foreach loop files property
Hi, it isnt clear from the web if something like this should work as...
Extract sql data in psh
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
caught off guard by some greek lettering in a warehouse feed
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Question of the Day
Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers