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

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, 606 reads

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

21st March - Today is International Day for the Elimination of Racial Discrimination

 
How to Counter Intolerance, Adapted from UNESCO’s Recommendations

1. The Battle Against Intolerance Requires Law
Every Political Entity needs to reinforce Human Rights, and punish crimes motivated by hate against minorities
, whether they be committed by individuals working for the state, private organisations or by individuals in their own… Read more

0 comments, 516 reads

Posted in The Database Hive for SQL Server DBAs on 21 March 2011

What is the Most Deployed Database Engine in the World? You’d Be Surprised! It’s Serverless, Self-Contained & Transactional


Just the other week; I was asked to help validate an application database hosted on a Mac, when I was introduced to the public domain database engine SQLite. To my surprise, it is actually the most deployed database engine in the world, since it is so small and… Read more

0 comments, 851 reads

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

3rd Simple-Talk.com Article: 'The Polyglot of Databases: How Knowledge of MySQL and Oracle Can Give SQL Server DBAs an Advantage'

 
After revising the popular Blog post, Developing Your DBA Skills Futher Thanks to Experience with Multiple RDBMS, of just over a year ago, and great editing work from Andrew Clarke and Chris Massey, the third article for Simple talk has come to life.

Enjoy :)

The Polyglot of Databases: How… Read more

0 comments, 477 reads

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

My Heart Goes Out to Japan's Earthquake/Tsunami Victims, And I Pray for Rain in Kesennuma Tonight as the City Burns....

Already hit by yesterday's Tsunami, the fires have taken over the main center of town in Kesennuma, Miyagi, where I stayed in 1992 with the Suzuki family. They are continuing to burn tonight and moving inland (excuse the ads at the beginning from some Chumps trying to gain publicity… Read more

0 comments, 670 reads

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

Monitoring Database Infrastructure and Performance with Systems Center Operations Manager (SCOM), and Oracle Instance Monitoring, Plus Visio Plug-In

SCOM Does the core job of monitoring SQL Server instances very well (Health Monitoring) – but it is not going to make maintenance plans for you. 
You need to set up the database infrastructure first, so go to this article to start your SCOM journey: Here is a guide…
Read more

1 comments, 5,015 reads

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

Attending 2011 MVP Summit in Bellevue/Redmond, WA – Great Face-time with Fellow Speakers/Writers/Bloggers

 The raincoast weather could be a little better, but so far, I am very happy with the brain-filling load of sessions we are having here at Microsoft’s Campus, and mostly in a building they call the ‘Mixer’. The first day, yesterday, I managed to get out for a couple… Read more

1 comments, 483 reads

Posted in The Database Hive for SQL Server DBAs on 1 March 2011

How to Avoid SQL Server 2008 Lingering Evaluation Installs - Validation Before Applying SP2 (10.0.2531 to 10.0.4000)

 

We wound up in a nasty situation recently where SP2 could not be applied to an instance of SQL Server.  After messing around for hours with attempts to rebuild a corrupt master database, with the following startup in Admin-only mode:

sqlservr -c; -m"sqlcmd"; -f; -ServerName\InstanceNameIfNotDefault; -e"C:\path… Read more

0 comments, 772 reads

Posted in The Database Hive for SQL Server DBAs on 21 February 2011

A Wireless Production Server? Sure, Just Enable the Wireless Networking Feature on Windows 2008

 Since I have Enabled Wireless on Windows Server 2008, and picked up a better-than-average Asus N wireless card, handling the storage needs of the home office network has been taken care of.  Of course, the speeds are not comparable to gigabit transfer, but since data is written to… Read more

0 comments, 437 reads

Posted in The Database Hive for SQL Server DBAs on 21 February 2011

Hello, My Name is Hugo and I haven't Blogged in Two Months

Oh gracious sin :) 
No apologies, just that life gets in the way from volunteer work.
My regular political passions have gotten in the way too, with some Pan-Canadian activism that needed some time to ensure a successful movement started.
Anyway, MVP Summit time (my first to attend) is coming up and…
Read more

0 comments, 393 reads

Posted in The Database Hive for SQL Server DBAs on 21 February 2011

Spreading the DBA Gospel (from Old English, god spell "good news")

 

There are times when I wonder why I get so few comments on this blog, however there are assumptions I have made which were confirmed to me recently again by those who wrote to me directly, or spoke with. Some told me that fewer comments are a good thing… Read more

0 comments, 363 reads

Posted in The Database Hive for SQL Server DBAs on 23 December 2010

1.5 Years in, U.K. Information Commissioner Christopher Graham, Delivers on the Data Protection Act

A year after the Telegraph reported that Information Commissioner Graham would pledge a fierce approach to the stonewalling approach of public officials, and enforce the Data Protection Act, he has surely held his word.  Two fines have been delivered, the first to the Hertfordshire County Council, for approximately… Read more

0 comments, 702 reads

Posted in The Database Hive for SQL Server DBAs on 16 December 2010

Notes from Mirroring Deep Dive Session with Mohammed Sharaf: Microsoft Premier Engineer (I can never learn enough about Mirroring :)

 

One thing I have gotten wrong before, or not elaborated on during a past presentation on mirroring, although Roman Rehak mentioned it in the Burlington, Vermont PASS chapter meeting back in May, is that we can use Reporting Services on the Mirrored copy, as long as you… Read more

2 comments, 1,118 reads

Posted in The Database Hive for SQL Server DBAs on 14 December 2010

Guest Vs. Host Clustering Virtual Machines: Speaking Tuesday 23rd November at Montreal Tech Days

 

I will be replacing speaker Steven Robidas on Tuesday, 23 November at Microsoft TechDays.ca Montreal. The discussion will be on Managing and Securing IT Infrastructure - session INF315: Guest vs. Host Clustering Virtual Machines: What, When, and Why? Day 1 - 3:40pm - 4:45pm.  The link provides all the… Read more

0 comments, 269 reads

Posted in The Database Hive for SQL Server DBAs on 21 November 2010

Intel’s X25 Generation Solid State Disk Performing Well

 

Ever since I took myself voluntarily off company workstation support by installing Windows 7 on the corporate Dell E6400 laptop, I have noticed some instability due to Remote Desktop Connection Manager: each blue screen occurred while trying to connect to a Server within RDCMon or Powerpoint, but in the end,… Read more

0 comments, 300 reads

Posted in The Database Hive for SQL Server DBAs on 10 November 2010

Database Security Best Practices for the Vigilant Database Administrator and Developer (Unabridged Edit)

Below is a longer version of the equivalent Technet Article  under Security TechCenter > Learn > Security Columns > MVP Articles >  Database Security Best Practices

The security of corporate databases and related aspects have become increasingly important as enterprises consider the data they store, purchase, or acquire as…

Read more

2 comments, 3,137 reads

Posted in The Database Hive for SQL Server DBAs on 31 October 2010

Notes from MySQL Enterprise Lunch and Learn With Representatives from Sun & Oracle (MySQL 5.5 Now Downloadable)

 

Today we sat through a pizza ‘n pop lunch while listening to a MySQL Offering and Licensing for the company I have been working for as a permanent for about a year now. Since the take-over by Oracle, the joke was that speculators were thinking that the new version… Read more

0 comments, 1,023 reads

Posted in The Database Hive for SQL Server DBAs on 27 October 2010

Connection Strings: Database Mirroring Failover Partner Setup & Sample Backup/Restore Preparation Script

 

After having setup my first SQL 2008 R2 Enterprise (build level 10.50.1702) database mirror as High Safety with automatic failover, meaning synchronous commit on both servers (see operating modes), there was an obvious question that followed from those who need to employ this redundant database – which/what… Read more

2 comments, 3,131 reads

Posted in The Database Hive for SQL Server DBAs on 6 October 2010

When the Bloc Québécois is a Nuisance for Quebeckers’ Interests: The Top 20 Countdown

 The below is a republished version that has been released officially on the Canadian Federal Liberal Party's web site.  Finally get some use out of that old History and Politics degree :)  L'originale en français est disponible ici.

 

When the Bloc Québécois is a Nuisance for Quebeckers’ Interests: The… Read more

12 comments, 4,407 reads

Posted in The Database Hive for SQL Server DBAs on 30 September 2010

Open-Source Databases are Not Free, MySQL has a High Cost, According to MySQL.com Itself

 

After having a few heated discussions on Facebook in reference to Open-Source Relational Databases, I would like to refer those who think that MySQL will cost your company nothing to the MySQL Enterprise DBA Savings Calculator page.

All Database servers have to be managed, and there are the costs… Read more

1 comments, 585 reads

Posted in The Database Hive for SQL Server DBAs on 28 September 2010

Newer posts

Older posts