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 » Transact-SQL Programming   (RSS)
  • 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 ...
    Posted to Kevin Kline (Weblog) by KKline on March 3, 2014
  • 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
  • Help Me Update the History of SQL Server

    I was chatting with my buddy, Buck Woody (Twitter | Blog), about a week ago and we were discussing that it's pretty hard to put together the entire history of SQL Server.  Then the thought hit me that I'd already done this, to a degree, in my book Transact-SQL Programming.  This was the first Transact-SQL programming ...
    Posted to Kevin Kline (Weblog) by KKline on September 12, 2012
  • Flexibility When Waiting on Locks

    Speaking at a recent SQL Saturday, an attendee in one of my sessions wanted to know how they could more flexibly react to locks on their application than to wait for blocks to occur and then kill the SPID at the head of the blocking chain.  They were also interested in some alternatives to using the  SQL Server syntax like the ...
    Posted to Kevin Kline (Weblog) by KKline on May 17, 2012
  • Dev Advice: Make a Tiny Dev Database Act Like a HUGE Prod Database

    Here's an evergreen question. It's a question that never completely goes away. But lately, I've been getting it a few times per week. So I thought it's time to readdress the question, which usually takes some form of the following:I can't really do effective development on my little dev laptop because our production SQL Server database is 15 ...
    Posted to Kevin Kline (Weblog) by KKline on March 16, 2012
  • Everybody Needs a Test Harness

    When you're developing new Transact-SQL code or modifying some existing code, do you just launch directly into programming? I know that I did just that, for years. It wasn't until I was trying to performance tune some existing code that I realized I hadn't actually taken caching of data and execution plans into account. So all those modified ...
    Posted to Kevin Kline (Weblog) by KKline on October 31, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement