Getting Started with Change Data Capture – Part 2
The Change Data Capture feature of SQL Server captures DML changes happening on a tracked table. Arshad Ali demonstrates how this feature can be leveraged.
Worst Day as a DBA
Survey - The DBA-Team wants to hear about your worst day as a DBA. Did a database restore fail due to corruption? Did you accidentally connect to Prod instead of Dev and truncate a table? Anonymity available. The best story will win a $50 Amazon voucher.
Developers, developers, developers
A survey of developers on Stack Overflow has some interesting results that Steve Jones notes. Some of them might just impact our careers as data professionals.
SaaS and Multi-tenancy Models
If you need to architect a multi-tenant Analysis Services project, what are your options? This piece from Sean Woehrle shows four options and explains why he picked a particular one.
Rapid SQL Server Database Deployment
With the right tools, it is possible to rapidly deploy upgraded databases. By deploying early in development, it's easier to iron out any potential problems that the new deployment could cause in production long before it's time to actually release the software.
SQL Monitor Custom Metric: Performance-Related Database Settings
If you manage a server where you are not in complete control of the creation of databases, or you’re unfamiliar with what settings to change, you may miss things out or set them incorrectly. This metric could pick up on issues that affect performance in obscure ways, and saves you having to search for them when a system suddenly stops performing as you would expect.
SQL Saturday #262 - Boston
This free event is coming to Boston on March 29, 2014. Grant Fritchey and many others will be speaking, so make sure you register soon while spots are available.
An Integrated Process for Software Delivery.
Developers, enamored of the integrated approach to Software Delivery, would like to be able to respond to business need in business time, adding functionality when the need is recognized, instead of 6-9 months later after it's gone through the sclerotic IT purchasing and configuration process.
Continuous Delivery
The practice of continuous software development is growing, with continuous integration, deployment, and delivery being topics that Steve Jones is learning about. Today he talks about delivery.
Why I Developed SQL Code Guard: A Fairy Tale from a DBA
This is the story of how a free addin for SSMS, SQL Code Guard, was created and joined the Red Gate SSMS Ecosystem project.
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers