I just noticed today that there is a new blade in the Azure portal when creating a new SQL Server virtual machine. I’ve been looking for an announcement regarding...
2019-06-11 (first published: 2019-05-24)
542 reads
If you are like me and were unable to get away from the office to attend Microsoft Build 2019 you will be glad to know that Microsoft has published...
2019-05-10
82 reads
If you are deploying SQL Server in Azure, or any Cloud platform for that matter, instead of just provisioning storage like you did for your on-premises deployments for many...
2019-05-14 (first published: 2019-05-02)
665 reads
Intro On July 9, 2019, support for SQL Server 2008 and 2008 R2 will end. That means the end of regular security updates. However, if you move those SQL...
2019-05-02 (first published: 2019-04-19)
1,013 reads
Introduction
The topic of mixing SQL Server Failover Cluster Instances (FCI) with Always On Availability Groups (AG) is pretty well documented....
2019-03-13
2,418 reads
If you have been following my blog, you probably know that I write a lot of step-by-step guides for building...
2019-02-15
1,184 reads
Introduction
If you are reading this article you probably are still using SQL Server 2008/2008 R2 and want to take advantage...
2019-02-04
961 reads
If you are still running SQL Server 2008/2008 R2 you probably have heard by now that as of July 9,...
2019-01-09
50 reads
Recently I have had a number of customers looking for a high availability solution for MaxDB on Windows in the...
2018-12-28
431 reads
If you are anything like me, you might have a few different Google accounts that you work with on a...
2018-11-01
32 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...
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
Comments posted to this topic are about the item SQL Cookbook: Query Solutions and...
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