Comparison of Columnstore Compression
SQL Server 2012 introduced non-clustered columnstore indexes, and SQL Server 2014 gave us clustered columnstore indexes. Both share the same...
2014-05-20
1,831 reads
Blog Posts
Google Analytics for SSIS (SQL Server Integration Services)
Update: There is a new 1.7 Version of Google Analytics Source for SSIS
In the modern age of the technology, almost...
2014-05-20
3,376 reads
Granting or denying permissions to all of the tables within a database
When granting or denying permissions to the tables within a database you have two options. You can either add the...
2014-05-20 (first published: 2014-05-15)
4,156 reads
Presenting at ONETUG on July 10, 2014
I’ll be presenting SQL Performance for Developers to the members of ONETUG on July 10, 2014. I’m going to hit...
2014-05-20
412 reads
Quick Tips–SQL Prompt Formatting
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2014-05-20 (first published: 2014-05-14)
3,443 reads
Running Out of Foreign Keys-Question of the Day
Running Out of Foreign Keys is live today. Nothing too interesting about this one, a straight forward question where you...
2014-05-20
342 reads
Tulsa User Group
I love user groups.
I have a special place in my heart for people who go out and give their time...
2014-05-20
630 reads
Varchar "miracle" and best practice
I've just spent fifteen minutes helping colleague to find "miracle in t-sql code".
- There should be rows, definitely! I can...
2014-05-20
664 reads
Add an Instance to SQL Server Azure Virtual Machine
How do you add an instance to your local SQL Server installation? You run the executable that you probably downloaded...
2014-05-19 (first published: 2014-05-13)
1,478 reads
Cannot start SSAS after install in tabular mode
After installing SSAS, using the tabular model, you receive the error “The service cannot be started: The following system error...
2014-05-19 (first published: 2014-05-13)
4,142 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
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...
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