Recent Blog Posts

April 15, 2014

The Read Committed Isolation Level

Paul White (@SQL_Kiwi) marches on in his series on ACID and transactions; in this chapter, he explains how READ COMMITTED really works. (read more)

 

April 10, 2014

The Serializable Isolation Level

Paul White (@SQL_Kiwi) continues his series on ACID and transactions in SQL Server. In this installment, he discusses the SERIALIZABLE isolation level. (read more)

 

April 10, 2014

SQL Sentry v8: Baselines from Every Angle

In my last post I covered the exciting new intelligent alerting features in SQL Sentry v8. Next up in the series is another huge and... (read more)

 

April 09, 2014

Top 10 DBA Mistakes on SQL Server (Now with Prizes!)

Microsoft SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy. And it doesn’t mean that database administration on SQL Server is problem free. And since SQL Server is constantly growing from small, home-grown applications, many IT professionals end up encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. In fact, wouldn’t you like to learn about those mistakes before they ever happen? Watch the video to learn more! (read more)

 

April 02, 2014

Tracking Automatic Updates to Statistics

Erin Stellato (@erinstellato) of SQLskills walks through three methods of tracking automatic statistics updates: SQL Trace, Extended Events, and dynamic management objects. (read more)

 

April 01, 2014

SUPER SECRETS of the SQL Server Illuminati — REVEALED!

Why would I share a SUPER SECRET story like this? Why would I reveal secrets that were NEVER meant to see the light of day? What bizarre secrets will you learn about the twisted underbelly of SQL Server? (read more)

 

March 31, 2014

Selecting a Processor for SQL Server 2014 – Part 2

Glenn Berry (@GlennAlanBerry) of SQLskills provides further insight into your best choices in processors for SQL Server 2014. (read more)

 

March 29, 2014

SQL Saturday #262 : Boston

Today I gave my T-SQL : Bad Habits & Best Practices session at SQL Saturday #262 at Microsoft in Cambridge. Fun event with a lot of friendly faces. A few mishaps along the way: had to wake up at 5:00 AM to take the only sensible commuter rail option...(read more)

 

March 27, 2014

Configuring Service Broker for Asynchronous Processing

Jonathan Kehayias (@SQLPoolBoy) continues his Service Broker series; in this post, he demonstrates asynchronous functionality by walking through a simple configuration and example. (read more)

 

March 18, 2014

An Introduction to Asynchronous Processing with Service Broker

Jonathan Kehayias (@SQLPoolBoy) of SQLskills kicks off an interesting series on configuring and using Service Broker to accomplish asynchronous processing in SQL Server. (read more)

 

Featured Blog Posts

March 14, 2014

SQL Sentry v8: Intelligent Alerting Redefined

It's tempting to insert some clever reference to everyone's favorite vegetable juice medley here, but I will refrain, for fear of diminishing what is perhaps the most significant SQL Sentry release to date! In v8 we've addressed the three most... (read more)

 

December 31, 2013

What’s the Hidden Issue in the Recent PASS Bylaw Changes?

The recently proposed bylaw changes to the Professional Association for SQL Server charter are a good change. But there's a hidden issue that you may not have seen. What is the issue? And what are its ramifications? Read more and add your opinion here. (read more)

 

November 05, 2013

Dos and Don’ts of Providing Exceptional Customer Service to Exceptional Customers

What is “exceptional” customer service? It’s difficult to define, but you know when you have received it. It is an experience in which a service representative helped change a stressful situation into a relaxing one. If you get on the phone with a service rep, or start an email chain to a support department about something that is driving you crazy, and a few hours later your entire day is... (read more)

 

July 12, 2013

SQL Sentry v7.5: A Better AlwaysOn

When we released SQL Sentry v7.2 with dedicated Windows monitoring last October, we were already hard at work on the AlwaysOn-oriented features that would become v7.5. We wanted to be the first to market with integrated, visual AlwaysOn monitoring and management, and I'm happy to say... (read more)

 

March 08, 2013

Plan Explorer PRO 2.5: Query plans your way

Have you ever worked with a query plan that was so large and unwieldy that it was next to impossible to make any sense of it? It can be a frustrating endeavor, for sure. Plan Explorer has always done some things that can help with these plans, such as color-scaling costs and vertically compressing subtrees. Even so, when... (read more)

 

News Room

Our news room includes recent product reviews, press releases, eNews, and external blogs about SQL Sentry software. Also check out our blog posts for additional articles.

April 2014

eNews, the new SQL Sentry

Spring has sprung throughout the South here in the USA. The Bradford pear trees, saucer magnolias, and forsythia have all blossomed, bringing a rainbow of colors and sweet fragrances to life. And just as the natural world is bursting forth everywhere you look, so is SQL Sentry. The first thing you might notice upon visiting www.sqlsentry.com (that’s right, DOT COM!) is the entirely new look and feel for the website.

April 2014

SQL Sentry v8: Baselines from Every Angle

In my last post I covered the exciting new intelligent alerting features in SQL Sentry v8. Next up in the series is another huge and often requested feature: Baselining. Designing this feature proved to be somewhat of a challenge due to the diversity of opinions on this topic. Seems that everyone has a different idea about baselining – what it is, and how it should be used effectively to improve performance.

April 2014

SQL Sentry Introduces V8.0 with Intelligent Alerting, Baselining, and Cloud Features

The Power Suite continues its category dominance as the most complete monitoring solution available for SQL Server, with seamless history tracking and the lowest documented server overhead. The new features of v8.0 fall into three main categories: intelligent performance alerting, flexible performance baselining and cloud access to shared performance data.

March 2014

SQL Sentry v8: Intelligent Alerting Redefined

It's tempting to insert some clever reference to everyone's favorite vegetable juice medley here, but I will refrain, for fear of diminishing what is perhaps the most significant SQL Sentry release to date! In v8 we've addressed the three most frequent requests from our users – performance alerting, baselining, and cloud access – and we've done so in typical SQL Sentry fashion.

February 2014

eNews, February 2014 - Top SQLPerformance.com Articles

February is the month for Valentine’s Day. So let’s take a couple of minutes to share the love with all of the technical knowledge we’ve been publishing lately. It’s not quite a dozen roses and a box of chocolates, but if it can save me a lot of time and effort at the office, it’s a gift that’s just as sweet.

More News

Subscribe to eNews

We send out a monthly newsletter with fun information about SQL Sentry, interesting blog posts on SQL Server features, tips to help improve your productivity, and much more.

Enter your name and email to subscribe:

 

Your email and personal information will never be shared with any third parties. View our Privacy Statement

 

Events

SQL Sentry has been "taking it on the road" attending User Group meetings and conferences. In cities across the world, we're showing you how to optimize SQL Server performance. If you are a User Group organizer looking for exciting, pertinent guest presenters and would like to schedule SQL Sentry to attend your group meeting, contact us.

Apr 28, 2014 - May 02, 2014

IE1: Immersion Event on Internals & Performance - Chicago, IL

This 5-day class is focused on the core fundamentals and foundation for SQL Server experts. While many folks are just looking for 'the answer', attendees of this class will learn how to derive the answer for themselves. The more you know about how SQL Server works the easier you will be able to respond to performance, design, and corruption problems - as well as solve them!  

Apr 28, 2014 - May 02, 2014

IEBI: Immersion Event on Business Intelligence - Chicago, IL

Even with little to no knowledge of BI, this course will provide you with immediately-usable, production-level knowledge of BI. The course has been designed to take you from installation to configuration to application and integration – for all facets of the BI stack (SSIS, SSAS, SSRS, PowerPivot, and SharePoint) - it is meant for anyone who wants to get involved in BI.  

May 05, 2014 - May 09, 2014

IE2: Immersion Event on Performance Tuning - Chicago, IL

