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
759 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
930 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
3 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
823 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
5 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
416 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
474 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
5 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
372 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
3 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers