SQL SERVER – Unable to Remove Replication Publication – Could not Delete the Subscription at Subscriber ‘SubServer’ in Database ‘SubDB’
While playing with my lab server having broken replication, I encountered an error message when I was trying to remove publication. In this blog, we would learn about how to fix error Could not delete the subscription at Subscriber ‘SubServer …
A Presenter’s Guide to the Stack Overflow Database
The place that saves your job You present on SQL Server topics at user groups and conferences, and you’ve been wondering how to get started with the Stack Overflow public database. Here’s a quick list of things to know. For stable demos, us …
Forget GDPR. Think HIPAA, SOX, PCI, SHIELD and the CCPA.
Data protection legislation in the USA, however, has been around for a long time, and more is on the way, and for most types of business, the changes will move compliance from a minor issue to a big concern. How to fix SQL Server disk I/O bottlenecks ( …
SQL SERVER – Useful Queries – Why Huge Transaction Log (LDF) File? Fix Low Disk Free Space on the Drive Used by LDF Files
During my Comprehensive Database Performance Health Check engagement with the client, one of the most common issue found was the huge size of the transaction log file. In this blog, we would learn about useful queries which I use to help my client in f …
Wait Stats When VSS Snaps Are Slow
Deus Redux A while back I wrote about the Perils of VSS Snaps. After working with several more clients having similar issues, I decided it was time to look at things again. This time, I wanted blood. I wanted to simulate a slow VSS Snap and see what ki …
SQL Prompt code analysis: avoid non-standard column aliases
Phil Factor looks at SQL Prompt code analysis; column alias violations and the right way to alias How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix …
Aggregate Data for the Last Day of the Month
On some occasions you will need to aggregate Data for the Last Day of the Month. This article explains how.
Information Security in Practice
Along with the GDPR, regulations require that confidential data is protected and used properly. In this article, William Brewer discusses the ways that data manages to migrate around the organisation and the challenges found in protecting that data.
SQL SERVER – Error: 17300 – The Error is Printed in Terse Mode Because There was Error During Formatting
One of my clients contacted me in a situation where their business was down! Their production SQL Server instance used by their Human Resource team was unable to start in a clustered environment. In this blog, we would learn about how to fix the error: …
How Trace Flag 2335 Affects Memory Grants
This trace flag is documented in KB #2413549, which says, “Using large amounts of memory can result in an inefficient plan in SQL Server.” The details are a little light, so let’s run a quick experiment with: SQL Server 2017 CU 8 …
SQL Server Performance Tuning Scripts, Tips and Tricks
In this webcast, Tim Smith takes a look at various tips and tricks to assist you with performance tuning your SQL Server databases. Knowing how to find and resolve problems is key to improving performance, so join him to learn how to optimize your syst …
Installing Ubuntu in Level 1 of the Stairway to SQL Server on Linux
In this first article of the Stairway to SQL Server on Linux, learn how to set up your host server.
SQL SERVER – How to Generate Random Password? – Enhanced Version – Part 2
I have previously written about Random Password before in the blog posts here, here and here. This blog is sent by James Curran, who has created the following generate random password stored procedure keeping the base of the original solution of T …
A Common Query Error
So Many Choices When you only need stuff from a table where there’s matching (or not!) data in another table, the humble query writer has many choices. Joins In/Not In Exists/Not Exists No, this isn’t about how NOT IN breaks down in the pre …
Practical PowerShell Processes with SQL Change Automation
How to use the PowerShell cmdlets of SQL Change Automation to take the source code of a database from a directory, validate it, document it and then create a NuGet package of it.