Acids and Databases: A look at ACID and transactions
Relational database management systems (RDBMS) such as SQL Server, Oracle, MySQL, and PostgreSQL use transactions to allow concurrent users to...
2017-07-26
149 reads
Blog Posts
Azure Cloud “Fear” Busting #1 – Security
So here we go, the first installment of my cloud blog series. From my experience this concern is a common...
2017-07-26 (first published: 2017-07-12)
1,745 reads
Creating SQL Server containers with docker compose
Up until now my posts about containers have been talking about working with one container only. In the real world...
2017-07-26 (first published: 2017-07-12)
7,838 reads
Speaking at TechMentor – Redmond
I’ll be speaking at TechMentor, August 7-11 at Microsoft HQ in Redmond. Surrounded by your fellow IT professionals, TechMentor provides...
2017-07-26
319 reads
Speaking at TechMentor – Redmond
I’ll be speaking at TechMentor, August 7-11 at Microsoft HQ in Redmond. Surrounded by your fellow IT professionals, TechMentor provides you with in-depth, immediately usable training that will keep...
2017-07-26
12 reads
Create a Staging Load with Biml
When designing the ETL architecture for new or changing systems, one of the more common needs is to create a...
2017-07-25 (first published: 2017-07-12)
1,331 reads
One SSMS Trick That Will Make You a Faster Query Builder
Watch this week's video on YouTube
Here's the scenario: you copy and paste some code into a query you are building. A few minutes later you need that same snippet...
2017-07-25
8 reads
SQL Server Management Studio: Video Tutorial
SQL Server Management Studio is the all in one tool for developers and DBAs alike to work with SQL Server....
2017-07-25
462 reads
SSoL: Where are my data and log files?
I don’t think most of us need to know Linux, but if you end up managing a system, it’s good...
2017-07-25
709 reads
Streaming ETL: SQL Change Data Capture (CDC) to Azure Event Hub
[read this post on Mr. Fox SQL blog]
I had a recent requirement to capture and streamreal-time data changes on several SQL database...
2017-07-25 (first published: 2017-07-11)
11,199 reads
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