DBTA – Delayed Durability—The SQL Server 2014 Transaction Log Hack!

Originally appearing in my monthly column at Database Trends & Applications magazine. Delayed durability was announced late in the SQL Server 2014 development cycle, but offers something that many SQL Server professionals have wanted for years—the ability to disable transaction logging. Why turn off the transaction log? It is the main guarantor of transactional consistency in SQL Server and is critical for highly recoverable applications, after all. That answer, in itself, tells you about situations where you might like to turn off the transaction log. That is, you can accelerate … [Read more...]

DBTA – For #SQLFamily, a Most Wonderful Time of the Year!

Originally appearing in my monthly column at Database Trends & Applications magazine. It’s the holiday season, a time for cheer and goodwill towards men. That got me thinking about the whole “most wonderful time of the year” tune playing in the background and how that has some special implications for the SQL Server world. Here’s a bit of context: I'm writing this article for you in the midst of the biggest gathering of SQL Server professions in any given year, the PASS Summit. One of the most visible activities when attendees get together for the very first time at the registration … [Read more...]

IT Employers Must Adapt to the Looming DBA Shortage

In the first column in this three-part series, available here, I described some of the findings contained in an intriguing new survey published by Unisphere Research, a division of Information Today, Inc. (Details here.)  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 employers. IT ORGANIZATIONS UNDER PRESSURE If you lead a team of … [Read more...]

Does the Looming Shortage in DBAs Spell Opportunity?

In my last column, available online, 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 www.dbta.com/DBTA-Downloads/ResearchReports/The-Vanishing-Database-Administrator-Survey-Of-Data-Professionals-Career-Aspirations-4791.aspx. 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 … [Read more...]

Converging Factors Mean Major Opportunities for DBAs

IT Managers and Executives: If you think it’s hard to hire a talented DBA, you ain’t seen nothing yet. If you think that a talented DBAs are expensive, just you wait. Data Management Professionals: If you thought a career in database administration might be appealing to you, it’s time to act upon that hunch. It’s a good time to be or become a DBA, but it’s going to be even tougher as an employer of DBAs. There are a number of factors as to why this is true. In this column, we will look first at the factors coming to bear on the wider market. In the next columns to follow, we will look at … [Read more...]

One Piece of Advice for the Aspiring Junior DBA

This post is part of the SQL Community Project #DBAJumpStart by John Sansom (Twitter | Blog). "If you could give a DBA just one piece of advice, what would it be?" John asked 20 successful and experienced SQL Server professionals this exact question. I share my own thoughts with you below and you can find all our answers together inside DBA JumpStart, a unique collection of inspiring content just for SQL Server DBAs. Be sure to get your free copy of DBA JumpStart. =-=-=-= John Sansom recently asked me and 19 other bloggers “What’s the one bit of advice you’d give a junior … [Read more...]

RT @sqlmag: When do I want to look at IOPs vs Mbytes per second? by @mrdenny http://bit.ly/uDiYVh dba sqlserver IOTuning sqlservermag … [Read more...]

https://kevinekline.com/15149-2/

Do you use Sybase? Then take a look at the free Toad for Sybase beta at http://bit.ly/eyefhS. sql sybase dba … [Read more...]

https://kevinekline.com/15214-2/

Need to know what happened in your SQL_Server database? Join me tomorrow for a webcast on database auditing: http://bit.ly/gi9KrO sql dba … [Read more...]

https://kevinekline.com/15220-2/