This 5-day class is focused on the many areas surrounding performance. While a class such the Immersion Event on Internals and Design should be taken prior to taking this class, this class also stands alone for anyone wanting to focus on some of the most important aspects of performance tuning for SQL Server.  

May 07, 2014 - May 09, 2014

PASS Business Analytics Conference - San Jose, CA

The PASS Business Analytics Conference brings together analysts and IT pros from the world of BI and analytics to connect, share experiences, and learn more about the power of data to transform business. With more than 70 sessions planned by the world’s top BI and BA experts, this conference delivers real-world insights and best practices, prescriptive guidance, and strategic vision.  

May 10, 2014

SQLSaturday #308 - Houston, TX

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held May 10, 2014 at San Jacinto College - South Campus 13735 Beamer Rd. Building 12, Houston, TX 77089.  

May 12, 2014 - May 14, 2014

TechEd North America - Houston, TX

TechEd North America is Microsoft’s premier technology conference for IT Professionals and Enterprise Developers, providing the technical education, product evaluation, and community resources to plan, architect, deploy, manage and secure a connected enterprise.  

May 12, 2014 - May 16, 2014

IE3: Immersion Event on High Availability & Disaster Recovery - Chicago, IL

This 5-day class is designed to give a solid grounding for database administrators in topics related to high availability and disaster recovery.  

Jun 09, 2014 - Jun 13, 2014

IE1: Immersion Event on Internals & Performance - Bellevue, WA

This 5-day class is focused on the core fundamentals and foundation for SQL Server experts. While many folks are just looking for 'the answer', attendees of this class will learn how to derive the answer for themselves. The more you know about how SQL Server works the easier you will be able to respond to performance, design, and corruption problems - as well as solve them!  

Jun 16, 2014 - Jun 20, 2014

IE2: Immersion Event on Performance Tuning - Bellevue, WA

This 5-day class is focused on the many areas surrounding performance. While a class such the Immersion Event on Internals and Design should be taken prior to taking this class, this class also stands alone for anyone wanting to focus on some of the most important aspects of performance tuning for SQL Server.  

Jul 17, 2014 - Jul 19, 2014

SQLBits XII - Telford, UK

The conference will be taking place on between the 17th and 19th of July 2014 at The International Centre, Telford, UK. Whilst is early days, we will have the same three day format as past events: Thursday - Full day sessions, in depth training, Friday - Conference day with multiple sessions, and 6 tracks, Saturday - The free conference day, again with multiple sessions, and 6 tracks.  

Nov 04, 2014 - Nov 07, 2014

PASS Summit - Seattle, WA

PASS Summit is the world's largest and most intensive technical training conference for Microsoft SQL Server and BI professionals. But more than that, it’s your conference – planned and presented by the SQL Server community for the SQL Server community.  

Events Archive

Upcoming Webinars


Fri, Apr 18, 2014 10:00 AM - 11:00 AM EST

SQL Sentry Intro To Version 8.0

Register

Thu, Apr 24, 2014 02:00 PM - 03:00 PM EST

SQL Sentry Tools Demo - Focus on SQL Server

Register

Tue, Apr 29, 2014 06:00 PM - 07:00 PM EST

SQL Sentry Tools Demo - Focus on SQL Server

Register

Mon, May 05, 2014 12:00 PM - 01:00 PM EST

SQL Sentry Tools Demo - Focus on SQL Server

Register

Wed, May 21, 2014 12:00 PM - 01:00 PM EST

SQL Sentry Tools Demo - Focus on SQL Server

Register

Tue, May 27, 2014 12:00 PM - 01:00 PM EST

SQL Sentry Tools Demo - Product Suite Overview

Register

Wed, Jun 11, 2014 12:00 PM - 01:00 PM EST

SQL Sentry Tools Demo - Focus on SQL Server

Register

Thu, Jun 26, 2014 12:00 PM - 01:00 PM EST

SQL Sentry Tools Demo - Focus on SQL Server

Register
;