Joey on SQL Server Hands-On with Copilot for Azure SQL Database I've been playing around with the new Microsoft service, currently in preview and it's time to show off what it can do. By Joey D ...

SQL Server 2008 SP3 Express, a free edition of Microsoft's database management system, can be downloaded here. Microsoft also released a Feature Pack for SQL Server 2008 SP3.

The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...

Figure 3. Your SQL Database Servers. Next, you'll need to create the rule to allow one or a block of IP addresses. If you'd like just to let the public IP address you are coming from (if the computer ...