sp_SrvPermissions & sp_DBPermissions V4.0
These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data...
2014-01-15
898 reads
Blog Posts
SQL Server Filtered Index Performance
Filtered Index – Database Performance
SQL Server 2012 includes filtered indexes and is a great feature for Business Intelligence and Reporting databases. ...
2014-01-15
992 reads
Two-Factor Authentication
Something you have and something you know – that’s the heart of two-factor, sometimes called multi-factor, authentication. RSA was for years...
2014-01-15 (first published: 2014-01-09)
6,351 reads
2014 Polar Plunge #SQLPlunge
In just a couple months… on March 1… I’m going to jump into a lake in Minnesota. Now it’s cold...
2014-01-14
641 reads
Flash sale – discount code for SQL Saturday Nashville Precon
Announcing a flash sale today from 10a-12p Central time for my upcoming SQL Saturday Nashvillepreconference training session ‘Virtualization for SQL...
2014-01-14
556 reads
Google Buys Nest
I was a bit sad to see that Google bought Nest. I like upstarts that see a problem and solve...
2014-01-14
629 reads
How to throttle your Storage with Resource Governor in SQL Server 2014
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-01-14
1,637 reads
Independent consultant: How to find work
When I talk to people about switching from being a salaried employee to an independent consultant (see my presentation How to...
2014-01-14
1,823 reads
Laying The Ground For A Successful Reporting Project
Building a reporting system from the ground up is a daunting task. Such a big project usually involves intricate resource...
2014-01-14 (first published: 2014-01-09)
3,150 reads
One error which you don’t want to see while doing upgrades – Missing MSI !
The cached MSI file ‘C:\Windows\Installer\<name>.msi’ is missing !!! This is one error which you don’t want to see when you are...
2014-01-14
1,206 reads
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers