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

A Reason To Smile! - Deep Dives II

  Over this past weekend, SQL MVP Kalen Delaney sent an inspiring note to the MVP email thread, and I wanted to share this with the greater SQL Server Community.  She sent an update on a project I was honored to take part in, back in 2011, and is one… Read more

1 comments, 1,339 reads

Posted in Pearl Knows on 20 January 2015

T-SQL Tuesday #62 - Achieving Healthy SQL with MDW

Today: Tuesday, January 13, 2015 is the 62nd entry and first T-SQL Tuesday of the year 2015, and I am honored to be this month’s host to kick of the New Year!  Last week, I made the announcement, and invited everyone to the blog party started many quantum… Read more

6 comments, 7,176 reads

Posted in Pearl Knows on 13 January 2015

T-SQL Tuesday #62 - Invitation to HealthySQL

Greetings ALL and Happy New Year 2015!  I wish everyone an excellent year ahead, and that 2015 will bring peace and new beginnings!  I have the distinguished pleasure of kicking off the New Year, with this month’s T-SQL Tuesday #62!   My fuzzy logic vaguely remembered I had… Read more

17 comments, 3,056 reads

Posted in Pearl Knows on 6 January 2015

SQLSaturday#380 NYC Event Update - Precons, Speakers....

Just wanted to blog a quick update on SQLSaturday#380 in NYC, happening on May 30, 2015.  As you are hanging the stockings by the chimney with care, we hope you register for NY SQLSaturday, and to see you there :-)   The official announcement was made in my recent blog, SQLSaturday… Read more

0 comments, 758 reads

Posted in Pearl Knows on 24 December 2014

T-SQL Tuesday no.61 - Giving Back!

 Tis the Season to Be Jolly, as well as giving, and T-SQL Tuesday’s timely topic on giving back to the SQL Community is brought to us by Mr. Wayne Sheffield (blog|twitter), who asks us, “In “The Spirit of Giving”, I want to know how you…

Read more

0 comments, 766 reads

Posted in Pearl Knows on 9 December 2014

SQLSaturday Returns to NYC 2015!

November 25, 2014 - Good news in Gotham!  Well you asked for it! You wanted it! You waited for it! And now it's finally here! It gives me great pleasure to announce the return of SQL Saturday to New York City! Save the date, May 30, 2015! Just…

Read more

0 comments, 866 reads

Posted in Pearl Knows on 25 November 2014

SQLSaturday Speaking & Sharing

Recently, I caught a blog link on LinkedIn, of one SQL Server professional talking about his experience speaking at a SQLSaturday, and I thought I would not only share my own experience, but invite all of you who ever spoke at a SQLSaturday to share yours as well.  In…

Read more

0 comments, 427 reads

Posted in Pearl Knows on 24 November 2014

Hell No, DMO - DMV is what it shall be!

So, I've finally decided to draw a line in the sand.  I've been doing some writing lately.  The radio silence will soon be broken in a big and "healthy" way.  In the meanwhile, I've got caught up in naming antics, and what we should really be calling them. There may… Read more

0 comments, 533 reads

Posted in Pearl Knows on 15 October 2014

Get SQL Server Info - Quick Tip & Script

There are a number of ways to collect basic information about SQL Server, its version, edition and other top-level properties.  What is the build, and current service pack level? What is the instance name vs. the actual server name?  Is it clustered or stand-alone and is it virtual… Read more

3 comments, 9,867 reads

Posted in Pearl Knows on 17 July 2014

Congratulations MVPs - Team USA (the other world cup)

While the World Cup was still going on, and the folks in the USA had a real reason to root for the home team, we fell afoul the expert chocolatiers of professional football (or as us Yankees - say, soccer)  :-), and succumbed to the Belgians, 2-1, in overtime. Read more

0 comments, 604 reads

Posted in Pearl Knows on 2 July 2014

Cluster Headache - Applying Service Pack and SQL Fails to Come On-line

