Cardinality Estimation for a Predicate on a COUNT Expression
Paul White takes you on an optimizer journey, exploring how SQL Server comes up with cardinality estimates for COUNT queries.
Fixing an SSRS Password Error while Changing Credentials
SSRS Password error while changing credentials
Encrypting SQL Server: Dynamic Data Masking
Dynamic Data Masking is a good way of rendering data unreadable for such purposes as user-acceptance testing, or demonstrating an application. It doesn't encrypt the data, and a knowledgeable SQL user can defeat it. However it provides a simple way to administer from the database what data the various users of a database application can and can not see, making it a useful tool for the developer.
Azure DWH Part 8: Accessing Azure SQL Data Warehouse with C#
In this new article, we will learn how to access to our Azure DWH tables using C#.
Cracking the SQL Code
Checking for coding style and reviewing code is so much easier when using techniques and tools to help, as long as the tools are your slave, and not your master.
The Human Impact of a Capable AI
Computing systems and algorithms continue to improve, especially in the machine learning and AI spaces. What does that mean for us humans?
Backing Up SQL Server Databases Hosted on Azure VMs
Join Marcin Policht as he provides a comprehensive overview of the different backup options applicable to Azure SQL Server VMs with database files stored on VM disks.
Why people flocked to the SQL Clone live stream event
On March 29, over 650 people tuned in from around the world to find out more about Redgate's new database provisioning tool, SQL Clone. The webinar answered the FAQs, included some in-depth demos, and gave a look into the technology behind the tool. Catch up with the recording.
How Long Before Your Database Runs Out of Space?
Almost all SQL Server databases grow in size over time. Capacity planning is an important activity for the DBA. You need to know how long before you run out of space long before you actually do. Here are some helpful tips and tricks.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
SSoL Support on the OS
Comments posted to this topic are about the item SSoL Support on the OS
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers