Monday Morning SQL Break – June 13, 2016
Usually on my Monday posts, I include a pretty bland cookie cutter header. Nothing to extravagant, just an introduction. It’s...
2016-06-13
754 reads
StrateSQL
How To Get A Free SQL Server Indexing Book – Week 2
Free Book!
Another free indexing books, more awesome!
In last week’s post, I talked about how I’ve got a number of copies...
2016-06-10
923 reads
How To Get A Free SQL Server Indexing Book – Week 2
Free Book! Another free indexing books, more awesome! In last week’s post, I talked about how I’ve got a number of copies of Expert Performance Indexing for SQL Server;...
2016-06-10
2 reads
Book Review: Sapiens: A Brief History of Humankind
Sapiens: A Brief History of Humankind, by Yuval Harari, made it on my reading list after hearing about Mark Zuckerberg’s...
2016-06-08
820 reads
Book Review: Sapiens: A Brief History of Humankind
Sapiens: A Brief History of Humankind, by Yuval Harari, made it on my reading list after hearing about Mark Zuckerberg’s list of books everyone should read. And since then,...
2016-06-08
3 reads
Monday Morning SQL Break – June 6, 2016
It’s Monday time for this week’s Monday Morning SQL Break. A chance to catch up on links I’ve shared and...
2016-06-06
414 reads
How To Get A Free SQL Server Indexing Book – Week 1
Free indexing books, awesome!
Before I tell you how, lets start with what we are talking about here. If you weren’t...
2016-06-03
470 reads
How To Get A Free SQL Server Indexing Book – Week 1
Free indexing books, awesome! Before I tell you how, lets start with what we are talking about here. If you weren’t aware, last summer I worked with Grant Fritchey...
2016-06-03
2 reads
Why Do I Write? And Should I Continue?
It’s been about six months now since my career to a sharp right turn. At the request of my kids,...
2016-06-02
370 reads
Why Do I Write? And Should I Continue?
It’s been about six months now since my career to a sharp right turn. At the request of my kids, I left a decade of consulting for a role...
2016-06-02
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