SQL Index Creation Using DROP EXISTING= ON
When you are making changes to an existing Non-Clustered index SQL Server provides a wide variety of options. One of the more frequently used methods is DROP EXISTING; in...
2021-02-17
29 reads
Blog Posts
Azure SQL Database Gen4 to Gen 5
For the past year Microsoft have said that Generation 4 hardware is soon coming to its end of life. I know many installations that have used Generation 4 over...
2021-02-16
946 reads
Create a Polling Loop in PowerShell
This is one way to create a polling loop in PowerShell. I’m sure there are several options, but this one works well for the use case. Backstory I needed...
2021-02-16
16 reads
Daily Coping 16 Feb 2021
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...
2021-02-16
9 reads
Data Mesh defined
The two latest trends in emerging data platform architectures are the Data Lakehouse (the subject of my last blog Data Lakehouse defined), and the Data Mesh, the subject of...
2021-02-16
12 reads
Manually updating Statistics
Having up to date statistics is vital for getting the best performance out of your queries. Even though SQL Server automatically updates statistics in the background for you, you...
2021-02-16
229 reads
Unable to Connect to Target Server? But, I'm Already Connected!
I am working on an Azure SQL Database migration from an on-premises VM, and at the client's request I am working through the BACPAC Import/Export process rather than using...
2021-02-16 (first published: 2021-02-08)
335 reads
Using Data Compare with Recent Data Only
This is a post that looks at how to compare data changes in recent data. A customer recently asked me about looking at a table, and choosing specific data...
2021-02-16 (first published: 2021-02-08)
277 reads
About Friendship and Using Optional Stored Procedure parameters in Azure Data Factory
(2021-Feb-07) "You've Got a Friend in Me" is a well-known song written by Randy Newman and featured in one of Disney's animated films. If I hadn't had a chance...
2021-02-15 (first published: 2021-02-07)
215 reads
Daily Coping 15 Feb 2021
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...
2021-02-15
14 reads
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers