Reblog: January 24 to January 30
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-01-31
1,389 reads
StrateSQL
Have You Studied SQL Server Enough?
Photo Credit – yum9me
SQL Server is a fairly big and complicated product. There are quite a few areas that you can...
2014-01-29
1,493 reads
February 2014 – SQL Server Monthly Maintenance Checklist
image source
It’s a cold, cold day here in Minnesota. A great day for staying in and working on some in-home...
2014-01-27
537 reads
Last Weeks Top “Reading” Links #68
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-01-27
972 reads
Does @StrateSQL Need a Unicorn Tattoo?
As I mentioned in a post a couple weeks back, I’ll be jumping into Lake Calhoun in a few weeks...
2014-01-26
541 reads
Reblog: January 17 to January 23
Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In...
2014-01-24
735 reads
Webcast Follow-Up: The Flavors of Non-Clustered Indexes
Earlier today, I presented a session for Pragmatic WorksTraining on the T’s titled The Flavors of Non-Clustered Indexes. In the session,...
2014-01-23
753 reads
Last Weeks Top “Reading” Links #67
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-01-20
632 reads
Reblog: January 10 to January 16
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-01-17
772 reads
Webcast Follow-Up: Necessary Evils, Building Optimized CRUD Procedures
Earlier today, I presented a session for Pragmatic WorksTraining on the T’s titled Necessary Evils, Building Optimized CRUD Procedures. In the...
2014-01-16
687 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