One of the few good, safe uses for the local SSD D: volume of an Azure VM is for SQL Server TempDB data and log files. There's a gotcha....
2020-09-21 (first published: 2020-09-14)
472 reads
It's a full day at Houston Tech Fest 2020 for us. Speaking at Houston TechFest is an decade-long annual tradition interrupted only by a hurricane and one year where I...
2020-09-12
21 reads
Hi internet!
Thanks to the surprising number of you who joined our first ever virtual meeting of the Baton Rouge .NET and SQL Server User Groups tonight!
I presented on the...
2020-09-09
10 reads
Note: co-authored with Christine Assaf, originally published in the now-defunct PASS Blog.
In January 2020, Robert Williams was arrested on his front lawn in a suburb of Detroit, Mich., after police...
2020-08-26
1 reads
Looking forward to virtually presenting at SQLSaturday Auckland 2020 this weekend! I'll be presenting at 10:45AM Auckland time on Saturday, but that's 5:45pm Friday evening where I am in Central...
2020-08-03
10 reads
On July 14, Christine and I presented at the Houston SQL Server and BI User Groups' virtual meeting. Our joint presentation is one of our favorites to present, Ethics in Modern Data.
Thanks...
2020-07-14
2 reads
Recently I had a client and their vendor trying to configure a firewall for a new installation of SQL Server 2019 on Windows Server 2019.Connections to the SQL Server...
2020-07-17 (first published: 2020-07-13)
1,234 reads
Looking forward to presenting with my wife Christine Assaf our talk on Ethics in Modern Data at the Houston Area SQL Group and BI Group's virtual meeting on Tuesday...
2020-07-01
13 reads
If you've tried doing Backup to URL with SQL Server using a Shared Access Signature (SAS) certificate and received this error: Error: 18204, Severity: 16, State: 1.BackupDiskFile::CreateMedia: Backup...
2020-06-16 (first published: 2020-05-28)
379 reads
On Saturday May 2 Christine and I are presenting at the Data Community #DataWeekender Europe 2020 online conference, an all-online free virtual popup Microsoft Data Conference hosted by various professionals...
2020-05-02
14 reads
By Ed Elliott
All Spark Connect Posts I have just finished an update for the spark connect dotnet...
By Steve Jones
One of the things I’ve been experimenting with in AI is taking things other...
By Steve Jones
I’ll be at SQL Bits tomorrow, Saturday Jun 20, 2025 for the final day...
In Azure SQL DB, i want to merge records from the staging table to...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
We are in the process of upgrading to SQL Server 2022 and would like...
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers