SearchSQLServer: Expert advice on database administration

Using traces in SQL Server Profiler

Denny Cherry — Fri, 13 Nov 2009 00:00:00 EST

A SQL Server Profiler trace can provide critical information on a problem query in a matter of seconds. Learn how – and when – to run the application.

Using DELETE and TRUNCATE TABLE statements to delete data in SQL Server

Robert Sheldon — Tue, 10 Nov 2009 11:04:35 EST

Both statements can be used to delete SQL Server data, but some situations call for one over the other.

New SQL Server 2008 R2 CTP set for November

Brendan Cournoyer — Tue, 03 Nov 2009 15:04:00 EST

Microsoft's next-generation DBMS will be released to manufacturing in early 2010, along with two new editions for the enterprise.

DBA career paths could lead to business intelligence

Brendan Cournoyer — Mon, 02 Nov 2009 16:00:36 EST

Business intelligence could prove to be an ideal specialty for SQL Server DBAs who feel like they've hit a wall with their current jobs.

Hardening the network and OS for SQL Server security

Matthew Schroeder — Fri, 30 Oct 2009 09:20:41 EST

To help prevent a major breach of your DBMS, it's important to secure all individual systems in an environment, including the network and operating system.

Securing the server and database in SQL Server

Matthew Schroeder — Fri, 30 Oct 2009 09:20:02 EST

Hardening SQL Server at the database and server levels is crucial to a secure environment. Learn why in part two of our SQL Server security series.

SQL Server Mailbag: CALs, witnesses and unwanted changes

Denny Cherry, Contributor — Tue, 27 Oct 2009 12:54:59 EST

In this edition of the SQL Server Mailbag, database expert Denny Cherry answers reader questions on SQL Server licensing, monitoring IT personnel and various connection issues.

Are data warehouses made for the cloud?

Brendan Cournoyer, Site Editor — Fri, 23 Oct 2009 12:06:30 EDT

Cost and scalability benefits might make data warehousing seem like a perfect fit for cloud computing, but storage limitations with Azure could slow deployments.

Q&A: Moving forward with SQL Server in the cloud

SearchSQLServer.com Staff — Mon, 19 Oct 2009 11:36:34 EDT

DBAs and developers have concerns about cloud computing , but enhancements to Microsoft's SQL Azure Database could ease those worries.

SQL Server security made simple and sensible

Don Jones, Contributor — Wed, 14 Oct 2009 10:56:47 EDT

The many layers of SQL Server security can be confusing. Learn to connect to SQL Server and retrieve data from databases, as well as the ins and outs of object ownership.