Database Fundamentals #18: The SELECT Statement
In my previous Database Fundamentals post, I showed you how to use the Query Designer to build a query. That...
2018-07-23
824 reads
Zero Width Characters
Another bit of miscellany, this one shows how you can use zero width characters to tag/fingerprint data. Reminds me of...
2018-07-23
552 reads
PsPing your Azure SQL Server
PsPing tool is part of the sysinternals PsTools download found – ( https://docs.microsoft.com/en-us/sysinternals/downloads/psping) This is the tool of choice when wanting to...
2018-07-23
665 reads
Off on Holiday
Another break for me. This might actually be the first year I use all my vacation allowance.
In any case, I’m...
2018-07-23
843 reads
Processes can dramatically improve your work until they don’t.
As always with something like this, I like to start with a definition so we are all starting in the...
2018-07-23
176 reads
Set up Instant File Initialization for SQL Server
When a space growth operation is done within SQL Server (create, restore, auto-grow) the engine places zeros across the file...
2018-07-23
132 reads
10 SQL Saturdays – and a personal parting of ways
I’ve written many posts on SQL Saturdays , especially the one at Louisville. This one is a bit different. This is...
2018-07-23
240 reads
Extended events (XE): Create a simple XE
When someone says still uses SQL Profiler.
Image is taken from hereAn ancient, dark place, a source of many legends and...
2018-07-23
1,553 reads
Taking the Linux plunge
I’m a Windows guy.
Kinda have had to be, given my profession as a SQL Server DBA. But recently I’ve become...
2018-07-23
308 reads
Why Availability Databases Are Not Synchronizing?
If you are working on SQL Server Availability Group Databases, you may have seen that Availability Group is online but at-least...
2018-07-23
938 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