Archives: August 2009
Compression is one of the major features introduced in SQL Server 2008, and one that can significantly reduce disk storage. Compression basically eliminates the “white space” in your data, using different internal algorithms depending on the type of compression the engine is using. There are both backup and… Read more
Now that the kids have interest in computers, I sometimes find myself competing with them. I recently purchased a business class Dell laptop, and suddenly find it bursting with downloads and nickJr games. He has a computer in his room, but the laptop being portable in the family room, seems more… Read more
Database Mirroring w/o a Domain, Can be a Pain - but it can be done......
Have you ever had to setup mirroring across domains, DR/Colo Sites, and/or over the Internet? When the Principal and Mirrored servers are in the same network/domain, it always seems to go rather smoothly:
Set the… Read more
As I was going through some of my documentation at past clients, I found my summary of the general SOX compliance considerations in preparing for an internal audit for Database Servers. I thought maybe it could be helpful to some folks who need to whip their servers into shape, and… Read more
Yesterday, I blogged about basic I/O usage with some useful scripts, DMVs, and links to more in-depth details on examining these statistics.
Since my blog was blasted to many LinkedIN SQL Server groups, I received many, many of your positive comments and feedback - and for that, I/O you a… Read more
I/O I/O - It's why my server's slow.....
Often I've been curious about ways to measure the performance of SQL Server, and be able to present it in a readable and useful format. One of those measures is examing I/O Statistics. In addition to calculating the total I/O, by using… Read more
The Fisherman and the "C" ("City")
Ok, I know when most think about NYC, they think latte-sipping wall-street yuppie (I'm actually none of those, but still a city boy. I peel back my pride a
bit to share this with - the whole world?)
So, here's my weekend blog, nothing… Read more
As more and more companies get on board and begin to adapt SQL Server 2008, what is the best way for DBA's to fast track and reconcile their SQL 2005 skills with the new 2008 platform? Besides, as many have done, create a lab environment, if you can get… Read more
So, what should I talk about next? There's so much going on in the world of SQL Server (ie: 2008, BI, the DBA job market, new technologies, Remote DBA services - and the list goes on and on.....I'm thinking of some topics to discuss, based on my recent own experiences,… Read more
Here's some upbeat info to share as the week kicks off to a new start!
Data just recently released by the Department of Labor, suggests that there has been a "startling increase in IT related jobs in the month of July following several months of decline."
According to Foote Research Group, an independent… Read more
So, finally, I got my SQLServerCentral.com Blog, that Mr. Jones was kind enough to set up. Many thanks SJ!
My very first blog was sort of a cut-and-paste, just to put out an initial primer and intro to my company's products and services, as well as begin my foray into the… Read more
Introduction To Pearl Knowledge Solutions, Inc., an ISV and MSP of Remote Database Administration services.....How we're helping small-midsized companies.
Pearl Knowledge Solutions, offers database expertise to companies that need our help in proactively maintaining and monitoring your database infrastructure via our Remote DBA managed service model.
We can save… Read more