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,064 reads
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,064 reads
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
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,433 reads
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,223 reads
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,362 reads
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,206 reads
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,758 reads
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,028 reads
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,786 reads
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,344 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
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