How To Forecast Database Disk Capacity If You Don’t Have A Monitoring Tool

In a previous blog post, I mentioned why regularly shrinking your databases is not the right way to reclaim space. I also mentioned at the end of the blog post that the proper way to deal with database space issues is to monitor your disk space utilization and do proper capacity planning. That’s where tools like […]

Why Regular Shrinking is NOT the Right Way to Reclaim Database Space in SharePoint

I recently got a question about how to reclaim database space in SharePoint. The specific database mentioned was WSS_Logging although this could have been any of the SharePoint databases or any other SQL Server database for that matter. The database was growing really fast so the farm was configured to only keep a week’s worth […]

What Smart Database Developers Know About Database Connectivity

When I got started with computer programming, I immediately jumped into database programming. I wanted the application that I am writing to interact with a database so I can create, update and delete (CRUD) records. Every database developer knows that the first thing they need to learn is how to connect to a database – […]

Four Challenges That You Need To Address For A Successful Database Migration

–Hurdles Start by Robert Voors – With less than a year before SQL Server 2005 extended support ends, customers can start planning on upgrading their databases to SQL Server 2014 or even SQL Server 2016 when it is released. In a previous blog post, I talked about how to integrate Microsoft Product Lifecycle and Support Policies […]

Confessions of a Junior SQL Server DBA

– Photo by Milada Vigerova – Wayne was getting ready to meet the director of engineering, the person responsible for hiring him. They spoke briefly over the phone for the scheduled interview. The director happened to be from Romania but spoke very good English that you’ll think he grew up in America. The role: Windows engineer. This […]