Password Cracking–Part 2
Two days felt like a long time, so we found a cloud server with 16 cores we could use. We...
2014-05-19
606 reads
Blog Posts
Statistics with Ascending Key Column Values
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-05-19
1,534 reads
Building The SQLSaturday Orlando Marketing Plan–Part 8
One of things I wish PASS provided was at least one template for an event flyer, something that is basically...
2014-05-18
504 reads
PASS Business Analytics Conference 2014 Recap, part 1
PASS Business Analytics Conference is not a new kid on the block anymore – happening for the second year in a...
2014-05-18
253 reads
SharePoint 2013 External Data Connections
SharePoint 2013 External Data Connections
SharePoint 2013 External Data Connections are part of the Business Connectivity Services (BCS) that can be...
2014-05-18
1,262 reads
Developer’s Life – Every Developer is a Spiderman
Originally posted on Journey to SQL Authority with Pinal Dave:
I have to admit, Spiderman is my favorite superhero. The most...
2014-05-17
782 reads
What Does it Cost to Implement a Business Intelligence Project?
Someone recently asked me through LinkedIn how much it would cost to implement a BI project with Microsoft tools. This...
2014-05-17
989 reads
BASIC
It might or might not surprise you that I learned to code in Basic. I suppose my first real attempt...
2014-05-16
701 reads
Friday Followup For May 16, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-05-16
467 reads
How SQL Server statistics are generated and updated
One of the easiest ways to increase query performance on your database is making sure your statistics are up-to-date. Statistics...
2014-05-16
457 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
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...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
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