SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: August 2009

Decompressing on Compression in SQL Server 2008....

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

11 comments, 9,100 reads

Posted in Pearl Knows on 31 August 2009

Looking for a Laptop......

 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

0 comments, 1,335 reads

Posted in Pearl Knows on 29 August 2009

Database Mirroring Across Domains, Using Certificates.....

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

7 comments, 5,793 reads

Posted in Pearl Knows on 25 August 2009

SOX in the City - Preparations for Audit

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

4 comments, 2,404 reads

Posted in Pearl Knows on 23 August 2009

I/O You a followup - More about I/O, Performance Tuning & Troubleshooting....

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

2 comments, 1,618 reads

Posted in Pearl Knows on 19 August 2009

I/O I/O - It's why my server's slow.....Examing I\O Statistics

 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

13 comments, 4,591 reads

Posted in Pearl Knows on 18 August 2009

The Fisherman and the 'C' (City)

 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

0 comments, 540 reads

Posted in Pearl Knows on 16 August 2009

Upgrading your skills from SQL 2005 to SQL 2008......

Greetings, ALL:

   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

1 comments, 650 reads

Posted in Pearl Knows on 13 August 2009

So many topics, so many blogs.......What says you?

 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

3 comments, 710 reads

Posted in Pearl Knows on 12 August 2009

Good News for IT professionals? - Ray of Economic Light Shines in July........

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

1 comments, 667 reads

Posted in Pearl Knows on 10 August 2009

Tales, Travels and Travails of the NYC DBA....

 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

0 comments, 523 reads

Posted in Pearl Knows on 7 August 2009

Introduction To Pearl Knowledge Solutions, Inc


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

0 comments, 772 reads

Posted in Pearl Knows on 7 August 2009