DBTA – 6 Reasons to Think About Upgrading to SQL Server 2014

  If you’re an IT manager, the first thing I’d like to tell you is how invested Microsoft is in SQL Server. While earlier incarnations of executive leadership focused in other areas (anyone remember “Developers! Developers! Developers!”?), Microsoft’s new leadership is very bullish on SQL Server. And, why not? After Microsoft Office and Windows Server, SQL Server is Microsoft’s third biggest money-making product line. Check out the recording of the “Accelerate your insights” webcast, about SQL Server 2014, featuring appearances by CEO Satya Nadella, COO Kevin Turner and CVP Quentin … [Read more...]

DBTA – Mission Critical Performance Enhancements in SQL Server 2014

  Microsoft has three major feature sets that they are advancing with SQL Server 2014 (SQL2014). One is called “Mission Critical Performance.”  Microsoft wants to stake out this ground not only as performance enhancements in the relational engine, but also those features which support better data availability, performance, security, and data integration. Read the rest of my article at http://www.dbta.com/Columns/SQL-Server-Drill-Down/Mission-Critical-Performance-Enhancements-Coming-in-SQL-Server-2014-92530.aspx … [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...]

Top 10 DBA Mistakes on SQL Server

  Hear one of my most popular session via streaming media at SQLSentry.TV! 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 … [Read more...]

Amazingly Useful SQL Server Articles on SQLPerformance.com

Me and Aaron Bertrand, SQL Sentry flagbearers. One of the things we've been working on at SQL Sentry is building up institutional knowledge for the SQL Server community. There are three main ways that we're doing that on-line: Hard-core tech articles on SQLPerformance.com, edited by long-time SQL Server MVP Aaron Bertrand ( b | t ). Helping tune tough SQL Server transactions on Answers.SQLPerformance.com for free. Streaming videos at SQLSentry.TV. In addition, our monthly eNews newsletter keeps you up to date on all the latest happenings on all of these websites. Please subscribe! … [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 database … [Read more...]

New Windows and SQL Azure Resources for the IT Pro

Thanks to Microsoft DPE for the Central Region, Keith Mayer (blog | twitter), for these great tips! Windows 8.1 RTM and Windows Server 2012 R2 RTM bits available on MSDN and TechNet subscription sites. This is the version I'm waiting for since it fully preserves the Start menu. Note that updates are expected between RTM, now, and GA, October 18th.  Be sure to check Windows Updates 2-to-3 times weekly if installing these bits.  I'm not saying they're unstable. But they are definitely changed frequently as the dev team makes final tuning and tweaking changes. New Virtual Labs on … [Read more...]

Now Playing on SSWUG TV!

Hi friends, I know a lot of you regularly read my blog either on my home page at KevinEKline.com, on SQLBlog.com, or one of the locations where it's syndicated. And you may also regularly take in my content on SQLSentry.TV or my monthly column on Database Trends & Applications magazine.   Click the image to see my new weekly video series on SSWUG.org! Now I'm adding a new video format to the mix, in partnership with my friend Steven Wynkoop and SSWUG.org.  I've been a frequent speaker in the SSWUG virtual conferences over the past several years and, we thought, why not … [Read more...]

New on DBTA.com: Database Benchmarking Tools, the final article in the database benchmarking series

In the last several articles on Database Trends & Applications, I've been describing the benefits of reading and analyzing the benchmarking case studies released by the Transaction Processing Council. I've given you from a broad overview of the TPC benchmarks and shown ways that the vendor-published TPC benchmarks can help you save money and how the vendor-published TPC benchmarks must explain in disclaimers how they tweak their workloads. I have described how to run your own benchmarks and explained how to properly prepare your environment for a benchmark test. Pictured (L-R): Scott … [Read more...]