Data Quality
Problems with data quality are easier and cheaper to prevent than to solve later. In this article, Joe Celko talks about data quality and where the issues tend to happen.
Get Patched If Not Supported
Many organizations that run older versions of SQL Server are not patched.
Getting Sneaky With Forced Parameterization
In which Erik works around the documented limitations with CROSS APPLY.
SQL Server AlwaysOn Availability Groups Monitoring and Alerting - Part 2
In this tip we look at some additional scripts that you can use to monitor your SQL Server AlwaysOn Availability Groups.
Deploy the Database First
Steve Jones thinks it's important that we be able to deploy almost any changes to our databases without breaking applications.
Power BI Introduction: Visualizing SQL Server Audit Data — Part 9
SQL Server Audit is a powerful feature that can help you comply with regulations such as HIPAA and SOX, but it’s not easy to view the data collected. In this article, Robert Sheldon demonstrates how Power BI can be used to view and filter SQL Server Audit results.
Code Reviews
This week Steve Jones asks about a concept that he used early in his career: code reviews. It's a good practice, but it seems as though it's fallen out of favor with many developers.
Streamline Log Shipping Failovers: DR Made Just For You…
A look at a SQL script solution that can help you easily fail over and back from log shipping scenarios.
Not So Forced Parameterization
If you can't get forced parameterization to work due to variables, try using a temp table instead.
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers