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

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

 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

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

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