How to Start SQL in Single-User Mode. Organizations can use SQL Server to reduce downtime, manage and secure databases, and discover patterns in mission-critical information to improve business ...

Learn how to effectively manage and query databases with this practical SQL guide. Enhance your data analysis skills and boost productivity.

In-Depth Use the Best Security for SQL Server Learn tips for administering SQL Server securely. By 01/01/2004 E xamine the similarities and differences between Windows security and SQL Server security ...

Your SQL Server user ID must have sufficient authority to reset an identity seed. If you are the table's owner, this grants the authority, as does a sysadmin or db_ddladmin user type. If your user ...

In-Depth SQL Server 2008 Is Finally Here. Now What? Microsoft's latest relational database management system contains a host of new features, but are they enough to make you migrate? By Eric ...

Kevin Kline, director of engineering services at SQL Sentry, Microsoft SQL Server MVP since 2004, founding board member of PASS, and DBTA columnist, is hitting the road this summer to reach cities ...

SQL Server 2008 has a ton of new DBA features, but if you really want to make this thing go, just crank out a little code.