The Whirlwind That Is October – Part 2
October has been such a whirlwind of PASS activity for me. Two SQL Saturdays and the PASS Summit. This post...
2015-10-18
378 reads
SQL Swimmer
The Whirlwind That Is October – Part 1
October has been such a whirlwind of PASS activity for me. Two SQL Saturdays and the PASS Summit. This post...
2015-10-16
501 reads
Fall Means Election Season
While it’s not officially Fall yet, it is definitely Election Season. Elections for the PASS Board of Directors opens up...
2015-09-25 (first published: 2015-09-11)
862 reads
TSQL2sday #68 – Defaults
A big thank you goes out to Andy Yun (b|t) for hosting this month’s TSQL2sday party. This month’s topic is...
2015-07-14
523 reads
The Whole Pie
Today should be such an exciting day, the day the speakers are announced for the 2015 PASS Summit. But as...
2015-06-26
444 reads
Earning my MCSE: Business Intelligence Certification
I earned my MCSE: Business Intelligence Certification on May 27, 2015. It was a long road, but I did it....
2015-05-28
1,518 reads
TSQL2sday #66 – Monitoring
A big thank you to Cathrine Wilhelmsen (blog | twitter) for hosting this month’s TSQL2sday party. Monitoring is this month’s topic...
2015-05-12
578 reads
Becoming a PASS Chapter Leader – Challenge Accepted!
My first real introduction to PASS was back in 1998. I was an “Accidential DBA” and needed some training. I...
2015-04-14
532 reads
How to Add Users to Roles in SSAS, a.k.a., Where the Heck are the Buttons?
I’ve been responsible for administering Analysis Services (SSAS) on a regular basis for the past 7-8 years via SQL Server...
2015-04-07
798 reads
Achievement Unlocked: 24 Hours of Pass Session Submitted
I have finally submitted a session for a speaking engagement. Those who know me know that this is a very...
2015-03-19
741 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