No, Accelerated Database Recovery Doesn’t Fix NOLOCK.
I have never seen a T-SQL feature that people love as much as NOLOCK.
Migrate SSRS Reports to a New Server in Just a Few Clicks
Learn how to migrate SSRS reports to a new server using SSRS Reports Migration Wizard. Step-by-step guide to move reports, data sources, and datasets in just a few clicks.
The Improvement Limit
How much of a difference can you make at a job? Steve has a few thoughts today.
Schema Design Basics for Power BI
You have a Power BI project that generates real-time reports for an inventory management system that uses SQL Server. You are aware that Power BI performance is heavily influenced by how your data is structured in SQL Server but don’t have a clear understanding of how to optimize your SQL data structure for Power BI. In this article, we look at different ways to structure the data and tables to help improve Power BI query performance.
Technological Dinosaurs or Social Dinosaurs?
You're going to have to bear with me on this one because my thoughts aren't fully formed. As I'm sure I've mentioned, I'm a little elderly (and you thought I was going to talk about radios). As such, I've seen the death of a few technologies. I may not have shared this widely, but my […]
Distributed Availability Group Health: T-SQL and Zabbix
Spotting synchronization disconnects between a primary and a secondary data center in a distributed availability group configuration can be hard, so here are valuable tools to help you with it
Start Fixing Your DB with Better Code
The best way to improve your database performance is with better code. We all know that, but few of us actually end up making those changes.
Secure PostgreSQL in Docker: SSL, Certificates & Config Best Practices
Running Postgres in Docker is great for a quick test but what if you want it to behave like a proper, production-style setup with SSL encryption, certificate-based authentication, persistent volumes, and custom configurations? In this article, we’ll find out how
Is Rolling Back The Same as Failing?
When you must rollback a deployment of changes, is that a failure of the process? The development effort? Or something else?
Stairway to Azure SQL Hyperscale – Level 3: RBPEX Caching Layer Internals
In this level of the Stairway to Azure SQL Hyperscale we learn about the read-only layer that speeds up queries.
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers