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

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, 371 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,391 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, 625 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, 528 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, 875 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, 491 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, 683 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,272 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, 505 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, 812 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, 456 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, 410 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, 379 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, 731 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,190 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, 280 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, 321 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,220 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,055 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,255 reads

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

Newer posts

Older posts