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
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
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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
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…
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