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,577 reads
Using DMVs to Find the Ports that SQL Server is Listening On
The other day I was asked to provide the port number that a SQL Server instance was listening on. As...
2010-11-29
3,222 reads
How Do I Change SSRS Report Credentials with Powershell?
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,717 reads
Careful with the New MCM Requirements
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
Want to Make Your SQL Server Run Faster for Free?
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,197 reads
Get Drive Space Including Mount Points
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,775 reads
Troubleshooting SQL Server Error: 18456, Severity: 14, State: 16
I recently had to track down a rogue process that was failing to log in on one of my servers....
2010-11-12
857 reads
A Brute Force Way to Compress a Database
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
When is that Restore Going to Finish?
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
Stop Forgetting the DAC
From time to time I hear of DBAs that had to restart the SQL Server service on a 2005 or...
2010-10-06
951 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
Impact of adding the opening of the Master Key in a SQL job for SSIS packages
Bonjour à tous, J'ai un problème d'exécution de mes packages SSIS. A chaque opération...
Being an extroverted introvert at a conference
Comments posted to this topic are about the item Being an extroverted introvert at...
Need to group the same valued ID fields to run an aggregate average over them
I have data that contains poll results, with the poll_id consistuting a single row...
Question of the Day
How are statistics stored?
How are the statistics for query optimization stored in SQL Server?
See possible answers