There have been a lot of blog posts and articles written about the Delayed Durability feature in SQL Server 2014. Here are a couple of them to get you started. Delayed Durability in SQL Server 2014 by SQL Server MVP/Regional Director and SQLSkills CEO Paul Randal (blog | Twitter) Delayed Durability in SQL Server 2014 by […]
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 […]
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 […]
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 – […]
–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 […]