(Valentino Vranken) On the forums I now and then encounter questions asking for a checkbox control. And the methods usually presented are either through images or by using a certain font one way or another. However, as of SQL Server 2008 R2 there is actually a third and interesting alternative whi

(Matt Bowler) I’ve no idea who originally said that – but it probably qualifies as DBA folklore. I blogged recently about backups in SSAS so to close the loop here are the basics of restoring SSAS databases.

This article describes how to transfer the logins and the passwords between instances of Microsoft SQL Server 2005, of Microsoft SQL Server 2008, and of Microsoft SQL Server 2012 on different servers.

(Greg Larsen) If you are like most, you probable do not install the newest version of SQL Server as soon as the bits are released by Microsoft. Instead you wait for a one or more Community Updates (CUs) or the first Server Pack (SP) to be released. Why would anyone want to be on the bleeding edge

(Robert Sheldon) SQL Server now includes a set of functions that lets you generate date and time values based on individual integers. The first of these is the DATEFROMPARTS function, which takes three arguments — the year, month and day — and converts them into a DATE value.

(Bharti Batra) Today all organizations have important data that is confidential and mission-critical, and should not be disclosed to unauthorized persons. Hence the security of data is one of the prime aspects of a DBA’s job.

(Matteo Lorini) Will SQL Server database mirroring stop working if the user used to create the endpoints is removed? In this tip we will walk through the steps to find out.

(Jignesh Trivedi) Table Valued Parameter is a new feature introduced with SQL Server 2008. Table Valued Parameter helps us to pass multiple rows of data from a client application to SQL Server without multiple round trips. We can pass multiple rows to a stored procedure using a Table Valued Paramete

(Ashish Kumar Mehta) One of the junior SQL Server Database Administrators in my company approached me yesterday with a dilemma. He was restoring a large database on a Failover Cluster Production Server and while the restore was in progress, due to network failure, the restore failed.

(John Sansom) Bluntly put, this is something that you always want to be taking advantage of.