Having applied dozens and dozens of Service Packs to various SQL Server clusters, I still never cease to learn that not everything always goes as planned. J  So, a funny thing happened on the way to apply my service pack to a SQL Server 2008 R2 cluster. Well, it… Read more

5 comments, 4,225 reads

Posted in Pearl Knows on 18 June 2014

SQLSaturday #294 DBA 4 Dummies - post event commentary...

Had an awesome time at #SQLSat294 in Philly (MS HQ in Malvern, PA to be exact).  Was great seeing the #sqlfamily.  I wanted to share my experience on this event, and a very positive one it was.  I think I made a discovery, or at least found… Read more

2 comments, 902 reads

Posted in Pearl Knows on 10 June 2014

Happy Memorial Day - Freedom is Never Free!

Well, as all folks in the United States know, this weekend we celebrate Memorial Day, Monday May 26, 2014.  While many of us who will enjoy this extended long weekend with our family and friends, barbecues, picnics, amusement parks, shopping and the beach, we should take a moment to… Read more

3 comments, 894 reads

Posted in Pearl Knows on 23 May 2014

T-SQL Tuesday #54 - Interviews and Hiring

Well, it's that time again!  It's TSQL Tuesday #54, and its about Interviews and hiring.  I'm writing this free style and extemporaneously (off the top of my head).  Why the rush?  Well, I'm late!  I'm late to the awesome blog party, but tip #1 for any interview you may… Read more

0 comments, 2,691 reads

Posted in Pearl Knows on 13 May 2014

Summer SQL Server & Database Events In and Around NY

Summer SQL Server & Database Events In and Around NY-

Happy May everyone!  Hope those April showers will bring us May flowers!  While we can’t be certain of that, what May and the summer months will definitely bring are fantastic local SQL Server and Database Events in and… Read more

0 comments, 1,376 reads

Posted in Pearl Knows on 1 May 2014

Help! I'm stuck in Single User Mode and can't get out!

So, here’s a silly little take on a serious end-user issue where no-one could access the production database.

Got a call from a client recently.  Like something out of a LifeAlert® commercial: “Help! I'm stuck in single user mode and can't get out! “ 

I figured this… Read more

13 comments, 17,442 reads

Posted in Pearl Knows on 7 April 2014

DBAs should be on CLOUD 9 - IT Trends

For all the talk and initial fear that the DBA is going the way of the Dodo (pronounced doh-doh) (an extinct flightless bird), due the advent of Cloud Technology, the opposite may be true.  Ironically, it may have been the move to the cloud that did in more IT… Read more

1 comments, 1,029 reads

Posted in Pearl Knows on 18 March 2014

Configuring Native Mode SSRS on local host

OK, so you successfully installed SQL Server and you selected to deploy SQL Server Reporting Services using the default installation options!  You’re using SSRS Native Mode, not SharePoint Mode

You simply want to configure a local reporting server, and deploy reports to your local website via the http://localhost Read more

0 comments, 3,723 reads

Posted in Pearl Knows on 6 March 2014

Tonight: NYC Metro User Group Presents Kimberly L. Tripp & Jonathan Kehayias

 Tonight: The NYC Metro User Group Presents Kimberly L. Tripp (blog) and Jonathan Kehayias (blog)!

Let's welcome them to NYC!  Now at the NEW NYC Microsoft HQ (see below)

It's time to get some SQLSkills, Big Apple Style!  Just bringing you an update on this special… Read more

2 comments, 668 reads

Posted in Pearl Knows on 25 February 2014

HealthySQL 2.0 for SQLSaturday#268


Over the last year, I was presenting and touring the SQL Saturday circuit with my HealthySQL 2.0 presentation.  HealthySQL is my campaign to raise awareness in the greater SQL Server Community for the need for regular performance and security health checks, and to maintain a healthy SQL… Read more

0 comments, 704 reads

Posted in Pearl Knows on 24 February 2014

Newer posts

Older posts