If you need to alter a database file and logfile to change their maxsize and filegrowth settings, here is a small script that might help you ---------------------------... spChangeMaxsizeandFilegrowt... Author: ......

---

One of the new cool features in SQL 2012 is the SQL Server Availability groups. In other words being able to failover a group of databases which are logically connected. i.e. SharePoint databases. Well it is also possible to do that in SQL 2008 (R2). It’s called a Grouped Failover. Instead of configuring it in SQL mirroring, you have to administrate ......

---

After installing vCenter and connecting it to a SQL Server 2008R2 database server and making it high available with the help of database mirroring, somthing anoying started to take place. After a full backup the transaction log does NOT get 'truncated' and shrunk. So within a day or 5 my transaction log drive was full and vCenter refused to operate. ......

---

Ok you have been playing around with SSRS 2008 R2 as did I and while I can’t wait to get my hands on CTP 2 of Denali here is some tips to get your reports a bit more standardized. The concept is called Report Parts. Report Parts are a SSRS 2008 R2 only feature. Basically it allows you to publish elements of a report as a separate objects to the report ......

---

Ok, so you have locked your SQL down. No users allowed. But then there is this information worker for whom the IT department made a special SSIS package. And they loaded the package in to the SQL server and created a SQL Agent job for it. Well no problem so far. But now the user wants to be able to start the job when ever he needs to. Hmmm, huge problem. ......

---