DBTA – Mission Critical Performance Enhancements in SQL Server 2014

November 24, 2014 by Leave a Comment

  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...]

Filed Under: Administration, Databases, DBTA, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: ,

DBTA – SQL Server 2014 Overview

November 17, 2014 by 1 Comment

  Perhaps this is your first time reading my column or you don’t know much about SQL Server. If either of those are true, then it might be a surprise to you that Microsoft has accelerated the release cadence for SQL Server to around one new release every 18 to 24 months. Add in the fact that Microsoft goes to market with their beta releases, better known as Community Technology Preview (CTPs), several months before the official release of the product. That means we could be in for a rush of new features and upgrades every year or so. Wow. Read the rest of my article … [Read more...]

Filed Under: DBTA, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: , ,

SQL Saturday Dublin and Pre-Conference Seminars

September 15, 2014 by Leave a Comment

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...]

Filed Under: Conferences Tagged With: , , ,

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

August 29, 2014 by 9 Comments

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...]

Filed Under: Administration, Databases, Presentations, Professional Development, SQL Server, SQLServerPedia Syndication, TCD blog post, Tips & Tricks, Transact-SQL Programming Tagged With: , , , , ,

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

August 12, 2014 by 3 Comments

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...]

Filed Under: Administration, Databases, On-Line Resources, SQL Server, SQLServerPedia Syndication Tagged With: ,

Amazingly Useful SQL Server Articles on SQLPerformance.com

March 3, 2014 by 2 Comments

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...]

Filed Under: Administration, Architecture, On-Line Resources, Performance, SQL Server, SQLMag, Transact-SQL Programming Tagged With: , , , , ,

Join Me on March 14 in Silicon Valley for a Full-Day of SQL Server Configuration Tuning Lessons

February 18, 2014 by Leave a Comment

  Join me for a day of Real World Database Configuration and Tuning for Microsoft SQL Server SQL Saturday Silicon Valley 2014 Friday, March 14, 2014 from 8:30 AM to 4:00 PM (PDT) Mountain View, CA Click HERE to register Now! Seating is very limited!   This full-day training event combines a thorough overview of fundamental architectural concepts of the SQL Server relational engine followed by hands-on demos to reinforce each conceptual lesson. Since most technologists learn by doing, this training is designed to maximize the time attendees spend working with SQL Server. … [Read more...]

Filed Under: Challenges, Databases, PASS, Performance, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: , , ,

One Preparation that makes SSMS Crash Dumps Easy to Survive

February 10, 2014 by Leave a Comment

  Uh oh! So you're plugging along in SQL Server Management Studio (SSMS) when it suddenly goes belly up. Now you're staring at various dialog boxes telling you that SSMS crashed. Usually the first dialog box you get will ask you if you'd like to close OR the program. If you choose to close the program, you'll be presented with the opportunity to recover your lost SQL scripts once you reopen SSMS, as shown above.  (Image above courtesy of Aalam Rangi). But let's say that closing the program represents a big issue for you due to lost time, productivity, etc. You want to go … [Read more...]

Filed Under: Challenges, Databases, IT Horror Stories, SQL Server, SQLMag, SQLServerPedia Syndication, Tool Time Tagged With: , , ,

What Does a Good Mentor Do for You?

January 13, 2014 by 1 Comment

These would be good mentors - me plus Adam Machanic, and Klaus Aschenbrenner Not long ago, John Sansom (Twitter | Blog) kicked off a SQL Community Project #DBAJumpStart by asking 20 successful and experienced SQL Server professionals this exact question: "If you could give a DBA just one piece of advice, what would it be?" I wrote up my Advice for the Aspiring DBA post here, while John collected the entire set of responses here within the DBA JumpStart collection. Part of my advice, indeed of several of the contributors, was to find and build a strong mentor-protege relationship.  But what … [Read more...]

Filed Under: Opinion, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: , , , , ,

One Piece of Advice for the Aspiring Junior DBA

December 10, 2013 by 3 Comments

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...]

Filed Under: Administration, Opinion, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: , ,
« Previous Page
Next Page »