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,576 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,576 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,204 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,530 reads
Ever since I first heard about the Microsoft Certified Master program I have been interested. The prestige of the certification...
2010-11-23
668 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,191 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,744 reads
I recently had to track down a rogue process that was failing to log in on one of my servers....
2010-11-12
851 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,010 reads
I spent a good portion of last weekend restoring databases from backup due to a large release. Nothing went wrong,...
2010-10-27
841 reads
From time to time I hear of DBAs that had to restart the SQL Server service on a 2005 or...
2010-10-06
949 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers