Automating SSAS Backups
Backing up databases is one of the most important jobs of a DBA. If your data is not safe, your...
2015-02-23 (first published: 2015-02-11)
8,823 reads
SQL Swimmer
Managing Security – TSQL2sday # 63
A big thank you goes out to Kenneth Fisher ( b | t ) for hosting this month’s TSQL2sday party. Security is a...
2015-02-10
503 reads
Transaction Isolation Level Blues
Have you ever had a mental block in one particular area when learning something? It might be the simplest thing,...
2014-12-25 (first published: 2014-12-15)
5,490 reads
Giving Back T-SQL Tuesday #61
First off I wanted to thank Wayne Sheffield (Twitter | Blog) for hosting this month’s T-SQL Tuesday party and Adam Machanic...
2014-12-12 (first published: 2014-12-09)
4,411 reads
Summit 2014
It’s hard to believe it’s over. It felt like a whirlwind while I was in Seattle for my 7th PASS...
2014-11-10
464 reads
Data Driven Subscription On A Budget, Part 2
Data Driven Subscriptions On A Budget – Part 2
Yes, this is Part 2, you can find Part 1 here to get...
2014-11-04
1,108 reads
I Didn’t Hyperventilate!
I gave what is officially my second presentation this week. I presented at the Triad SQL BI (Twitter | PASS) user...
2014-08-28
1,289 reads
Data Driven Subscriptions On A Budget
Data Driven subscriptions in SQL Server Reporting Services (SSRS) is only available if you have the Enterprise or BI Editions...
2014-07-01
1,059 reads
2014 NomCom Slate is Amazing
Serving on the Nomination Committee (NomCom) is such an honor. One that I was lucky enough to experience two years...
2014-06-02
434 reads
Disheartening Apples
Question: How many Oracle DBAs can you fit in Madison Square Garden?
Answer: None, their egos won’t fit through the door.
No,...
2014-03-21
636 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