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,272 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,238 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,676 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,519 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,390 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,283 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,110 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,110 reads
Blogs
Deleting Stale Local Database Git Branches with SSMS–#SQLNewBlogger
By Steve Jones
I wrote a post recently about pruning branches in git. That’s part of the...
Microsoft Fabric shortcuts
By James Serra
I talked about Microsoft Fabric shortcuts in my blog post Microsoft Fabric – the...
Develop and Test Your Rollback Plan
By Brian Kelley
he rollback plan... what to do when things go wrong to get back to...
Forums
Blocking question
Hi all, We have a SSIS package that does 2 things in parallel: moves...
can I monitor auto stats updates through extended events?
We have pretty big tables very sensitive to stats with many updates. Our systems...
Question of the Day
Post Restore Tasks for the Resource Database
I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?
See possible answers