-
Is interest in SQL Server virtualization on the rise?
While the challenges of SQL Server virtualization have scared off some organizations, new technologies could make them take a second look.23 Nov 2009
-
Using the Pivot transformation in SQL Server Integration Services
Pivoting is a useful way to transform data in SQL Server Integration Services (SSIS) -- but it's hardly intuitive.20 Nov 2009
-
SQL Server MVPs give back with new book
Talk about a win-win. A new book gives DBAs and developers the chance to improve their crafts while donating to a good cause.18 Nov 2009
-
SQL Server high availability: Options and caveats
DBAs have several techniques to choose from for ensuring SQL Server availability. Deciding on the right one for you is all about evaluating the costs versus the benefits.17 Nov 2009
-
Using traces in SQL Server Profiler
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.12 Nov 2009
-
Using DELETE and TRUNCATE TABLE statements to delete data in SQL Server
Both statements can be used to delete SQL Server data, but some situations call for one over the other.10 Nov 2009
-
Meet compliance requirements with improved database security practices
Small but consistent changes are the trick to securing your SQL Server database and maintaining compliance with the latest industry rules and regulations.05 Nov 2009
-
New SQL Server 2008 R2 CTP set for November
Microsoft's next-generation DBMS will be released to manufacturing in early 2010, along with two new editions for the enterprise.03 Nov 2009
-
PASS Summit 2009 Preview
Learn what the hot topics will be at this year's PASS conference, with speaker interviews, product news and more.02 Nov 2009
-
DBA career paths could lead to business intelligence
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.02 Nov 2009