October speaking schedule: Two Saturdays and a Summit
October is going to be a very busy month for me! Three conferences and a pre-con are on the agenda.
This...
2015-10-01
361 reads
The Data Files
Speaking at SQLSaturday Omaha
In just one week, I’ll be traveling west to Omaha to speak at SQLSaturday there. It’s been a while since...
2015-08-07
399 reads
Speaking at 24 Hours of PASS
I’m thrilled to announce that I’ve been selected to present as part of the next 24 Hours of PASS! The...
2015-05-14
470 reads
Monitoring Your Backups [T-SQL Tuesday #66]
Cathrine Wilhelmsen (b|t) is hosting this month’s T-SQL Tuesday, and the topic she chose is monitoring. All of us, whether...
2015-05-12
1,063 reads
SQL Server 2016 announced… and it’s gonna rock
In what spare time I’ve had this week, I’ve been watching the news coming out of Microsoft Ignite (formerly Tech...
2015-05-06
4,738 reads
Speaking at Iowa Code Camp on May 9
If you’re in the Iowa City area, come to Iowa Code Camp this weekend! They have a great lineup of speakers, covering...
2015-05-05
411 reads
Creating a Self-Contained Multi-Subnet Test Environment, Part II – Adding a Domain Controller
This is the second in a series of articles about creating a simulated environment for testing systems that cross subnets.
Part...
2015-04-29
2,123 reads
Creating a Self-Contained Multi-Subnet Test Environment, Part I – Networking
For a recent presentation on using availability groups for disaster recovery, I needed a test environment that contained multiple separate...
2015-04-21
724 reads
Teach Something New: PowerShell Providers [T-SQL Tuesday #065]
Mike Donnelly (b|t) invited the SQL New Blogger Challenge participants to join in this month’s T-SQL Tuesday, and I’m happy...
2015-04-14
538 reads
Documentation: Are You Ready?
Would your coworkers know how to handle your job if you weren’t there?
This question was top-of-mind for me last week...
2015-04-07
1,093 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