Certificate Based Application Roles
What if I told you that you could sign an assembly that your Windows application uses with a certificate, load...
2010-11-30
1,580 reads
What if I told you that you could sign an assembly that your Windows application uses with a certificate, load...
2010-11-30
1,580 reads
The other day I was asked to provide the port number that a SQL Server instance was listening on. As...
2010-11-29
3,257 reads
Today’s script took a long time to write. The concepts are fairly simple and the resulting script is quite trivial...
2010-11-24
6,926 reads
Ever since I first heard about the Microsoft Certified Master program I have been interested. The prestige of the certification...
2010-11-23
671 reads
I know I do!
The trick is to properly manage your VLFs.
What are VLFs? The short anser is that VLF...
2010-11-19
2,201 reads
Today’s post is a quick one that came out of a conversation on Twitter. To make a long story short,...
2010-11-15
2,804 reads
I recently had to track down a rogue process that was failing to log in on one of my servers....
2010-11-12
873 reads
There are a handful of scripts out there to compress all of of the objects in your SQL 2008 database...
2010-11-05
2,014 reads
I spent a good portion of last weekend restoring databases from backup due to a large release. Nothing went wrong,...
2010-10-27
843 reads
From time to time I hear of DBAs that had to restart the SQL Server service on a 2005 or...
2010-10-06
955 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