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

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

9 comments, 1,731 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, 382 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, 394 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, 330 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, 312 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, 258 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, 285 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, 334 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, 482 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, 261 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, 630 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, 377 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, 284 reads

Posted in Pearl Knows on 17 October 2013

PASS Summit 2013 - Highlight Q&A - Where Will You Be?

PASS SQL Summit time, 2013 is in full blown progress.  Fantastic keynotes and presentations taking place all day long!  For those of you who could not get there in person, passTV is streaming some great highlights LIVE, via this link: Summit Live.

If you’re at the Charlotte… Read more

0 comments, 353 reads

Posted in Pearl Knows on 16 October 2013

PASS Summit 2013 - Day 2 - Highlights Q&A - What Are You Presenting On?

Today, October 16, 2013: PASS DAY2

PASS Summit Day 1……complete……..Great learning, check!  Awesome sessions and nuclear networking!  You can read my first entry on Summit Highlights, Questions & Answers. I also posted some helpful hints, resources, and links for PASS Summit First-Timers.

The fun continues Day… Read more

2 comments, 223 reads

Posted in Pearl Knows on 16 October 2013

PASS SQL Summit 2013 - Highlights Q&A - First Timer's Advice from the Experts

 

So, is this your first time attending PASS Summit?  Confused, shy, overwhelmed, and don’t know what to do first? Or second or third, for that matter?  Well, you are not alone, and as of PASS Summit 2013, it’s not their first time getting you familiar with the… Read more

0 comments, 420 reads

Posted in Pearl Knows on 15 October 2013

PASS SQL SUMMIT 2013 - Day 1 - Highlights, Questions & Answers

Today, October 15, 2013: PASS SUMMIT DAY1

It’s October, and it’s PASS SQL Summit time, 2013!  PASS Summit is the world's largest, most-focused, and most-intensive conference for Microsoft SQL Server and BI professionals. Organized by and for SQL Server and BI users, PASS Summit delivers the most technical sessions,… Read more

0 comments, 377 reads

Posted in Pearl Knows on 15 October 2013

TSQL Tuesday #47 - SWAG - Where Does He Get Those Wonderful Toys?

 

Where does he get all those wonderful toys?  In the line made famous by Jack Nicholson’s Joker in the original Batman movie (c1989), the question may finally be answered!  He must have been hitting the SQLSaturday circuit, and other wonderful SQL conferences.  Will Batman show… Read more

0 comments, 647 reads

Posted in Pearl Knows on 8 October 2013

It's Just Another Manic SUNDAY - OT

Warning, this is just a non-technical anecdotal blog of a silly time-warp incident that happened to me yesterday.  Thought it was kind of funny, so wanted to share. 

Did this ever happen to you?  No, the title isn’t a mistake; it’s a parody on the title of… Read more

1 comments, 300 reads

Posted in Pearl Knows on 23 September 2013

Geometry in the Cloud - where geospatial data meets the cloud.

Mount Olympus: Stratosphere: It was inevitable that two innovative technologies would merge to create a world of potential in the way we live, work, play, and do business.  I read an interesting article this morning on SmallBizTechnology.com, and wanted to share, and maybe inspire many of you to… Read more

0 comments, 529 reads

Posted in Pearl Knows on 17 September 2013

Older posts