Subscribe to this blog
Managing Critical Server Lists with Remote Desktop Connection Manager
Most Server Administrators, whether Database Administrators or not, are quite familiar with the Remote Desktop Connection (a.k.a. RDP) tool, which is formerly known as the Microsoft Terminal Services Connector accessible from the command mstsc in Run, or from a Command Prompt. What most do not realise, however, is that there… Read more
0 comments, 265 reads
Posted in The Database Hive for SQL Server DBAs on 25 February 2013
Executive Visibility for DBAs: Use SQL 2008 Row+Page Compression, or SQL 2005 (SP2+) vardecimal Conversion, to Reduce Space ($/GB SAN) & Logical Reads
One of the great features available since SQL 2008 is Row and/or Page Compression. However, even for those of you on SQL 2005 in production who might be there for a little while: there’s a decent feature you can take advantage of too that is very expensive to do in SQL 2008.… Read more
0 comments, 922 reads
Posted in The Database Hive for SQL Server DBAs on 8 February 2013
SQL Server 2012 with SP1 Installation Step by Step Guide - Saving System Admins, DBAs, Developers and Support Technicians A Wee Bit O' Misery
Since the last guide was quite popular (over 4k distinct views for SQL Server 2008 R2), I've uploaded to SkyDrive another complete step by step guide for a Microsoft SQL Server installation. This time the Guide is for a SQL Server 2012 with Service Pack 1 installation, because I… Read more
0 comments, 583 reads
Posted in The Database Hive for SQL Server DBAs on 11 January 2013
Querying the Procedural Cache: Just in Time for the New Years’
I sincerely wish that everyone enjoyed their recent holidays and recent downtime with family, and pass on my hope for peace, happiness and health for 2013.
The goal of this post is to aid in the understanding of the procedure cache and execution plans to ensure we use fewer resources,… Read more
0 comments, 569 reads
Posted in The Database Hive for SQL Server DBAs on 26 December 2012
Another Dive into Transaction Log File Forensics
1 comments, 2,206 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
This is just a quick post to make public…
0 comments, 423 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
Please find the Presentation Slide Deck here on SkyDrive.
Contenu - Contents
0 comments, 543 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…
0 comments, 583 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.
6 comments, 3,262 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…
0 comments, 551 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 :)
You can the full details of the introduction here.
0 comments, 967 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, 3,357 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 more0 comments, 1,534 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, 462 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, 439 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
2 comments, 637 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, 595 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, 1,074 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…
0 comments, 885 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
0 comments, 485 reads
Posted in The Database Hive for SQL Server DBAs on 11 December 2011