Avoid “Constants” in T-SQL
Here we look at a common query "anti-pattern" that can create performance problems - and how you work around it.
2023-06-14
374 reads
Here we look at a common query "anti-pattern" that can create performance problems - and how you work around it.
2023-06-14
374 reads
Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and talked out new feature. In this post we'll just take a brief look at it,...
2023-06-14 (first published: 2023-05-31)
582 reads
Yesterday at Microsoft Build, a significant announcement took place—the introduction of Microsoft Fabric, which is now available for public preview. Satya Nadella, the CEO of Microsoft, went as far...
2023-06-14 (first published: 2023-05-31)
592 reads
I repeat the phrase “If you aren’t monitoring it, you can’t measure it” all the time. Through my IT career, this has been a constant. If you don’t have...
2023-06-14
In this post we’ll look at how you interact with data that is encrypted using Always Encrypted. The examples here will show how you run queries from SSMS, in...
2023-06-13
17 reads
I’m in the UK again, for my second trip this year. This time I have no commitments for speaking or presenting anything. I’m in town for a Marketing get-together...
2023-06-12
13 reads
The HUGE announcement at Microsoft Build yesterday was Microsoft Fabric (see Introducing Microsoft Fabric: Data analytics for the era of AI), now available in public preview. I have been...
2023-06-12 (first published: 2023-05-24)
517 reads
In SQL Server you can also compress your encrypted backups. Unlike TDE this has been possible with Backup Encryption since the feature was first made available, and there have...
2023-06-12 (first published: 2023-05-24)
336 reads
There is a scenario I have seen again and again. A company has developed a nice piece of software which many clients are running with happily. Then along comes...
2023-06-12
11 reads
Hello Dear Reader! Let's address the missing week. Last week I was really behind due to the move. We did not have a Monday video and despite my best...
2023-06-12
9 reads
By Brian Kelley
Microsoft Fabric is the new data offering in Microsoft Azure and there is a...
By Rohit Garg
In the expansive landscape of software development, the relationship between Database Administrators (DBAs) and...
We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight! The...
Hi everyone, So I have a SSIS package that performs some importing/exporting from MySQL...
Hello SSC, I am not a DBA,. I have some DBA knowledge, but my...
I am currently working on creating a baseline for our server, using various counters...
In which editions of SQL Server 2022 can you run Reporting Services?
See possible answers