Every time you access a relational database to make a query, you have an important decision to make: What is the appropriate isolation level for your query? If you get this wrong, the consequences can be serious. Deadlocks, Dirty reads, Non-repeatable reads, or poor performance. We're in luck, because Robert Sheldon once more answers those questions that are awkward to ask in public.
One of the primary advantages of Platform-as-a-Service solutions offered by Microsoft Azure is the ease with which scaling can be implemented. While SQL Database facilitates both vertical and horizontal scaling approaches, scaling it out is considerably more challenging. In this article, we will provide a high-level overview of both vertical and horizontal scaling methods available with Azure SQL Database.
The SQL Server community is amazing, and Steve Jones hopes we continue to be close as we grow. He brings light on an idea to grow us larger, but smaller.
Voting is now open for the Tribal Awards. Vote for one of the 5 finalists in each category to win a fabulous* prize.
This article will discuss a case study of utilizing a SSIS package to export a table that has columns with data type varchar(mx) and text to an Excel file.
Kathi Kellenberger demonstrates how to start adding visual flair to your SSRS reports, using its impressive set of visual controls, ranging from basic charts to gauges, indicators, sparklines, and maps.
When undisciplined users access your search forms, you can control their behavior and limit the results they're presented with in various ways.
Steve Jones notes that disasters come in all shapes and sizes, but a little prep that you might not have thought of can reduce the scale of the issues.
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
When preparing documents for immigration in Malaysia, accuracy and compliance are essential. Working with...
Comments posted to this topic are about the item Let's Talk Community Events!
Hi as shown below a replication target requires a primary key. if we want...
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers