“My transaction log is too big!”
“My transaction log is too big!” I wish I had a dime for each time phrase has been spoke, written,...
2013-08-12
1,666 reads
Blog Posts
Create A Job Feed For Your LinkedIn Group
LinkedIn groups have the option to enable a Jobs section and associated discussion area. Potential employers can post jobs directly...
2013-08-12
822 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
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
Extreme Transaction Processing (XTP, Hekaton) – the solution to everything?
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
My complete last...
2013-08-12
2,183 reads
I Hesitate to Commit
At work my boss this week my boss gave me some quotes about me. We solicit feedback twice a year...
2013-08-12
2,234 reads
SQL – One Query to fetch SQL Jobs Details of All SQL Version – 2000/05/08/R2
Single Query to fetch complete details of sql jobs and you can run it across different version of SQL [2000/2005/2008...
2013-08-12
8,166 reads
SQLSaturday Curacao 2013
Are you looking for some beach time? I know I am. I also know that I will probably get some of that beach time at an upcoming SQL Saturday....
2013-08-12
26 reads
SQLSaturday Curacao 2013
Are you looking for some beach time? I know I am. I also know that I will probably get some...
2013-08-12
668 reads
SSRS – Download all RDL files from Report Server in one go.
Introduction
People working on SSRS are well aware that “Report Manager” does not support downloading all the report files (.rdl files)...
2013-08-12 (first published: 2013-08-07)
13,403 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