OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...

Microsoft has introduced SQL Server 2012 to the world and it's time for IT professionals to start to come to speed on what's new. Microsoft has introduced SQL Server 2012 to the world and it's time ...

Learn tips for administering SQL Server securely. Of course, you might not have a domain at all. In this case, each server maintains its own SID database of users and objects. If users want access to ...

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation. In a previous TechRepublic column about SQL Server ...

SQL Server also provides a parallel to Windows groups, called roles. There are two types of roles, one for the server and one for the database. Server roles are groups that allow you to control the ...