Setting up Transparent Data Encryption (TDE)
You can set up Transparent Data Encryption (TDE) when you first create a database, or you can apply it to...
2018-01-26
2,633 reads
You can set up Transparent Data Encryption (TDE) when you first create a database, or you can apply it to...
2018-01-26
2,633 reads
When I was writing my post Capture the most expensive queries across your SQL Server using Query Store a question crossed...
2017-11-16
614 reads
SQLCMD variables can be a useful way of having changeable parameters for your SQL scripts, allowing you to specify the...
2017-11-01
8,431 reads
I love the STATISTICS IO and STATISTICS TIME commands. They are such a powerful and easy way to be able...
2017-10-17
496 reads
As mentioned in my post Auditing Data Access in SQL Server for GDPR Compliance CDC can be a useful tool for...
2017-10-03
14,200 reads
We’ve all had to solve deadlock issues. Identify the two conflicting pieces of code, work out an appropriate change to...
2017-09-19
687 reads
SQL Server functionality can move on pretty quickly sometimes, and it’s not always all about the big features but the...
2017-09-12
1,813 reads
A while ago now I was running some Performance Tuning workshops and was asked how you can find out which Statistics...
2017-09-01
394 reads
In the monthly SQL blogging party that is T-SQL Tuesday (brainchild of Adam Machanic), Kendra Little has invited us this...
2017-08-08
1,416 reads
Even though SQL Server automatically updates statistics in the background for you, you may find there are times when you...
2017-08-01
2,381 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers