Adding a Primary Key to a Prepopulated Table using a SQL Server Integration Services Package
In this tip we look at how you can use SSIS to build a package to add a primary key to an existing table that does not already have a primary key.
SQL SERVER – Small Backup for Large Database
Recently, I had a very interesting experience with one of my customer while working with them on Comprehensive Database Performance Health Check. The issue was related to small backup for the large database and it was so much interesting I decided to s …
[Video] Office Hours 2018/11/28 (With Transcriptions)
This week, Brent, Tara, and Richie discuss storing phone numbers in a database, forced parameterization, how AI will affect DBA jobs in the future, what languages a DBA needs to learn, backup issues, measuring the overhead of transparent data encryptio …
How to Start Database in a Single User Mode? – Interview Question of the Week #202
Question: How to Start Database in a Single User Mode? Answer: We all needed one time or another time this particular help. Whenever there is a corruption or any issue with SQL Server where we need to stop access from external users/system. We hav …
What Is SQL Injection?
Say we have a stored procedure that queries the Stack Overflow database. We have two separate parameters, @DisplayName and @Location, so folks can search for people by name, location, or both. For performance reasons, we decide to build dynamic SQL:CRE …
SQL SERVER – What is the Meaning of PREEMPTIVE_HTTP_EVENT_WAIT? How to Fix it?
While playing with my SQL Server in Azure VM, I faced an interesting issue. I did some change in networking to avoid internet access by creating an outbound rule and then I started facing this issue. In this blog, I would explain one of the possi …
Updated First Responder Kit for November 2018: Get Into Sports Dummy
COACH! I dunno, I just like this picture. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1786 – @dallyhorton made a good point: if we’re gonna warn you about Change Tracking, we should te …
A Basic Technique for Masking Address Data using Data Masker
Grant Fritchey shows how to use Data Masker to obfuscate address data, wile ensuring that the masked data retains the characteristics and distribution of real address information.
SQL SERVER – Finding The Oldest Query Plan From Cache
Often people ask where do I come up with a new blog idea everyday. Well, answer is that I am not the one who comes up with new idea, it is all of you who inspire everyday with a new idea. Recently one of the healtch check client Comprehensive Data …
Power BI Introduction: Visualizing SQL Server Audit Data — Part 9
The series so far: Power BI Introduction: Tour of Power BI — Part 1 Power BI Introduction: Working with Power BI Desktop — Part 2 Power BI Introduction: Working with R Scripts in Power BI Desktop — Part 3 Power BI Introduction: Workin …
There is a New COUNT in Town
We have all been using the COUNT(DISTINCT) function to return row counts for a distinct list of column values in a table for ages. With the introduction of SQL Server 2019, there is a new way to get an estimate of distinct row values and counts for a t …
Tales From Overindexing: Too Many One Column Indexes
Master Plan Sometimes you see a query, and it’s hitting one table, and then the query plan looks like a vase full of spaghetti. Usually, there’s a view involved. Usually. Sometimes, there’s just really weird indexing. Here’s A T …
Meeting Preparation for SQL Server Projects
Learn how to prepare for technical meetings including knowing your environment, being calm, business values, solution focus and more.
T-SQL Decommenter Part IV
Examination of the comprehensive test suite for the T-SQL Decommenter, along with explanation of the modifications made to produce the production version. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk edi …
SQL SERVER – SQL Server Agent Missing in SQL Server Management Studio (SSMS)
Learning never stops when you are a consultant. While doing my recent Comprehensive Database Performance Health Check my client asked an interesting question. He informed that he is not able to see SQL Server Agent node in SQL Server Management St …