Subscribe to this blog
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 |
3 comments, 257 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, 140 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, 189 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, 428 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, 398 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, 130 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, 112 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, 184 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, 155 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, 406 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, 187 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, 149 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)
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, 175 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
0 comments, 394 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…
0 comments, 89 reads
Posted in The Database Hive for SQL Server DBAs on 15 November 2011
Managing SQL Server in a Virtual World (rough) Notes, Thanks to Quest Presenter Jason Hall
Managing SQL Server in a Virtual World Notes (View Complete Slide Show)
Hosted by MVP Kevin Kline, Quest Software
Guest presenter Jason Hall, SQL Server consultant to Quest software
How to optimize your SQL Server licensing with VMware, since most SQL VMs are on VMware ESX platform: http://communities.vmware.com/message/1075017 Read more
0 comments, 249 reads
Posted in The Database Hive for SQL Server DBAs on 31 October 2011
Updated Data Migration Assistants (5th Version Already) & Project Template to Help with Your Upgrades
After having spent much time attempting to settle a point regarding my favourite pastime of provincial politics, it has come to my attention that there is a neglected readership here, which I do regret sincerely. Thus, ever interested to right what is wrong, I wish to dive right back…
0 comments, 272 reads
Posted in The Database Hive for SQL Server DBAs on 20 September 2011
Simple Database User-Access Security Validation & Granting Elevated Access Temporarily Using the Execute As Statement
If you ever want to validate what level of access a user has within a database OR wish to temporarily give elevated access to a database user’s object code (e.g. within a stored procedure) and not provide them directly with the privileges, you can profit from the Execute As Read more
0 comments, 258 reads
Posted in The Database Hive for SQL Server DBAs on 13 July 2011
Full Time Employees Per Number of Database Users? FTE/DB users? How Many Servers are too much to Handle?
After several days research, I have been trying to get a rough estimate on how many Full Time Employees are allocated per number of database users and/or servers.
Yes, I understand there are so many variables, considering that one database can be left alone for years perhaps thanks to proper… Read more
6 comments, 349 reads
Posted in The Database Hive for SQL Server DBAs on 24 June 2011