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 any more." Or things like "That feature was added in SQL Server 2008 R2, eh, or was that version 6.5. DOH!" followed by a loud slapping sound as I whap my palm into my forehead. The Internet doesn't forget either. Recommendations that were once … [Read more...]
Must-Have Resources – SQL Server Backup & Recovery
Filed Under: Administration, Challenges, Databases, On-Line Resources, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: Backup & Recovery, DBA, Quest Software, SQL Server 2008 R2, Video
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 entries to go after hours of reading. On top of that, I subscribe to some technical e-newsletters. I'm a member of quite a few LinkedIn discussion groups, each of which produce daily and weekly newsletters. (I only subscribe to the weekly versions). … [Read more...]
Filed Under: Challenges, Opinion, Professional Development, SQLMag, SQLServerPedia Syndication, Tips & Tricks Tagged With: Career, Plays Well With Others, Productivity
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 stored procedures that I was so proud of might not actually be faster than the first generation of procedures because I hadn't checked to ensure that I was testing cached programs against uncached programs (and, by extension, the data used by those … [Read more...]
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 www.csvexpress.com to check out just how simple it could get. In short, CSVexpress offers a repeatable and quick way to load any CSV file into SQL Server (or any other database). For those whose data quality is not as pristine as it should be, CSVexpress also offers … [Read more...]
Filed Under: Administration, Cool Technologies, Databases, SQL Server, SQLMag, SQLServerPedia Syndication, Tips & Tricks Tagged With: Data Cleansing, Data Quality, DBA, ETL, Master Data Management, SQL Server 2008
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 this error message is that you may have a problem with SQL Server or you may have a problem with Active Directory or Kerberos, if you’re using one of those authentication technologies. A False Trail When times are good, and you’re able to make a connection, you … [Read more...]
Filed Under: Administration, Challenges, Databases, On-Line Resources, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Tips & Tricks Tagged With: MVP, SQL Server 2008 R2, Troubleshooting
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 directors and I'm certain that my tenure on the board and as president of the organization would've been nothing but trouble had Wayne not been there, covering my blind side(s), at every turn. Here's my tribute to Wayne Snyder: If you were to mention “Wayne Snyder” to me, I’d instantly start to grin and, probably, nod a … [Read more...]
Filed Under: BigData, Conferences, Databases, NoSQL, PASS, Presentations, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: FutureWatch, Hadoop, MapReduce, SQLPASS
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 things I learned at Redmond about the future of SQL Server. But as you'd expect, all of that cool stuff is presently NDA. I'm sure there'll be some cool announcements from Microsoft this week. So be on the lookout for the good word from Microsoft. Keynote Rushabh Mehta, the PASS president, spent a few moments … [Read more...]
Filed Under: Cloud, Conferences, Databases, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: BigData, cloud computing, DBA, Hadoop, Quest Software, SQLPASS
Here, There, and Everywhere; Speaking in Fall 2011, Part 1
The last quarter of the year is usually my busiest due to the fantastic PASS Summit and SQLBits events. The fall looks a little different ... BECAUSE IT WILL BE EVEN BUSIER! Here's a rundown of where I'll be this fall through mid-October: BASTA! SQLCON.NET September 26 to 29; Mainz, Germany This big developer and admin conference runs from September 26 to 29 in Mainz, Germany. I'll be delivering at least one session and hobnobbing with Quest customers, friends, and in a very weird twist, my oldest daughter Emily, who will be in the Rhineland at the exact same time on a … [Read more...]
Filed Under: Conferences, Databases, PASS, Presentations, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: Career, Professional Development, SQLPASS, SQLSaturday, Training
Women in Technology: A Quick Observation and a Quick Straw Poll
A bit of background: Those aren't grand daughters of the Clampetts in the picture at right. Those are my three daughters and three stepdaughters, all of whom I want to inherit the world - as little or as much as they want to take hold of. (I already talked a bit about this in a post on my personal, family blog. Be warned, it's all boring family photos and such). Enabling them to have all of the choices and opportunities that are open to my son is a big motivating factor in my life. So many years ago, when several PASS volunteers wanted to start doing more to build a community of support … [Read more...]
Filed Under: Challenges, Conferences, Ethics, Opinion, PASS, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Trends Tagged With: WIT
Upcoming SQLSaturday Events in Omaha and Atlanta!
I've had enough time off from traveling after my surgery to finally travel again. First on the circuit , set for August 27th, is Omaha, Nebraska and SQL Saturday #91. As a former Crimson Tide alum, I was stoked about going to the University of Nebraska, our once and future rivals on the Grid Iron. But after a moment's confusion, I remembered that the Huskers are over in Lincoln, not Omaha. (May Bear have mercy on my soul.) Almost all of the speakers are friends. Many are Microsoft MVPs. So it'll be great to catch up with these fine folks and, I hope, get a chance to meet many … [Read more...]
Filed Under: Conferences, Databases, PASS, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: Quest Software, SQLPASS
