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 » Tips   (RSS)
Showing page 2 of 8 (78 total posts)
  • 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
  • Utility Objects Series Introduction (but mostly a bit of an update)

    So, I have been away from blogging about technical stuff for a  long time,  (I haven’t blogged at all since my resolutions blog, and even my Simple Talk “commentary” blog hasn’t had an entry since December!)  Most of this has been due to finishing up my database design book, which I will blog about at least one more time after it ...
    Posted to Louis Davidson (Weblog) by drsql on March 11, 2012
  • Must-Have Resources - SQL Server Backup & Recovery

    One of the things that drives me crazy as I'm getting older is that my brain is losing the capacity to differentiate version numbers. As I speak travel around speaking with customers and at conferences, I find my self saying things like ''I can't recall if this problem was fixed in SQL Server 2000 or 2005. But you don't have to worry about that ...
    Posted to Kevin Kline (Weblog) by KKline on December 8, 2011
  • Information Hoarder No More!

    I hate to admit it, but I'm a hoarder. Yes, like those insane people on the A&E TV show. Only my hoarding is all virtual. For example, take the image above. That's just a tiny part of my Google Reader home page. That's a tiny part of my Google Reader home page AFTER reading most of the day on a recent Sunday. I still had thousands of ...
    Posted to Kevin Kline (Weblog) by KKline on November 2, 2011
  • Simplifying CSV Data Loads

    Data files containing comma separated values, or CSV, are some of the most common data formats used for data representation and storage outside the database.  When it comes to loading CSV data into the database, many options exist, however, few make it as simple as CSVexpress, powered by expressor software.  I recently visited ...
    Posted to Kevin Kline (Weblog) by KKline on October 27, 2011
  • Troubleshooting Repeated Login Failures on SQL Server

    I’d recently experienced a situation where I was getting repeated login failures to a SQL Server where I knew that I had the correct user name and password.  Each time, I’d get error 18456 in response. ''Login failed for user '<user_name>'. (Microsoft SQL Server, Error: 18456)''. The challenge when troubleshooting ...
    Posted to Kevin Kline (Weblog) by KKline on October 21, 2011
  • What I'm Reading, July 22 2011

    I read too much, and that, my friends, is an entirely separate topic for a blog post. But I thought I'd share with you a little more about what I'm reading because sometimes, if I'm lucky, it might be something you'd enjoy too. So I'm going to start sharing what I'm reading at least once per week, partly so that I don't firehose too many ...
    Posted to Kevin Kline (Weblog) by KKline on July 21, 2011
  • Microsoft Windows Platforms Blog Watch

    Remote Desktop Services Component Architecture Poster Grab your own poster! A visual guide to key Remote Desktop Services technologies in Windows Server 2008R2     Virtually Free Get the latest update rollup package for the Hyper-V role in Windows Server 2008 R2 and be sure to bookmark the Windows Virtualization ...
    Posted to Kevin Kline (Weblog) by KKline on July 20, 2011
  • Pulling real-time data from Twitter using StreamInsi​ght and Other Scandinavian Treasures

    On my recent trip to SQLBits with subsequent visits to Dublin, Cologne, and Malmo (southern Sweden), I enjoyed a chance to meet several SQL Server MVPs, including Peter Larsson and Thomas Ivarsson. Among them, I enjoyed Johan Ahlen's article on Pulling real-time data from Twitter using StreamInsi​ght.  You can Find Johan's blog ...
    Posted to Kevin Kline (Weblog) by KKline on May 3, 2011
< Previous 1 2 3 4 5 Next > ... Last »
Privacy Statement