The difference between REVOKE and DENY
There was confusion recently with a poster that was moving permissions around and asked why I said they should revoke...
2011-06-30
11,275 reads
Blog Posts
Tobias Ternstrom’s Great Denali Preview
Tobias Ternstrom from Microsoft gave a great talk at Tech Ed regarding upcoming features of SQL Server Denali. His presentation...
2011-06-30
2,222 reads
Watermarking
Someone asked me a long time ago how to do watermarking in Reporting Services and I meant to write a...
2011-06-30
2,793 reads
Can you query a SSAS cube while it is processing?
I have always wondered if queries against a SSAS cube while it is processing would be forced to wait the...
2011-06-29
2,590 reads
Cleaner T-SQL with Table Value Constructors
Table Value Constructors were introduced in SQL Server 2008 and enables you to (not only) insert more records with one...
2011-06-29
965 reads
Energy Efficient Offices
I work with a client that recently moved into a newly renovated space in a smaller office building. The renovation...
2011-06-29
887 reads
New Connect Item – TDE
Does the certificate matter for TDE? Apparently not as I found a number of people discussing the fact that the...
2011-06-29
1,188 reads
2011-06-29
1,469 reads
SQLDIY: Tracking Space Usage At the Index Level
I am a fan of information, the more the merrier. Anytime I’m tasked with tracking a production server over the...
2011-06-29
1,430 reads
The mystery of the NULL bitmap mask
In today's weblog post I want to talk about the NULL bitmap mask and some mysteries
that you can encounter with...
2011-06-29
4,848 reads
Blogs
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Forums
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Secure Communications
Comments posted to this topic are about the item Secure Communications
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers