SQL Sentry Grows in the UK and Beyond

The following is an excerpt from Kevin's full blog post at the SQL Sentry team blog. Read the full post HERE. ... It's with great pleasure that I announce we are hiring TWO new sales engineers to start on Monday, August 10th: John Martin (@sqlservermonkey) and Richard Douglas (@sqlrich). (See Richard's post HERE). John and Richard come to us with impeccable credentials, outstanding technology skills, a long history of community activism and unimpeachable ethics. These gentlemen are among the best of the best. Their list of achievements and accolades are long (click on their … [Read more...]

Professional Development – A Recipe for Success

Originally appearing at ForITPros.com. Joe Webb's father-in-law spent most of his adult life as a cardiologist. That's a highly specialized and highly technical area in the field of medicine that deals with the heart. Not every physician can claim to be a cardiologist. It requires rigorous training under the close supervision of an existing cardiologist. That period of training and supervision is called a fellowship. Likewise, many building trades such as electricians, plumbers, and machinists undergo a period of training from someone with more experience. The Apprentice becomes a … [Read more...]

DBTA – StretchDB, a Cool New Feature in vNext SQL Server

Originally appearing in my monthly column at Database Trends & Applications magazine. When it comes to cloud-based database management, there are really only two players: Amazon, the value leader, and Microsoft, the innovation leader. Amazon has carved out a niche as the value leader in cloud-based database management, supporting not only its own implementations of various database platforms such as MySQL and Hadoop, but also supporting premier commercial DBMSs such as Microsoft SQL Server and Oracle. Meanwhile, Microsoft has, in my mind, carved out a very strong niche as the innovation … [Read more...]

ICYMI – Predicate Logic, Four Things I Wish I’d Known Sooner, Transact-SQL Bad Habits, Rewriting Queries to Improve Performance

A digest of great articles originally appearing at SQLPerformance.com. Why Not Seek Predicate Paul White ( b | t ) proves, once again, why he is the best in the business when it comes to debugging a SQL Server query. In this post, Paul gives you a step-by-step breakdown of a query that goes astray due to implied predicate logic. Got a tough query of your own? Post it atanswers.sqlperformance.com! Four Things I Wish I Knew Sooner as a SQL Server DBA Lori Edwards ( b | t ) tells four things she wished she knew before she started her many year career as a SQL Server database … [Read more...]

Professional Development – What a Difference 60 Years Makes

Originally appearing at ForITPros.com. In 1957, the Soviet-made Sputnik streaked across the sky in low earth orbit. It was clearly visible to millions of concerned Americans. The Soviet government had leapfrogged America technologically. The dot that traversed the nighttime sky marked a change in international politics and fueled the engine that became America's space program. Another far more subtle shift was happening in America's businesses as well. In the 1950's and 1960's, American employees gave their loyalty to their employer in exchange for a commitment for a career-long job … [Read more...]

DBTA – IT Employers Must Adapt to the Looming DBA Shortage

Originally appearing in my monthly column at Database Trends & Applications magazine. In the first of this three-part series, I described some of the findings contained in an intriguing new survey published by Unisphere Research, a division of Information Today, Inc. In that article, I covered the macroeconomic and general trends that pointed to a looming shortage of DBA talent. In part 2 of the series, I described some of the issues and opportunities these trends offer to current and up-and-coming DBAs. Today, let’s talk about what this trend means from perspective of IT … [Read more...]

ICYMI – Recommended Intel Processors For SQL ’14, Should Indexes Be In The Key Or Included, Comparing Windows Azure VM Performance

A digest of great articles originally appearing at SQLPerformance.com. Grouped Concatenation in SQL Server and Grouped Concatenation: Ordering and Removing Duplicates In these two related blog posts, Aaron Bertrand ( b | t ) of SQL Sentry takes on the safest and most efficient ways to perform grouped concatenation in SQL Server. Then he follows up with a closer look at some additional requirements for typical grouped concatenation queries in SQL Server.Recommended Intel Processors for SQL Server 2014 Workloads Glenn Berry ( b | t ) of SQLskills continues his series on hardware … [Read more...]

Professional Development – Set the Bar High

Originally appearing at ForITPros.com. Henry Ford is reported to have once said, “Whether you think you can or think you can’t - you’re right.” That’s great insight. Too often people place self-imposed and artificial limitations on themselves. They tell themselves that they cannot accomplish something because they aren’t smart enough or don’t have enough creativity. They close their minds to the idea they can, in fact, succeed. Success, after all, is scary to many people. As a leader, one of your jobs is to inspire your team. Help them to recognize and realize their potential. Don’t … [Read more...]

DBTA – Does the Looming Shortage in DBAs Spell Opportunity?

Originally appearing in my monthly column at Database Trends & Applications magazine. In my last column, available HERE, I described some of the findings contained in an intriguing new survey sponsored by Ntirety, a remote database administration service provider, and published by Unisphere Research. You can read the full survey with analysis at HERE. One of the most startling and significant responses in the survey showed that 41% of data professionals intend to leave the field within the next 10 years. In that article, I also covered some of the broader industry growth and hiring … [Read more...]

ICYMI – Adding Filtered Indexes, Wait Statistics, Comparing Windows Azure Performance

A digest of great articles originally appearing at SQLPerformance.com. Dirty Secrets of the CASE Expression Aaron Bertrand ( b | t ) of SQL Sentry takes a look at some unexpected behavior with the CASE expression and some of its derivatives. Did you know that Aaron is both an uber-genius and a curling fanatic? Improbable, I know. An Unexpected Side-Effect of Adding a Filtered Index Paul White’s ( b | t ) deep dive post explains some of the limitations in the special use and usefully special kind of index, the filtered index. When applied in the appropriate scenarios, filtered indexes … [Read more...]