Will cloud services render DBAs obsolete? Does the cloud mean that developers will use less of SQL Server? Kendra talks about the future of database administration and gives tips on strategizing your career.
Learn why the output from the built-in procedure sp_who2 can be so confusing, how to get more information, and free tools that can make it easier to figure out what you need to pay attention to in SQL Server.
Learn where full-text search shines, a common problem which full-text search does NOT solve, where full-text can run into performance problems.
Learn the difference between heaps, clustered and nonclustered indexes, primary keys, and columnstore indexes in SQL Server.