With the release of an in-memory database from Sybase, is it time for SQL Server to join the fray?

Concatenating Strings to NULL values

by bruhaspathy@hotmail.com

SQLServerCentral.com

Blogs

We recently ran into this situation of reports containing nothing but blank spaces. When investigated the reason was that the String...

Learn about SQL Server without leaving your desk

by Press Release

SQLServerCentral.com

Training

SQL Server Central, with Pragmatic Works, is offering a new option in learning: high-quality training at a fraction of the usual cost with work absence slashed to zero. Our classes are done online with the same type of quality instructor you would receive from our private classes but done at your own desk. Even though you're doing the class online, the instructor can still hear you while you ask questions and optionally see your screen. Because the class is done in half-day increments, you also still have time to do your job.

Managing Data Growth in SQL Server

by Additional Articles

SimpleTalk

Administration

'Help, my database ate my disk drives!'. Many DBAs spend most of their time dealing with variations of the problem of database processes consuming too much disk space. This happens because of errors such as incorrect configurations for recovery models, data growth for large objects and queries that overtax TempDB resources. Rodney describes, with some feeling, the errors that can lead to this sort of crisis for the working DBA, and their solution.

Rotating Keys

by Steve Jones

SQLServerCentral.com

Editorial

This Friday's poll deals with security. Steve Jones asks how often you might rotate those encryption keys to ensure that your systems are secure.

ROW_NUMBER(): An Efficient Alternative to Subqueries

by Francis Rodrigues

SQLServerCentral.com

T-SQL

The ROW_NUMBER function has drastically changed the way we can write a number of queries in T-SQL. New author Francis Rodrigues brings us a few places where this function can improve the efficiency of your code.

Brad's Sure DBA Checklist

by Additional Articles

SimpleTalk

Career Growth

Sometimes, all a DBA needs, to help with day-to-day work, is a checklist of best-practices and dos and don’ts. It provides a handy reminder. Brad has come up with a new update to his famous checklist...

Microsoft SQL Server vs. MySQL

by Additional Articles

MSSQLTips.com

SQL Server

Is Microsoft SQL Server superior to MySQL or not? What are the pros and cons of using SQL Server over MySQL? Is MySQL mature enough to compete with a big player like Microsoft and Oracle? Can we fairly compare both products?