SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: October 2011

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… Read more

1 comments, 1,519 reads

Posted in Kevin E. Kline on 31 October 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.… Read more

0 comments, 832 reads

Posted in Kevin E. Kline on 27 October 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… Read more

0 comments, 676 reads

Posted in Kevin E. Kline on 21 October 2011

PASS Summit 2011, Day 3 – A Tribute to Wayne Snyder

First things first, Wayne Snyder is rolling off the board of directors for PASS this year.  We’d worked together, shoulder to shoulder along with Joe Webb (blog | @joewebb) and other outstanding members of the SQL Server community, for many years of on the PASS board of… Read more

0 comments, 1,007 reads

Posted in Kevin E. Kline on 14 October 2011

PASS Summit 2011, Day 1

I’ve already had a few good days in Seattle/Redmond this week, meeting with the Microsoft SQL Server program teams and with other Microsoft SQL Server MVPs.  I was as excited as a squeeling Justin Beiber fangirl waiting for his new video, wishing I could tell you all of the cool… Read more

0 comments, 595 reads

Posted in Kevin E. Kline on 13 October 2011