A late-breaking change that arrived in SQL Server 2022 is an important one that could be a new line item in your health checks.
The basics:
Starting with SQL Server 2022,...
2022-11-30 (first published: 2022-11-17)
566 reads
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
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)
546 reads
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
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
37 reads
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,559 reads
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
31 reads
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
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
32 reads
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
By Kevin3NF
The Two-Layer Model Explained “We added them to the database, but they still can’t...
By Steve Jones
Someone sent me this code. WITH p AS ( SELECT ID, ROW_NUMBER() OVER (ORDER...
Wondering which database to tackle first? I’ve got the lowdown on the top free...
Hi we often use non expiring windows and sql accounts to actually run (credential...
Comments posted to this topic are about the item Changing the Paradigm of Work
Comments posted to this topic are about the item Removing a File
I attempted to use ALTER DATABASE to remove a file from my filegroup in SQL Server 2022. There are 4 files in this filegroup, but I don't need them all. However, I received a message that the file was not empty. How do I empty this file so it can be removed?
See possible answers