Note: co-authored with Christine Assaf, originally published in the now-defunct PASS Blog.
Historical data analysis that is naïve to past discrimination is doomed to parrot bias. How do we combat bias in our...
2020-09-23
11 reads
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)
473 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
22 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
12 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
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,236 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
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)
383 reads
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
What is returned as a result set when I run this command without a new seed value?
See possible answers