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
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
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
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
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
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
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
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
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
Let's welcome them to NYC! Now at the NEW NYC Microsoft HQ (see below)
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
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
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
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
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
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
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
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
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.