Get Started and Build Your Own SQL World
“Sir, thank you for taking this meeting. We have this new thing to show you. It will allow you to...
2015-04-07
898 reads
Blog Posts
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
799 reads
My Favorite FREE Reports in SSMS
Microsoft has given us DBAs/Developers/etc. a wealth of free reports integrated into SQL Server Management Studio (SSMS) in order to...
2015-04-07
796 reads
PowerShelling SQL Saturday Sessions to the Guidebook app
Following on from my previous post about parsing XML where I used the information from Steve Jones blog post to...
2015-04-07
784 reads
SQL New Blogger Challenge: Week 1
WOW!
The response to the SQL New Blogger Challenge I issued a couple of weeks ago has been absolutely incredible. At...
2015-04-07
503 reads
SQL Server Quickie #23 – Plan Cache Pollution
Today I have uploaded the 23th SQL Server Quickie to YouTube. This time I’m talking about Plan Cache Pollution in...
2015-04-07
903 reads
SSMS regular expressions: format text into a block
Sean’s RegEx for DBAs class must be finally sinking in for me. Today I was able to figure out a...
2015-04-07
509 reads
SSRS report footer is NOT lost in Excel
With all the recent changes and updates within the Microsoft PowerBI universe, SSRS core technology gets less and less attention....
2015-04-07 (first published: 2015-03-31)
14,119 reads
Backups – They Are Needed, Who Knew?
Backups are essential for a successful business model. That statement may or may spark some topics for debate, but at...
2015-04-06 (first published: 2015-03-30)
7,137 reads
Designing for offloaded log backups in AlwaysOn Availability Groups – Part 1
AlwaysOn Availability Groups made their initial appearance in SQL 2012 and have generated a lot of buzz, HA and DR in one! Even with AGs, still integral to your...
2015-04-06
11 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers