I’m working on a project where it’s useful to automate environment setup and teardown for testing some devops deployment scenarios for databases using transactional replication. To make this easier,...
2020-06-19 (first published: 2020-06-05)
843 reads
I blog a fair amount and do you want to know what the most annoying part of the process is? ... Continue reading
2020-06-18
18 reads
I was recently asked a question on a forum by a person who was frustrated with all the tool choices we have for measuring performance. Moreover, they were frustrated...
2020-06-18
7 reads
I’ve 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-06-18
2 reads
I recently posted a graph to twitter and asked people to explain it. Let’s look at the graph. The graph is from Fitbit. It shows the number of steps...
2020-06-18 (first published: 2020-06-04)
420 reads
My background
My background has been very strongly focused on the .NET world, with a focused start on SQL Server, later branching into learning PowerShell.
This world was heavily focused on...
2020-06-18
10 reads
I’m thrilled to have recently recorded a podcast with Kevin3NF of Dallas DBAs called Data Bits. I had an absolute blast with it, and we laughed for over an...
2020-06-18
1 reads
On July 11 at 3pm MDT, Rob Farley and I will be hosting a webinar on report design in Power BI. We will take a report that does not...
2020-06-18
9 reads
I’ve been building ETL processes for many years, and I’ve learned two universal truths: data preparation is messy, and you must always secure your data prep area. A data...
2020-06-18
3 reads
Triggers. Blech. Triggers are a really really cool feature of SQL Server, that are continuously misused and cause all kinds ... Continue reading
2020-06-18 (first published: 2020-06-04)
336 reads
By Ed Elliott
SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is...
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Quite a long title for a short blog post ??While deploying a DACPAC (from...
Comments posted to this topic are about the item Don't Create Workslop
Comments posted to this topic are about the item What is the original database...
Comments posted to this topic are about the item The DBScan algorithm tutorial
What is returned when this code is run?
SELECT ORIGINAL_DB_NAME()See possible answers