Minimizing impact of widening an IDENTITY column – part 4
Aaron Bertrand continues his series on widening an IDENTITY column, showing how he would attack the problem directly.
NCAs and NDAs
When accepting an offer of employment, what do you do about NCAs and NDAs that you might be asked to sign? Steve Jones offers some advice. (This editorial was originally published on Mar 12, 2008. It is being re-run as Steve is on holiday.)
Towards a Single Management Stack
Phil Factor argues that with both SQL Server and PowerShell now running on Linux, the latter becomes increasingly important in achieving the goal of a single management stack for databases across all hosting environments.
The Exploratory Testing Chrome Plugin
If all your application testing is done by test experts, who know how to record images, do screen-capture, write issue-reports to TFS more appropriate and consistent format and so on, you probably don't need the 'Exploratory Testing' chrome plug-in. Otherwise, it is worth checking out Ambily KK's walkthrough.
Comprehensive Baseline Collector Solution (Updated)
There are no more excuses for not having baseline data. This article introduces a comprehensive Free Baseline Collector Solution
The Copy Cat Poll
This poll asks about copies, specifically those of your databases. How many do you keep around? How much extra storage does this cost? Steve Jones thinks that most organizations have quite a few copies, which can use a lot of resources.
Writing Better T-SQL: Top-Down Design May Not be the Best Choice
One of the best ways in which you can build better applications is by learning to write better T-SQL. Mickey Stuewe begins a new series showing how you might start to think about writing queries.
Writing Better T-SQL: Top-Down Design May Not be the Best Choice
One of the best ways in which you can build better applications is by learning to write better T-SQL. Mickey Stuewe begins a new series showing how you might start to think about writing queries.
Writing Better T-SQL: Top-Down Design May Not be the Best Choice – Part II
A second part to the series by Mickey Stuewe on writing better T-SQL looks at some of the issues of using views in a complex query.
Writing Better T-SQL: Top-Down Design May Not be the Best Choice – Part II
A second part to the series by Mickey Stuewe on writing better T-SQL looks at some of the issues of using views in a complex query.
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers