Tip: Resetting Identity Fields
How to reset an identity field to the next contiguous value, after deletions.
How to Identify and Backup the Latest SQL Server Database in a Series
I have to support a third party application that periodically creates a new database on the fly. This obviously causes issues with our backup mechanisms. The databases have a particular pattern for naming, so I can identify the set of databases, however, I need to make sure I'm always backing up the newest one. Read this tip to ensure you are backing up your latest database in a series.
SQL Saturday #172 - Washington, D.C.
A free day of training in the US nation's capital. Come join in if you are nearby.
Stairway to Server-side Tracing - Level 10: Profiler versus Server-Side tracing
Compares and contrasts tracing using Profiler with server-side tracing, illustrating important performance differences so that one can choose the right tool for the task at hand.
Auditing SQL Server 2012 Server Roles
My organization is looking at SQL Server 2012 and I know that the ability to create roles at the server level is a new feature. Since this is new and impacts security, how do I handle them and how do I audit them?
Don't Explain Too Much
Having management get too involved in technical details can cause problems. Steve Jones notes that technical people should minimize the details when communicating with management.
Database Deployment: The Bits - Getting Data In
Quite often, the database developer or tester is faced with having to load data into a newly created database. What could be simpler? Quite a lot of things, it seems.
Free eBook: The Red Gate Guide to SQL Server Team-based Development
Get a free ebook that discusses how you can better manage your team development.
Advanced Event Behavior – Level 10 of the Stairway to Integration Services
The tenth article of this series starts to look at more advanced events and how we can use those events to better control and enhance our packages.
Regulators, Mount Up
If you are bound by HIPAA regulations, you may have more auditing in your future. If you're not, perhaps you should still pay attention to the criteria being used for auditing.
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers