-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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 noticed some more great products to enable forensics such as ApexSQL ( which makes the job simple), Lumigent Log Explorer, and other Free tools mentioned below, as well…

Read more

1 comments, 8,016 reads

Posted in The Database Hive for SQL Server DBAs on 6 November 2012

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 millions of people in our province), regarding multiple incidents that occurred, while working as a Database Administrator for the Provincial Government.

This is just a quick post to make public…

Read more

0 comments, 1,231 reads

Posted in The Database Hive for SQL Server DBAs on 2 August 2012

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 afternoon.
Please find the Presentation Slide Deck here on SkyDrive.




Contenu - Contents


Introduction to-à Microsoft SQL Server Mirroring – Haut disponibilité avec des bases de données en mirroir. An…

Read more

0 comments, 1,501 reads

Posted in The Database Hive for SQL Server DBAs on 14 June 2012

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 tasks, profiting from File Groups on differing disk subsystems, in this case for Indexes, arose as flavor of the week. With this option, note that I am assuming one…

Read more

0 comments, 1,671 reads

Posted in The Database Hive for SQL Server DBAs on 6 June 2012

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 société Québécoise.

The author is well aware of the typical and detestable knee-jerk reaction this pamphlet shall provoke, but my francophone brethren know me well enough to understand that…

Read more

6 comments, 13,747 reads

Posted in The Database Hive for SQL Server DBAs on 9 May 2012

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 presentation of Server 2012’s Top 12 new features. Thank you Frank Wiemer (Data Platform head, Eastern Canada, based in Montreal, for your presentation slides). With these notes, I have…

Read more

0 comments, 1,260 reads

Posted in The Database Hive for SQL Server DBAs on 27 March 2012

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 e-book


You can the full details of the introduction here.



The book contains 10 chapters and 268 pages:

PART I   DATABASE ADMINISTRATION (by Ross Mistry)
1.   SQL…

Read more

0 comments, 2,363 reads

Posted in The Database Hive for SQL Server DBAs on 20 March 2012

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 (SQLserverBible.com), on this subject, the following is a re-introduction to one of our favorite Management Studio features: Activity Monitor. 
To use AM, right click on a SQL Server…
Read more

0 comments, 21,225 reads

Posted in The Database Hive for SQL Server DBAs on 18 March 2012

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 Management (pick your ITIL or COBIT method accordingly), we should always go through a thorough testing process on an exact copy and environment too, if possible, of the production…

Read more

0 comments, 4,951 reads

Posted in The Database Hive for SQL Server DBAs on 18 March 2012

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. Read more

0 comments, 1,108 reads

Posted in The Database Hive for SQL Server DBAs on 23 February 2012

Thanks to Brian Kelly for a Great Presentation on Auditing for SQL Server - Please Find the Notes Below

 For those interested in following a great MVP who contributes regularly on Infrastructure and Security, here are notes I took from his latest presentation:

https://skydrive.live.com/#!/view.aspx?cid=49B6E513E0DDE7B8&resid=49B6E513E0DDE7B8%211607

I admit some screen shots are hard to read due to SkyDrive's optimisation, therefore I have given the link to the Archive of the presentation… Read more

0 comments, 1,026 reads

Posted in The Database Hive for SQL Server DBAs on 10 February 2012

Notes from 'Putting a Better SQL Server in Production' - the Ideal Pre-Prod checklist from Robert L. Davis

 

Last week, I sat in on Putting a Better SQL Server in Production - this is an ideal pre-prod checklist from Robert L. Davis.

The original slide deck available here (on demand), from his January 19th presentation:

I have placed a copy that includes my notes here… Read more

3 comments, 1,318 reads

Posted in The Database Hive for SQL Server DBAs on 25 January 2012

Congratulations to Philippe Falardeau for Monsieur Lazhar's Oscar Nomination (Played by Fellag, the Algerian Comedian Famous For Le Visa)

 

Congratulations to Philippe Falardeau - he has made the official Oscar Nominations!

http://www.monsieurlazharmovie.com/ tourné à Montréal – Filmed in Montreal! The hilarious Algerian comedian Fellag is the star who plays the teacher.  Watch Fellag's joke about getting a Visa for France :) http://www.youtube.com/watch?v=fNgGEZCdVqI un des meilleurs comédiens d’Algerie J… Read more

0 comments, 2,718 reads

Posted in The Database Hive for SQL Server DBAs on 25 January 2012

The Hockey Team to Represent a Truly Bilingual City: Let’s Give Cunneyworth The Proper Chance He Deserves to Lead the Canadiens to a Stanley Cup Someday as Al McNeil Did in 1971

 

The Media in Quebec has opened up 2012 with a continuation of what it wishes to disseminate, or more probably, employs to sell more papers easily, regarding a minority within the minority –  the unilingual Anglophone: representing less than twenty percent of a one million strong community that the… Read more

4 comments, 3,070 reads

Posted in The Database Hive for SQL Server DBAs on 19 January 2012

Free SQL Performance Tool Worth Checking

First, I’d like to wish my readers a very safe, happy and prosperous 2012 (santé, properité, et bonheur).  This is the start of a fourth year of blogging at SSC, and now that cumulative views have reached over half a million, I anticipate greater contributions than in…

Read more

0 comments, 1,605 reads

Posted in The Database Hive for SQL Server DBAs on 17 January 2012

Notes from Mission Critical Environments in SQL Server 2012, Webinar by Marc Theoret

The other day I sat in while Marc Theoret gave a great overview of the what is coming in SQL Server 2012 - Enjoy the summary thanks to SkyDrive

Read more

0 comments, 1,422 reads

Posted in The Database Hive for SQL Server DBAs on 11 December 2011

With A Little Bit of Care, You Can Use the DMVs to Auto-Create Some Missing Indexes, Here Is How (but with Caveats)

An Automagic Index Creation Script? No, but a start to deal with Missing Indexes

Here's the useful join from a number of Index related DMVs - it grabs the top 50 possible missing indexes ordered by priority

select top 50 priority = avg_total_user_cost * avg_user_impact *(user_seeks + user_scans)
,d.statement
,d.equality_columns Read more

0 comments, 1,941 reads

Posted in The Database Hive for SQL Server DBAs on 2 December 2011

SQL Server 2008 R2 Installation Step by Step Guide - Saving System Admins, DBAs, Developers and Support Technicians A Wee Bit O' Misery

I've uploaded to SkyDrive a complete step by step guide for a SQL Server 2008 R2 installation because I prefer to see this done correctly than butchered, hope it helps save some time for those dealing with this vast task, including how to install a service pack and where to… Read more

5 comments, 34,363 reads

Posted in The Database Hive for SQL Server DBAs on 2 December 2011

Last Week's DB Security Workshop @ Oracle Montreal

DB Security Workshop @ Oracle Montreal

I have dedicated several posts on the importance of being a Data Steward, and the consequences of not doing so, or in my case having been prevented from doing so within the government due to my ethnicity. But I digress  back to stressing…

Read more

0 comments, 1,731 reads

Posted in The Database Hive for SQL Server DBAs on 15 November 2011

Newer posts

Older posts