Tip: COLLATE for “Cannot resolve collation conflict” error
Some data professionals are VERY well versed with collation, and some never ever have to touch the concept. That second...
2014-03-17
570 reads
SQL Awesomesauce
SQL for Everybody
I read a terribly excited blog this morning by a guy who had just discovered Alt-F1 in SSMS. (If you don’t...
2014-03-14
640 reads
Bad Ideas: Alert Storming
Fellow DBA: There are so many alerts! It takes me a long time to get through them all. How do...
2014-03-10
673 reads
Configure static or dynamic IP and DNS with Powershell
I work in a lot of different offices and conference venues, in addition to my home office. At home, I need a...
2014-03-03
876 reads
Expiration dates: SQL Server 2008 and 2008 R2
SQL Server is a software product, right? And software has a history of having bugs, getting updates, and having support...
2014-02-24
577 reads
Home Workspace: Standing Desk
Ever since I worked in an office with adjustable standing desks, I’ve been thinking about getting a standing desk for...
2014-02-17
487 reads
What’s the CPU usage on the server? Use #Powershell!!
We have here an easy, handy-dandy way to find out how much CPU is in use on your server. Of...
2014-02-10
559 reads
Blockades and ladders to learning new tech
It’s been a long time since I’ve been a true newbie to a technology. There are plenty of things I...
2014-02-03
587 reads
Applied SQL: LIKE ‘whatever’
Today let’s play around with the LIKE operator. Like, totally. Like, Introduction Like “determines whether a specific character string matches...
2014-01-27
743 reads
Tip: Jobs without a scheduled run
It’s awfully comforting to see all those backup and maintenance jobs in your SQL Agent list, isn’t it? It’d be...
2014-01-22
522 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