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.
Using pw-inspector in Brute Force attack on SQL Server
In this article we’re going to explore the world of brute force attacks and pwd-inspector for tests with SQL Server
How to Remove Transparent Data Encryption From a Database
There may be a time when you want to turn off transparent data encryption on one of your TDE enabled databases. In this tip, Greg Larsen shows you how simple it is to remove Transparent Data Encryption.
SQL SERVER – DBA Disruptors eCourse
Performance tuning is indeed very simple in the real world but many experts often project it as a very complex task. I often think it is because that expert would love to project that they are master of some complex art, which is not easily mastered. H …
Setting Up SQL Server: People Still Need Help
I Like What’s Happening I wanna start off by saying that I like what Microsoft has been doing with the setup process — it made a lot of sense to add the tempdb configuration screen, and having a checkbox to turn on Instant File Initializati …
The conflict between data protection and DevOps
Data breaches are the new normal – according to the Identity Theft Resource Center there were nearly 1,600 of them in 2017 in the US alone, exposing 179 million records. No wonder companies want to keep data confidential and protected. At the sam …