This past Friday I received a call from our systems team stating that they were running low on Disk Space...  Read more...

By default, there are six achieved SQL Server Error Logs along with the ERRORLOG which is currently used. However, it is a Best Practice to increase the number of SQL Server Error Logs from the default value of six. In this tip, you will see the steps which you need to follow to increase the number of SQL Server Error Logs.  Read more...

 A colleague pointed out a site that collects a lot of job posting data and exposes graphs - so I've taken...  Read more...

By default, there are six achieved SQL Server Error Logs along with the ERRORLOG which is currently used. However, it is a Best Practice to increase the number of SQL Server Error Logs from the default value of six. In this tip, you will see the steps which you need to follow to increase the number of SQL Server Error Logs.  Read more...

I have not worked with SQL Server 7.0 in a loooong time.  So when I received a call from a...  Read more...

The new HierarchyID datatype in SQL Server 2008 has captured my interest lately. I’ve been working on a presentation that...  Read more...

SQL Server is so large and complex that it's like an operating system. In fact, there the core engine is often referred to as the "SQL OS" by Microsoft developers. Steve Jones would like to see SQL Server as it's own OS at some point.  Read more...

SQL Server is so large and complex that it's like an operating system. In fact, there the core engine is often referred to as the "SQL OS" by Microsoft developers. Steve Jones would like to see SQL Server as it's own OS at some point.  Read more...

SQL Server is so large and complex that it's like an operating system. In fact, there the core engine is often referred to as the "SQL OS" by Microsoft developers. Steve Jones would like to see SQL Server as it's own OS at some point.  Read more...

SQL Server is so large and complex that it's like an operating system. In fact, there the core engine is often referred to as the "SQL OS" by Microsoft developers. Steve Jones would like to see SQL Server as it's own OS at some point.  Read more...

I read Jack Corbett's blog entry,No Training Budget Still No Excuse, last week and thought it was excellent. In fact,...  Read more...

Recently I have been involved in lots of projects involving replication.  I have done some things to make replication work...  Read more...

You know, I believe the old saying, “If you don’t use it you will lose it”.  Well, I write a...  Read more...

Tim Mitchell presented at SQLSaturday #17 on Scripting in SSIS. I thought it was a really interesting presentation, and I’m...  Read more...

The Baton Rouge Area SQL Server User Group hosts Bi-Monthly Live Meetings that are 15-30 minutes long the consist of...  Read more...

This past week the Exchange 2010 team admitted they had tried SQL Server as a storage platform for Exchange 2010, but then discarded it. Steve Jones wonders why this was the case. Is SQL Server not good enough?  Read more...

Inside the SQL Server Tacklebox you'll find day-to-day tools and techniques to automate and standardize SQL Server installation, document and report on your servers, migrate data and manage data growth, troubleshoot performance issues, receive notifications of impending issues, secure access to your servers and fight off the data corruption monster.  Read more...

Find the country, region and city of a user from an IP address using SQL Server. Oscar Garcia provides some code and resources if you want to dig into your analytics on your own.  Read more...

Many DBAs need to work with multiple platforms. New author Jagan Kumar brings us an article that helps to explain Oracle's architecture for those people used to working with SQL Server.  Read more...

Use of event handlers provided in SSIS package to handle runtime errors while the package is running and logging the error information in the database.  Read more...