Notes From SQLSaturday Houston 2018
Various and possibly amazing notes:
Because I waited too long the best flight I could get was into George Bush instead...
2018-06-28
403 reads
Tools to connect to a SQL database
Today I'm getting back to basics, whether you are new or veteran with the database engine you need a tool to get into, write queries, do some monitoring, tuning,...
2018-06-28
772 reads
Power BI Custom Visuals Class (Module 109 – as Timeline)
In this module you will learn how to use the as Timeline visual. The as Timeline is a Gantt chart...
2018-07-03 (first published: 2018-06-28)
2,870 reads
Tools to connect to a SQL database
Today I'm getting back to basics, whether you are new or veteran with the database engine you need a tool...
2018-06-27
1,608 reads
Update your production servers and stop making excuses about it
Folks, we all like to make sure we’re doing our level best to make things work smoothly. So why am...
2018-06-27
372 reads
SQL Puzzle – FizzBuzz3d
I thought for the end of the month it would be fun to do another T-SQL Puzzle. In this case...
2018-07-04 (first published: 2018-06-27)
2,170 reads
Alter Multiple Databases at Once
This is a quick and dirty method I often use when I want to make a change to multiple databases...
2018-07-03 (first published: 2018-06-26)
2,513 reads
Login Failed – Token-based server access validation failed for SQL Server
Login failures are a common item to troubleshoot with SQL Server. Out of all of the possible log failure reasons...
2018-06-26
197 reads
Query Store Error State
We recently discovered some of our databases in an Error State for SQL Server. Microsoft has indicated this is a race condition when failover/restart happens on QDS cleanup. They...
2018-06-26
4 reads
Query Store Error State
We recently discovered some of our databases in an Error State for SQL Server. Microsoft has indicated this is a race condition when failover/restart happens on QDS cleanup. They...
2018-06-26
6 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