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

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,138 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, 282 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

4 comments, 1,790 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, 511 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, 580 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,229 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, 858 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

10 comments, 3,232 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, 601 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, 1,018 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

1 comments, 479 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, 485 reads

Posted in Pearl Knows on 24 February 2014

T-SQL Tuesday#51 - Place Your Bets - In-Place Upgrade.

I’m not much of a betting man, but if I had to bet that I would participate in this month’s T-SQL Tuesday #51, without knowing who was the host, I probably would have lost.  Now, I hear pretty frequently from Mr. Brimhall, but I had to find out… Read more

0 comments, 497 reads

Posted in Pearl Knows on 11 February 2014

NJSQL User Group Presents In-Memory OLTP for SQL Server

 

If your local to the NY/NJ area, please see tomorrow night's agenda for SQL Server 2014 In-Memory OLTP feature!  Microsoft PFE Simon Facer will be presenting.  All details and information is below.  Simon was our Microsoft point-man for the last SQLSaturday #235 in New York.  Let's welcome him to… Read more

1 comments, 414 reads

Posted in Pearl Knows on 20 January 2014

REBLOG: Twas the Week After Christmas.....

Holiday Greetings to all you DBA's and SQL Server professionals! This blog goes out to all of you who are on-call this week, or in the office, keeping SQL Servers safe from the grinches.  Hope you enjoy!

I wrote this little holiday parody a few years ago, and while it may… Read more

0 comments, 431 reads

Posted in Pearl Knows on 24 December 2013

T-SQL Tuesday#49 - Wait for it...Waits & Queues

As I was waiting for the next TSQL Tuesday topic to be announced, we all know that when SQL Server performance is slow, and becomes a big issue in your company, sometimes we need to throw an army at the problem to resolve it.  Other times, we can employ… Read more

1 comments, 630 reads

Posted in Pearl Knows on 10 December 2013

HealthySQL at SQLSaturday #233 - Down in DC - wrap-up.

December 7, 2013 – A day that shall live in infamy….. Ok, not that famous December 7 – in 1941, when the attack on Pearl Harbor occurred.  This last Saturday was a day that will be remembered as a great entry into the history books of SQLSaturday events! … Read more

0 comments, 377 reads

Posted in Pearl Knows on 10 December 2013

Happy Halloween! A TALE OF THE SCARY DBA! - Reblog

 

Today, October 31, 2013 is Halloween, and in the spirit of the holiday of ghosts, goblins, vampires, werewolves, witches and warlocks, I just couldn’t resist, to bring you a short Halloween poem to roast one of our favorite SQL DBAs, Grant Fritchey (blog|twitter), aka the… Read more

0 comments, 739 reads

Posted in Pearl Knows on 31 October 2013

PASS Summit 2013 - Highlight Q&A from the Experts - What are you currently working on?

Day 3 at PASS Summit 2013, and the conference wraps up today strong with BOF (Birds of a Feather) lunch, and many more excellent presentations.  Some of the highlights will be carried live on PassTV, if you’re not in the convention center. Coming up, Gail Shaw @SQLintheWild Read more

0 comments, 509 reads

Posted in Pearl Knows on 18 October 2013

PASS Summit 2013 - Highlight Q&A from the Experts - What are your favorite features?

PASS Summit Continues….

If you have been following my blog, in the myriad of PASS Summit 2013 related blogs, you’ve been enjoying my special summit series Highlights Q&A From the Experts, where I asked many of our SQL Server MVPs to participate in our panel discussion. 

I’ve asked…

Read more

0 comments, 392 reads

Posted in Pearl Knows on 17 October 2013

Older posts