I'm speaking at PASS Data Community Summit 2022
Looking forward to speaking in Seattle at next week's PASS Data Community Summit by Redgate. I'll be speaking both as a representative of my role on the Microsoft Database...
2022-11-11
5 reads
Will Assaf
A simple lab to demonstrate the danger of NOLOCKs in INSERT statements
The READ UNCOMMITTED isolation level, which the NOLOCK table hint activates, is not to be trusted when it comes to writing data. You are not always protected by error...
2022-09-07 (first published: 2022-08-25)
533 reads
SQLSaturday Baton Rouge is back!
Looking forward to jambalaya at #SQLSatBR in THIS SATURDAY! Also looking forward to speaking and seeing all of you there, I guess... Register today: https://sqlsaturday.com/2022-08-06-sqlsaturday1026/After I stepped down from the...
2022-08-02 (first published: 2022-08-01)
19 reads
Speaking on Ethics in Modern Data at Improving Edge 2022
Christine and I are looking forward to speaking at the Improving Edge conference, co-presenting our session on Monday, June 6th. Our presentation on “Ethics in Modern Data” features topics relevant...
2022-06-03
26 reads
SQL Server linked server to .xlsx Excel files
A question came up recently concerning whether it was still possible to connect to .xlsx Excel files as SQL Server linked servers.
Short answer: Yes, it's possible as recently as...
2021-11-26 (first published: 2021-11-05)
1,535 reads
Ethics in Modern Data at Music City Tech 2021
On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at the Music City Tech 2021 Virtual Conference. Thanks for joining our presentation!
This session explores a...
2021-09-16
23 reads
Ethics in Modern Data this Saturday with the South Florida Data Geeks
This Saturday Aug 7, Christine and I will present our joint presentation on Ethics in Modern Data.
This session will explore a variety of considerations that modern data scientists and...
2021-08-03
5 reads
Ethics in Modern Data at the Baton Rouge Analytics and Intelligence Network (BRAIN)
On July 27, Christine and I will present our joint presentation on Ethics in Modern Data. Looking forward to speaking at yet another technical user community looking to jumpstart...
2021-07-27
23 reads
Speaking at Data ANZ 2021
Looking forward to speaking at Data ANZ 2021 this weekend. Data ANZ "is the data community event for the whole of Australia and New Zealand (and the world)"!
I'll be presenting...
2021-06-24
9 reads
SQL Server Admin Best Practices with DMVs at GroupBy Americas 2021
On Tuesday I'm looking forward to presenting again at GroupBy Americas on a topic that was voted on by the attending public. This presentation "SQL Server Admin Best Practices...
2021-05-24
30 reads
Blogs
Check your regions people
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
Using Git Prune–#SQLNewBlogger
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
Microsoft Purview new data governance features
By James Serra
Starting last week is a rollout of the public preview of a new and...
Forums
Read Only Replica in SQL Server Standard
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Read Only Replica in SQL...
Identifying Customer Buying Pattern in Power BI - Part 1
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
Backup of encrypted databases failing
I've had some backups of my encrypted databases failing with the error "BACKUP 'DBName'...
Question of the Day
Read Only Replica in SQL Server Standard
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers