THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Developer » Administration   (RSS)
Showing page 1 of 3 (24 total posts)
  • Stopping Execution of Future Batches

      There is a command that as far as I can tell has been in the product since SQL2008 but I was woefully unaware of. Actually I find many others are unaware as well and hence the blog post. The command is SET NOEXEC which has options for ON or OFF.  Normally this is OFF by default and the issue I was trying to solve was this: I have a ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 17, 2017
  • Source Control for SSMS

      It would be awesome if we could use source control such as TFS directly in SSMS like we can in Visual Studio but at the moment we can’t for the reasons explained by Ken Van Hyning in this blog post.  However he also explains how we can manually add some components that will give us the ability to use TFS with SSMS in the mean ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on November 25, 2016
  • SQLSentry does it Again – Plan Explorer is Completely Free

     Many of us have used the free version of Plan Explorer from SQLSentry for a long time to help tune and explore query plans in a way that SSMS can only dream of. Unlike most free tools this one still had plenty of useful features that served the community well. The Pro version did however contain a bunch of great features that many ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on September 8, 2016
  • SQL Server 2014 Overview on DBTA.com

     Haven't upgraded late? Well, SQL Server 2014 is a great place to start! Perhaps this is your first time reading my column on DBTA.com 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 ...
    Posted to Kevin Kline (Weblog) by KKline on November 25, 2014
  • Top 10 DBA Mistakes on SQL Server. (Now with Prizes for Participation!)

    The first big mistake I made as a DBA was coming to work with my zipper wide open. But I digress.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 ...
    Posted to Kevin Kline (Weblog) by KKline on April 9, 2014
  • New Windows and SQL Azure Resources for the IT Pro

    Here's a new post from my website, with many 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 ...
    Posted to Kevin Kline (Weblog) by KKline on September 17, 2013
  • SQLintersection!

    The best emotion to describe how I'm feeling is 'astounded'.  I'm astounded that I'm in such august company to be speaking the SQLIntersection (#iSQL) conference.  Read the blog post from my first SQL Server mentor, Kimberly Tripp, which tells you all about SQLintersection.Check out this list of speakers:Aaron Bertrand, ...
    Posted to Kevin Kline (Weblog) by KKline on March 27, 2013
  • The Year That Was - 2012

    2012 was, simply stated, a year that kicked my butt.  When I wasn't struggling professionally, I was struggling personally.  Health issues, culminating in a diagnosis of Type II diabetes, and the passing of my father soon after Thanksgiving marked my biggest struggles.  I apologize to those of you who are normally on my Christmas ...
    Posted to Kevin Kline (Weblog) by KKline on December 31, 2012
  • Learn More About SQL Server IO and Query Tuning in These Webcasts

    I'm doing two new webcasts next week on Wednesday, December 19th, one in the morning and the other after lunch.   SSDs are a Game Changer for SQL Server Storage No, session is not exclusively about SSDs.  But this is my first session on IO and storage tuning that emphasizes SSDs over hard disks.  As Bob Dylan said ''Times, they ...
    Posted to Kevin Kline (Weblog) by KKline on December 14, 2012
  • Let's Talk Licensing and Virtualization for SQL Server

    I have two new articles up on Database Trends & Applications magazine.  I'd love to get your thoughts and feedback!Welcome to the Weird, Wild World of SQL Server LicensingNot long in the past, SQL Server licensing was an easy and straightforward process. You used to take one of a few paths to get your SQL Server licenses. The first ...
    Posted to Kevin Kline (Weblog) by KKline on December 13, 2012
1 2 3 Next >
Privacy Statement