The Reader’s Choice Awards are Taking Nominations
If you’re using products, you might want to nominate a vendor or product for a database tool that helps you....
2019-02-26
889 reads
Undercover TV – Sean McCown Joins Us For a Session on Beginning Powershell SMO
In this episode, Adrian looks at some of the new features of the Undercover Inspector1.3 and special guest, Sean McCown...
2019-02-26
243 reads
Cool Stuff in Snowflake – Part 7: Creating Tables
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough...
2019-02-26
95 reads
Database context and compatibility level
To add onto yesterday’s post about which cardinality estimator (CE) your query will use, there’s an additional complexity. This specifically...
2019-02-26
830 reads
Searching Complex JSON Data
Watch this week’s video on YouTubeComputed column indexes make querying JSON data fast and efficient, especially when the schema of...
2019-02-26
938 reads
Searching Complex JSON Data
Watch this week's video on YouTube
Computed column indexes make querying JSON data fast and efficient, especially when the schema of the JSON data is the same throughout a table.
It's...
2019-02-26
21 reads
Searching Complex JSON Data
Watch this week's video on YouTube
Computed column indexes make querying JSON data fast and efficient, especially when the schema of the JSON data is the same throughout a table.
It's...
2019-02-26
10 reads
Azure SQL Database and Trace Flags
You cannot enable trace flags (globally or by session) within Azure SQL Database but did you know that some global...
2019-02-26
615 reads
#ConditionalCode in Python with Dominika
Here it is! The second article about Python! This time I have described how tou use simple conditional code in...
2019-02-26
820 reads
One Peril of Database Proliferation
By now many of us have upgraded from SQL Server 2008R2 and we’re on the “regular Cumulative Updates” train now. For the rest, it’ll (hopefully) happen soon. And since...
2019-02-26
17 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