T-SQL Tuesday #59: My Hero!

This month's edition of T-SQL Tuesday is being hosted by Tracy McKibben (T|B). I was challenged by Aaron Bertrand (T|B) to participate in this T-SQL Tuesday. I instantly knew what and who I wanted to write about, but my schedule being what it is prevented me from writing the blog entry until straight up at midnight. Since this installment of T-SQL Tuesday happens to fall on Ada Lovelace Day, Tracy tells us that our mission – should we choose to accept it – is as follows: Ada Lovelace has been an inspiration to many. In keeping with my blog theme, let’s call her a hero. We all have our … [Read more...]

What Are the Most Common Failures in Windows, SharePoint and SQL Server Alerting Systems?

Since the introduction of IT alerting systems a couple decades ago, everyone followed a very simple template. You'd first define the metric or condition that the alerting system observes, followed by the response or action that the system should perform when the specified value of the metric is exceeded (sometimes called a threshold or trigger). When triggered, alert responses might include the execution of a program or the notification to a user via e-mail, Short Message Service (SMS), or some other method. The promise of alerting is that it makes it possible for people to keep up with the … [Read more...]

SQL Saturday Dublin and Pre-Conference Seminars

One of my favorite events is just around the corner! It's just a few days until SQL Saturday Dublin, Ireland’s largest SQL Server conference on the 19th/20th September, run as a community event by the SQL Ireland User Group. Have You Seen the Schedule? The schedule is complete with an amazing line up of speakers from around the world and you can download a copy HERE. Closer to the event we will be launching a mobile guidebook so you can plan your schedule on a mobile device. I'll be doing my very popular session Convince Me - Persuasion Techniques for IT Pros that Get Things Done. Step Up … [Read more...]

Kevin and the Ice Bucket Challenge

Well, the entire Horde of my children had to play a part in this ice bucket challenge. And Kayden the #SQLBaby makes an appearance too. … [Read more...]

Four New Slide Decks for SQL Server and IT Pros from the DevLink 2014 Conference

I always enjoy presenting at the DevLink conference, presented each summer in middle Tennessee.  This year, I'm trying to be a better social media person and actually post my slides (in their most recent forms) on my SlideShare account for everyone to see and share. If you attended my session(s) and enjoyed them, feel free to download the content here. But it'd be even better if you also left a few words in the Comment section. Skip below to grab the slide decks. Thanks very much! Enjoy, -Kevin -Follow me on Twitter! -Google Author Microsoft SQL Server Internals & … [Read more...]

Third Party Applications and Other Acts of Violence Against Your SQL Server

I just got finished reading a great blog post from my buddy, Thomas LaRock (t | b), in which he describes a useful personal policy he used to track changes made to his SQL Servers when installing third-party products. Note that I'm talking about line-of-business applications here - your inventory management systems and help desk ticketing apps. I'm not talking about monitoring and tuning applications since they, by their very nature, need a different sort of access to your back-end server resources. (Full disclosure: both Tom and I currently work for different tools vendors. But we're both … [Read more...]

MacGyver Moments

In case you haven't heard, your MacGyver Moments are those times when you improvised an excellent solution to a problem using non-traditional materials, techniques, or tools - like the time I repaired my flux capacitor using bailing wire, chewing gum, the tears of Glenn Beck, and the sweat of a master ninja. Necessity is the Mutha of Invention Believe it or not, I've got a long history of doing things MacGyver style.  To begin with, I grew up without two nickels to rub together.  That means you have to improvise - a lot. Once I hit teenage years, I was constantly tinkering with all … [Read more...]

Join Me at the Ft. Lauderdale SQL Saturday on June 14, 2014!

  Join Me at SQLSaturday #288 in Beautiful Ft. Lauderdale, FL SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jun 14 2014 at 3301 College Avenue, Davie, FL 33314. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event. Where Is It? This event will be held on Jun 14, 2014 at Nova Southeastern University 3301 College Ave, Davie, FL 33314. You need to go to the Carl … [Read more...]

Writing and Delivering a Successful Full-Day Technology Seminar

I was recently chatting with the current President of PASS, Thomas LaRock (Twitter | Blog), and Pieter Vanhove (Twitter | Blog), a prominent SQL Server consultant and expert in Belgium, about how I go about building and presenting a full-day technical seminar. In the SQL Server world, we tend to call these "pre-cons", as in pre-conference seminar, because they're typically offered as paid add-ons occurring prior to a full technical conference. We call them that even when they come at the end of the conference and, heck, when there's no conference at all. Kevin and Kendal Van Dyke … [Read more...]

Interested in Self-Service Analytics at the PASS Business Analytics Conference?

I don’t know if you’re planning to attend the PASS Business Analytics Conference. But you'll be missing a ton of great content especially for data, analytics, and business intelligence professionals. There's still plenty of time to register and, if you use my discount code – BABS2B – you'll get $150 off the conference registration fee.  There will be more than 60 sessions at the event by BA/BI experts from Intuit, Microsoft, SurveyMonkey, Wells Fargo, and more. Last year’s inaugural event was quite the shindig, bringing in around 900 business analysts, data scientists, architects, and BI and … [Read more...]