Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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, 603 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, 611 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, 840 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, 782 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,492 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,152 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, 626 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, 894 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

4 comments, 13,307 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, 689 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, 1,217 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…

Read more

0 comments, 847 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, 647 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, 1,291 reads

Posted in The Database Hive for SQL Server DBAs on 24 June 2011

Notes from Solid State for SQL Server with Wes Brown from Today’s Idera Broadcast – SSD Best Practices for Database Servers

The following is a combination of notes from Wes Brown’s presentation today, with edited details from his http://sqlserverio.com/ post on this subject, and my own notes and comments from the webinar this afternoon at 3-4pm. Wes, approving of this write up, also provided PDFs+PPT links for this presentation (I have… Read more

3 comments, 1,938 reads

Posted in The Database Hive for SQL Server DBAs on 8 June 2011

The Pro-Active DBA List Updated

 

A couple of years back, in the heart of the economic tsunami, I proposed a list of pro-active steps to reduce long-term costs associated with the management of your SQL Server database systems.  An Updated list is below.  

Normally, I would be putting out a new content, but…
Read more

2 comments, 684 reads

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

Rant About Judges that Misunderstand the Role of a DBA

Part - 07 Exerpts from "The Tyranny of Bill-101" - Part 07

Commenting on how frustrating it is for DBAs to deal with a corrupt Judicial System that attacks victims of White Collar Crime, and specifically this decision, that doesn't recognise what our role is with relation to database…
Read more

0 comments, 337 reads

Posted in The Database Hive for SQL Server DBAs on 5 April 2011

How to Deal with Quebec’s Extremists – Report their Threats to the Police (Investigation Under Way)

 

I’m part of a Committee that is dedicated to eliminating discriminatory legislation in Quebec, here’s a statement we released last week after a Death Threat from the one-man show Quebec Militia ‘Major’ Provost:

The goal of our Greater Montreal Multi-Ethnic Territory Committee to Abolish Bill 101, is begin the… Read more

2 comments, 1,244 reads

Posted in The Database Hive for SQL Server DBAs on 5 April 2011

Canada Begins Return to Democracy as the ‘Harper Government’ Found in Contempt of Parliament, a First Throughout the Commonwealth – And No Confidence Vote Triggers the Election Race

 

For over a week now, Canada has begun its return to appearing to be a democracy thanks to a Liberal No Confidence Motion on Friday, March 25th.  On March 9th, I warned several key Liberal MPs to be very prepared for such a motion because of the backfire… Read more

0 comments, 556 reads

Posted in The Database Hive for SQL Server DBAs on 5 April 2011

Newer posts

Older posts