SQL Agent Jobs – When Success is Failure
Have you ever run across an issue that made you take a step back and scratch your head? Recently, I had this exact situation hit my Inbox. One of...
2021-03-31
442 reads
T-SQL Tuesday #135 – Tools Used for Getting Organized
This month’s T-SQL Tuesday is being hosted by Mikey Bronowski. The subject he chose is “The outstanding tools of the trade that make your job awesome.” Tools are the...
2021-02-09
15 reads
What is a model database?
Do you ever take a look at SSMS in the System Databases section? People that are new to SQL Server might or might not know much about these essential...
2021-02-04 (first published: 2021-01-26)
593 reads
[MSSQLTIPS] Rookie of the Year Candidate – Vote for ME
Welcome to the New Year of 2021. For some people I know, they might prefer to forget most if not all of 2020. Personally, I am not one...
2021-01-04
15 reads
[PowerShell Newbie] Using Start-Transcript
This week we are going to launch a blog series geared towards folks that are new to PowerShell. The growing popularity of automation is seeing people getting started with...
2020-12-09 (first published: 2020-11-24)
432 reads
Export SQL Server Configurations for DR purposes
Is your SQL environment prepared for a disaster? There are big and small disasters and depending on your perspective big and small can mean different things. Preparing your environment...
2020-11-16 (first published: 2020-11-10)
640 reads
Blog Refresh – Growing Readers
Happy Tuesday everyone… In early 2017 I started blogging on this site in hopes of sharing new technology I was learning. The first post was as you could guess,...
2020-10-27
29 reads
How To: Create Schema Only Database Copies
Have you ever been asked to make a schema only copy of a database? What is your preferred method to complete this request? Below we will discuss how to...
2020-10-26 (first published: 2020-10-20)
1,427 reads
Copying an Azure SQL Database
Copying an Azure SQL Database is a vital skill when managing cloud databases. Recently, a request was received from the “business”. They wanted to create a copy of an...
2020-10-21 (first published: 2020-10-13)
279 reads
Checking your dumps!!!
No, No, not those dumps: SQL Server Memory dumps!! Recently, I was on Slack and wondered into the #firstresponderkit channel. I am a big fan of all the First...
2020-10-13 (first published: 2020-10-06)
677 reads
Blogs
Azure Networking: Designing for Change
By John
Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...
The Case of the Forgotten Compatibility Mode – Scooby Dooing Episode 3
Like any good mystery, some SQL Server problems look spooky on the surface but...
Using Customer Docker Compose File Names
By Steve Jones
As I use containers more and more to run various things, I decided I...
Forums
SQL Server authentication vs. Trusted connection
I maintain an application written years ago, where the database is on a Windows...
The Duplicate Cursor
Comments posted to this topic are about the item The Duplicate Cursor
Concerns over AI Chat Privacy
Comments posted to this topic are about the item Concerns over AI Chat Privacy
Question of the Day
The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers