Environment Variables in SSIS Packages and Configuration Tables
Configuration tables are a best practice in just about any SSIS environment. They make it easy to update multiple packages...
2013-08-12
2,155 reads
DMV-13 : Finding locking & blocking……..sys.dm_tran_locks
sys.dm_tran_locks DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms190345.aspx
Returns information about currently active lock manager resources. Each row...
2013-08-12
1,260 reads
SQLSaturday #235 NYC Super Countdown! - Almost Here!
And so, the countdown begins for the super spectacular,
extraordinarily exceptional, amazingly awesome, fabulously fantastic confab
that is known as SQLSaturday
#235 in...
2013-08-11
865 reads
Colorado SQL Events : August 2013
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-08-10
564 reads
SQL Server – How to Move Database Files – Data File and Log File – From One Drive Location to the Other
Most of the DBAs at some point of time in their career should have faced at-least one of the below...
2013-08-10
1,399 reads
The Man Who Thinks He Can
Hello Dear Reader! I got a lot of great questions during the 24 Hours of PASS last week and I'm...
2013-08-09
838 reads
Reblog: August 2 to August 8
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-08-09
887 reads
Windows Failover Cluster Monitor
Windows Failover Clusters are fantastic, they provide High Availability for mission critical SQL Server instances and make my life as...
2013-08-19 (first published: 2013-08-09)
2,841 reads
Speaking at PASS Summit 2013
PASS Summit 2013 will be my fifth Summit to attend. I wrote a blog post about how different my fourth...
2013-08-09
645 reads
Something for the Weekend – SQL Server Links 09/08/13
It’s Something For The Weekend(SFTW) time, I hope you’ve had a great week! Some of you may have noticed that I’ve been a tad quieter in the SQL community...
2013-08-09
17 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers