Crosstabs over Pivots
I wrote about a basic PIVOT query recently. It’s an interesting way to write a query and turn row data...
2014-09-02
2,058 reads
Blog Posts
I did my part – Helping others
Let’s raise some money, people.
TL;DR Donate to Doctors Without Borders, the Argenis Without Borders campaign.
What started out as a joke...
2014-09-02 (first published: 2014-08-28)
5,403 reads
SQL Server column encryption
We use databases to store a lot of information. This can also include sensitive information we don’t want to give...
2014-09-02
4,349 reads
SQLSaturday Orlando Marketing Plan-Part 40
Last week we were at 332, this morning at about the same time we’re at 356. Not bad for a...
2014-09-02
543 reads
The Nine SQL Server Careers
Microsoft SQL Server is a mature and broad technology platform that supports a diverse set of careers - this blog post...
2014-09-02
1,510 reads
Two simple commands that can be a big help in performance tuning.
The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are...
2014-09-02
2,598 reads
Upcoming Events
My summer event hiatus is coming to a close, and we’re now back into the conference and event season! I’ve...
2014-09-02
739 reads
Using indexed views on ANY core SQL server edition
I was having a discussion the other day and was quite surprised to hear that there still appears to be...
2014-09-02 (first published: 2014-08-26)
7,890 reads
Better Presentations–Hide those Windows
This is part of a series of tips for speakers to make your presentations better.
I wanted to give some specific SQL...
2014-09-01 (first published: 2014-08-26)
7,296 reads
Business Intelligence Strategy – Beginning Steps
Business Intelligence Strategy
A business intelligence strategy is used to determine where an organization is and where they are going with...
2014-09-01
744 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