Presentations for SQL Server Beginners
Tired from all those blog postsFor my final blog post in the #gettingstarted, #iwanttohelp series, I decided to curate a...
2016-12-23 (first published: 2016-12-05)
3,281 reads
Blog Posts
SQL Saturday Returns to Rochester!
The Rochester, NY chapter of PASS is holding our 6th annual SQL Saturday on April 29th, 2017! As always, RIT is hosting our event on campus.
SQL Saturday is a free day of training centered...
2016-12-23
2 reads
Survey: Skipping the Holidays?
For a little pre-holiday fun, I’ve got a simple scenario to present to you, and I am interested in your...
2016-12-23
378 reads
What Agent Job is Running – Back to Basics
It is quite common to be required to investigate performance issues on the server. With this, it is occasionally necessary to be able to interpret an obfuscated job name....
2016-12-23
33 reads
What is Constraints in TSQL?
Constraints let you define the way the Database Engine automatically enforces the integrity of a database. Constraints define rules regarding the...
2016-12-23
321 reads
Actual Chats: RIGHT OUTER joins in the wild
Colleague:
I think I just encountered my first Right join
*shocked* Me:
huh. weird.
a rare Right Join has appeared!Colleague:
catch it!Me:
You use ON. It's...
2016-12-22 (first published: 2016-12-06)
2,885 reads
Database Backups – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-12-22
685 reads
Database Backups – Back to Basics
In this article, we will explore database backups. More specifically, how do you truly know if you have a successful backup? Here's a hint: it has to deal with...
2016-12-22
6 reads
Quick Command Shells–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-12-22
609 reads
SSIS Custom Logging Levels
In my ongoing series on ETL best practices, I recently wrote about the importance of logging in extract-transform-load processes. For...
2016-12-22
482 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Changing the AG Listener
Comments posted to this topic are about the item Changing the AG Listener
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers