Another Dive into Transaction Log File Forensics
Over the past three years since I first took a look at the
insides of a Transaction Log file, I have...
2012-11-15 (first published: 2012-11-06)
8,071 reads
HuggyBear
Quebec Human Rights Commission Ignores Racism Documented by CRT Judge (Civil Evidence), Ignores E-mail Evidence & Botches Up Investigation
After seeking justice in this matter for years, I am obliged to bring this issue up again (since it affects...
2012-08-02
1,231 reads
Latest Presentation on SQL Server Mirroring Given at Transcontinental's Offices
With a handful of System Administrators, Network Specialists and DBAs, I gave my third presentation on SQL Server Mirroring this...
2012-06-14
1,501 reads
Optimise Your Disk Subsystem I/O with An Index File Group and Index Compression
As a DBA who is always seeking solutions to performance bottlenecks, amidst the
daily rituals of validating backups and other regular...
2012-06-06
1,674 reads
Top 20 Reasons Why Bill 101 Is a Nuisance to Modern Quebec Society: Greatest Hits of the Tyranny of Bill 101
Quebec's Shameful, Coercive Language Law‘Je me souviens’ les palmarès Top 20 de la loi 101 sacrée qui nuit à la...
2012-05-09
14,318 reads
SQL Server 2012 Synopsis - Mission Critical Applications Combined With The Fantastic 12 New Features or "The Baker's Dozen" as described by Microsoft this Week
Notes by Hugo S., Print Screens from three Microsoft Presentations
7 December, 2011 with Additions combined from early February 2012 day-long...
2012-03-27
1,261 reads
Free E-Book on SQL Server 2012, Great Job by Ross Mistry and Stacia Misner (yes, they have done it again :)
Free E-Book: Introduction to SQL Server 2012
Ross Mistry and Stacia Misner have again done a wonderful job on this free...
2012-03-20
2,380 reads
Activity Monitor in SQL Server 2012: an Improved Embedded Optimisation Gizmo for the Thrifty DBA
Waaaay back in December ‘08, after having spoken briefly at SQL teach here in Montreal thanks to MVP Paul Nielsen...
2012-03-18
21,267 reads
Avoid Database Restore Issues (Errors 3219 or 3514) by a Simple Script Edit - the DB Restore Work-around
Starting with the 1000 foot view: During the process of applying changes to a production database - let's call it Change...
2012-03-18
4,989 reads
PlayBook OS 2 Update Awesome, Why Pay Three Times the Price for an IPad?
I have become dependent on my tablet, here is why, thanks to a great summary from the Globe and Mail.
2012-02-23
1,109 reads
Blogs
Failing SQL Agent Jobs – Part 4
By gbargsley
Here we are, another Tuesday!! It is time for our Fourth and final installment...
I Want PASS to Survive
By Steve Jones
I want PASS to survive. I can say that unequivocally, because this organization has...
Daily Coping 29 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
If no record (from table variable) found in a table return null value instead
Hello, I am sure this is simple but I just can't get what I...
In search of Database scripts version control strategy or process
Hello! I am looking for strategy/process that helps to achieve database scripts version control...
Calculating offset (adding days to a date but keeping same day name of week)
Ok, I've written a bit of code and it's horrible and looks terribly inefficient...
Ask SSC