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
2011-06-29
1,475 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,855 reads
Why I’m raising my son to be a nerd
A good read, from ESPN and CNN columnist, LZ Granderson: Why I’m raising my son to be a nerd.
We need...
2011-06-29
1,604 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,596 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,433 reads
Understanding Benchmarks
That Means What?
Vizzini: HE DIDN’T FALL? INCONCEIVABLE.
Inigo Montoya: You keep using that word. I do not think it means...
2011-06-29
2,114 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
888 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
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
969 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers