Conditionally Retry a Failed Job
We have jobs that run in the early morning to load data to our data warehouses and other systems, and...
2017-07-03 (first published: 2017-06-23)
1,509 reads
Blog Posts
Creating the SSIS Catalog
If you are building SQL Server Integration Services (SSIS) packages, using the SSIS catalog as a deployment target is usually...
2017-07-03
705 reads
Database Mirroring Needs FQDNs
A quick basic post, and one that I’ve forgotten. Since blogging is a good way to remind myself of things,...
2017-07-03
472 reads
Monday Coffee: Alerts & Checks
Hope you all had a good weekend, the Lions won so I’m pretty happy.
Over the weekend I was thinking about...
2017-07-03
359 reads
SQL Homework – July 2017
For years Russ Thomas (b/t) has done a Monthly DBA Challenge and in fact I’ve used it as insperation a...
2017-07-03
413 reads
SQL Server Database Files Wise I/O Latency Details PART#1
One of the real-world I/O troubleshooting problems is – If you have your databases spread across multiple LUNs and you want...
2017-07-03 (first published: 2017-06-26)
4,249 reads
Creating a PowerShell Module and TDD for Get-SQLDiagRecommendations
Yesterday I introduced the first command in the SQLDiagAPI module. A module to consume the SQL Diagnostics API.
I have been...
2017-06-30
908 reads
Friday Reading 2017-06-30
Second test for the British & Irish Lions tomorrow, they need this one to keep the series alive. I’ll be up...
2017-06-30
573 reads
Implementing Fuzzy Sets in SQL Server, Part 11: Fuzzy Addenda
By Steve Bolton
…………One of the key reasons I looked into the topic of fuzzy sets in the first place was...
2017-06-30
714 reads
SQL Server Permissions and Security Principals on UserGroup.tv
You can now watch my presentation on SQL Server Permissions and Security Principals from SQLSaturday Houston 2017 on UserGroup.tv, a...
2017-06-30
675 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers