Debugging database mail issues in your SQL Server with T-SQL
Problem. Your database mail suddenly stopped sending out email notifications on completed jobs and tasks. You try to send out...
2013-09-17
1,109 reads
A Rickety Stairway to SQL Server Data Mining, Part 14.3: Debugging and Deployment
By Steve Bolton
…………Throughout this series of amateur self-tutorials in SQL Server Data Mining (SSDM), I’ve often said that working with...
2013-09-16
1,445 reads
SQL Saturday #191 Kansas City was Great
This past weekend I presented a preview of my SQL PASS Summit spotlight session entitled “Squeezing Top Performance From Your...
2013-09-16
582 reads
New Whitepaper: 5 Most Common Critical SQL Integrity Issues
Have you been putting off running integrity checks on your databases? Are you unsire where to start or what to...
2013-09-16
1,209 reads
Backups, Encryption and Branding in San Diego
This weekend is SQL Saturday #249 in San Diego. I’m looking forward to the trip for a few reasons, but...
2013-09-16
831 reads
PowerShell – List Local or Remote Programs with an Exclusion List of Programs
This post is to list all the software installed on your local or remote machines. The exclusion list is an...
2013-09-16
1,276 reads
How to Check SQL Server Evaluation Version Expire Date ?
SQL Server Evaluation Edition is available free of cost. It’s a trial version & valid for limited time of period. The...
2013-09-16
27,047 reads
Last Weeks Top “Reading” Links #49
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-09-16
928 reads
Why the Lazy Spool Is Bad
First thing, there are no bad operators, just bad parents, uh, I mean query writers, or database designers, or ORM...
2013-09-24 (first published: 2013-09-16)
3,582 reads
DBA Myths: You can’t use an alias in an UPDATE statement.
I’ve found a very common belief among users of T-SQL (both DBAs and Developers) is that you can’t use an...
2013-09-16
889 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers