Extended Events Made Easy: Using XEvent Profiler
In this post we’ll look at how quick and easy it is to use the XEvent Profiler to create an...
2019-04-26 (first published: 2018-09-25)
5,116 reads
Matthew McGiffen
- Twitter: @MattMcGiffen
- Website: https://matthewmcgiffen.com/
How Secure is Transparent Data Encryption (TDE) – and How to Prevent Hacking
TDE is commonly described as “at-rest” encryption, i.e. it protects your data wherever it is stored on disk. This includes...
2019-04-26 (first published: 2018-01-03)
3,166 reads
Implementing Temporal Tables Where You Have Existing Data
In my post about auditing tools in SQL Server I mentioned a few tools we have at our disposal for...
2019-04-26 (first published: 2017-10-24)
4,442 reads
MAXDOP, Parallelism and the Cloud
Parallelism and MAXDOP The pros and cons of parallelism have always been with us in SQL Server and I blogged about this a couple of years ago. This is...
2019-04-26 (first published: 2019-04-03)
2,226 reads
Measuring SQL Query Performance
When running workshops on the subject of SQL Query Performance the first question I always ask is how do we measure...
2019-04-26 (first published: 2017-05-24)
32,691 reads
Overview of Encryption Tools in SQL Server
More and more people are considering some level of encryption against their data stored in SQL Server. In many cases...
2019-04-26 (first published: 2017-12-05)
4,211 reads
RDS encryption vs TDE
If you’re starting to use cloud services, the number of options available can be confusing. Particularly when they may seem...
2019-04-26 (first published: 2018-04-17)
5,795 reads
Rotating TDE Certificates without re-encrypting data
I talked previously about why we have each of the layers in the encryption hierarchy used to support TDE (Transparent...
2019-04-26 (first published: 2018-03-28)
3,037 reads
Row-count Estimates when there are no Statistics
I was discussing Cardinality Estimation with a colleague recently and the question came up, what cardinality does SQL Server use...
2019-04-26 (first published: 2017-06-28)
2,801 reads
SQL 2016 – Clone Database with Query Store
This is a quickie post to introduce the new DBCC command CLONEDATABASE.
Okay so this isn’t technically a SQL Server 2016...
2019-04-26 (first published: 2017-03-20)
2,345 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...