SQL Server – max server memory
Another re-post of a video from last year, this time showing you an in-built protection of setting max server memory...
2019-03-14
494 reads
Blog Posts
#ITechDay in Warsaw
We were enjoying Thursday on conference in Warsaw. We have arrived pretty lately but easily saw the awesome atmosphere there....
2019-03-13
256 reads
Achieving SQL Server HA/DR with a mix of Always On Availability Groups and SANless SQL Server Failover Cluster Instances
Introduction
The topic of mixing SQL Server Failover Cluster Instances (FCI) with Always On Availability Groups (AG) is pretty well documented....
2019-03-13
2,559 reads
Data Warehousing Tip #9 – Test at Volume
My next tip is to test your BI solution with the volume of data that you are expecting. This is...
2019-03-13 (first published: 2019-02-25)
1,957 reads
Database Development Gone Wrong
I recently shared a story about how I was personally responsible for a development project going off the rails (and oh boy, did it go off the rails). It’s...
2019-03-13
4 reads
Database Development Gone Wrong
I recently shared a story about how I was personally responsible for a development project going off the rails (and...
2019-03-13
431 reads
Differences Between the Various Binary Collations (Cultures, Versions, and BIN vs BIN2)
(last updated: 2019-03-15 @ 02:45 EST / 2019-03-15 @ 06:45 UTC )
Binary collations are, in many ways, simpler to understand than non-binary collations...
2019-03-13
13,889 reads
Does SQL Server 2019 run on Ubuntu 18.04 LTS?
Yes. Here’s the proof from an output of SELECT @@VERSION: [crayon-5c98bf6b3202b962253620/] Here’s a screenshot of me running mssql-cli on the...
2019-03-13
685 reads
Enable Mail Profile – Back to Basics
I’ve seen many people go through the trouble of setting up database mail and configuring SQL Agent Alerts only to...
2019-03-13
272 reads
How Do You Export A Database in Azure Data Studio
I’ve been writing a bunch about Azure Data Studio. I’ve also been recording videos on the topic. A comment I...
2019-03-13 (first published: 2019-02-25)
2,380 reads
Blogs
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...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Forums
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
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers