Database Superhero Adventures, July 2018
Sorry readers, I was having some many adventures there was no June edition. In May, I had SQLSaturday Dallas where...
2018-07-02
448 reads
Introduction to Docker and Docker Toolbox
The article gives some knowledge about getting started and utilizing Docker containers. The focus is all about understanding Docker and...
2018-07-02
502 reads
SQL Homework – July 2018 – Create a SQL Agent Job
For this month’s homework let’s try something a bit different. SQL Agent jobs are a very powerful tool frequently used...
2018-07-13 (first published: 2018-07-02)
2,014 reads
Azure SQL Elastic Pools – Moving Databases
If you read official Microsoft documentation about naming conventions for your SQL elastic pools, it is hard to find any...
2018-07-09 (first published: 2018-07-02)
1,952 reads
Cloud Backup Comparison
I used to use Crashplan. This was about $150 a year, but I could to 5 machines. I used to...
2018-07-06 (first published: 2018-06-29)
3,009 reads
Learning Goals –June 2018 Update
The June update for T-SQL Tuesday #97. I made a plan and it’s hard to stick to.
tl;dr – Very little done.
I...
2018-06-29
812 reads
Azure Data Lake Store Gen2
Big news! The next generation of Azure Data Lake Store (ADLS) has arrived. See the official announcement. In short, ADLS Gen2 is the combination of the current ADLS (now called...
2018-06-28
14 reads
Azure Data Lake Store Gen2
Big news! The next generation of Azure Data Lake Store (ADLS) has arrived. See the official announcement.
In short, ADLS Gen2 is...
2018-07-10 (first published: 2018-06-28)
2,579 reads
I’m Speaking At SQL Saturday Baton Rouge!
I am excited to announce that I have been selected to speak at SQL Saturday Baton Rouge (#749) on August...
2018-06-28
358 reads
Minion Backup: Restore to another server
Minion Backup makes your SQL Server backups effortless, of course. And even better, it makes your restores effortless! Oh, yes….yes indeed. Today we’ll look...
2018-06-28
464 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
An Eventual Consistency Scam
Comments posted to this topic are about the item An Eventual Consistency Scam
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers