Altering a column in a large table: A case study
Fair warning, this is a discussion piece. I had a task, I went through several possibilities and I’m going to...
2016-07-14
1,053 reads
Get Your Email Out of my ETL
Question from someone in one my recent classes: “What tool do you use to send email from ETL processes?” My...
2016-07-14
679 reads
Live From @LearningTree London Backup and Restore - Day 3
This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration in the LEC in London. Following on from last weeks...
2016-07-14
465 reads
SQL Server Desired Enhancements
SQL Server 2016 has come with a ton of cool features, bells, whistles and well cool stuff (yes redundant). That aside, what are some of the really cool features...
2016-07-13
7 reads
SQL Server Desired Enhancements
Happy Belated Birthday
The monthly Data Professionals blog party has come and gone. It happens the second Tuesday of every month...
2016-07-13
524 reads
Source Control for the Reluctant DBA
This is the 2nd post in the series named SQL Server and Continuous Integration. The previous post explained the problems I...
2016-07-13
936 reads
Getting Started with Database DevOps, DLM, and New Tools
Next Tuesday is the next installment of our DLM series from Redgate. I’m off the hook, with Grant and Arneh...
2016-07-13
579 reads
Azure SQL Data Warehouse is now GA
The Azure SQL Data Warehouse (SQL DW), that I blogged about here, is now generally available. Here is the official...
2016-07-13
598 reads
Thanks, Karla
I heard the news this week, and I’m still sad. Karla Landrum is leaving PASS after five years of acting...
2016-07-13
500 reads
Live from @LearningTree London - Security Day - Day 2
This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration in the LEC in London. Following on from last weeks...
2016-07-13
385 reads
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
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
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...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers