Daily Coping 30 Sep 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-30
19 reads
Undercover Academy – SQL Server Backup and Recovery – Module 1: Taking and Restoring a Backup
Welcome along to the first module in our Undercover Academy’s SQL Server Backup and Recovery course. In this module we’re going to look at how to take and restore...
2020-10-07 (first published: 2020-09-30)
341 reads
Join SQLSat Memphis Virtually This Saturday
Looking forward to presenting at SQLSaturday Memphis virtually this weekend!
Both my wife and I are on the schedule for Saturday, and the organizers chose interesting nontechnical topics for both...
2020-09-29
19 reads
Failing SQL Agent Jobs – Part 4
Here we are, another Tuesday!! It is time for our Fourth and final installment in the Failing SQL Agent Jobs series. This week, we will cover how to store...
2020-10-06 (first published: 2020-09-29)
336 reads
I Want PASS to Survive
I want PASS to survive. I can say that unequivocally, because this organization has been a part of my career, my job, and my life for twenty years. Many...
2020-10-09 (first published: 2020-09-29)
427 reads
Daily Coping 29 Sep 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-29
21 reads
sp_RestoreScript 1.7 Released
sp_RestoreScript 1.7 has been released. For information and documentation please visit https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/ Changes in 1.7 New Parameters @IncludeCopyOnly – 1 – Copy only backups are included0 – Copy only...
2020-09-29
189 reads
Fixing the PoSh Hotkey in ADS
I installed the PowerShell (PoSh) extension in ADS recently. This is available in the extension pane, and once installed, you get the 4th icon on the right added to...
2020-10-06 (first published: 2020-09-28)
151 reads
Capture Execution Plans Only For Long Running Queries
I love questions. Most of all, I love questions I can answer. I spotted this question recently: How can I use Profiler to capture execution plans for queries over...
2020-10-05 (first published: 2020-09-28)
531 reads
Daily Coping 28 Sep 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-28
41 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