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

SQLSaturday#380 NYC Event Update - Pre-cons Announced!

Welcome to SQLSaturday #380 - Precons Announced!

In addition to the extraordinary extravaganza SQLSaturday NYC event we have planned for Saturday, May 30, 2015, we are pleased to announce our awesome FULL DAY Precons, by some of our favorite MVPs and industry SQL experts!  This is a special training treat… Read more

1 comments, 5,460 reads

Posted in Pearl Knows on 11 February 2015

T-SQL Tuesday #63 - Managing Security - Enforce SQL Login Policies

Today, February 10, 2015 is TSQL Tuesday, no.63! (Click on the highlighted link for the Invitation.)  Hosted this month, by Student of SQL, aka on twitter @sqlstudent144, and maintains his blog, Kenneth Fisher. Ken asks us a very pertinent question that makes up our latest… Read more

0 comments, 7,850 reads

Posted in Pearl Knows on 10 February 2015

T-SQL Tuesday #62 - Wrap Up!

This month’s T-SQL Tuesday #62, the first of 2015, hosted by yours truly, (invitation to Healthy SQL here), asked that you all blog about your T-SQL Resolution, and describe what it is that you will do this year to make sure your SQL Servers are healthy provide… Read more

0 comments, 5,911 reads

Posted in Pearl Knows on 29 January 2015

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,359 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,244 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,176 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, 786 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, 804 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, 897 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, 445 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, 573 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,950 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, 626 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,411 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, 922 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, 910 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,725 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,408 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, 19,177 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,084 reads

Posted in Pearl Knows on 18 March 2014

Newer posts

Older posts