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-16 (first published: 2012-11-06)
8,345 reads
HuggyBear
- Interests: Lately (2019): windfoiling or windsurfing with a Skroka foil....amongst many other supposedly 'extreme' sports, but which are really just the norm for people raised in Lotusland aka Vancouver, BC, lower-mainland region, Sea-to-Sky country as we know it.
- Blog: http://dbhive.blogspot.com/
- Jobs: SQL DBA, Data Engineer, Migrator, Clusterer, Security Implementor
- Website: https://ca.linkedin.com/in/intellabase
- LinkedIn: https://ca.linkedin.com/in/intellabase
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,241 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,509 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,684 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
15,578 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,398 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,306 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
5,162 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,115 reads
Blogs
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Connect resiliently to SQL Server
Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...
Forums
Powershell extract
$server = "YourServer" $db = "YourDatabase" $sqlFile = "C:\path\query.sql" $outFile = "C:\path\output.xlsx" # Run...
Powershell extract
$server = "YourServer" $db = "YourDatabase" $sqlFile = "C:\path\query.sql" $outFile = "C:\path\output.xlsx" # Run...
Some query values change when query is run but not others. Why?
Hi everyone I have a 1000 line SQL query that is too long to...