• subscribe

Delivering practical database advice for DBAs, developers, and BI analysts

What is your favorite feature in SQL Server 2012?



Vote Results Previous Polls



Solving Common SQL Server Problems

 

Solving Common SQL Server Problems

Discover insights, techniques, and resources for troubleshooting performance, connectivity, and other types of problems commonly encountered in SQL Server environments.


Get Newsletters

  • Get the Latest News
  • Product Updates
  • Helpful Tricks
  • Programming Tips
subscribe to SQL Server Pro Newsletters

Training SQL Server Newbies to Avoid Basic Database Mistakes?

SQL Server professionals still forget to put indexes on tables and still forget to test their backups. Do other professions do a better job of training newbies so that certain basic mistakes tend to...

SUSPECT vs. RECOVERY_PENDING

Question: I’ve been working through some disaster recovery scenario testing and sometimes I see databases marked SUSPECT and sometimes RECOVERY_PENDING. Why are there two different database states...

SQL Injection – Beyond the Basics

Ensuring a proper understanding of core concepts and avoiding common pitfalls are the keys to protecting against SQL injection....


8 Useful (and Free) SQL Server Downloads

The best free SQL Server downloads to help you do your job....

T-SQL Best Practices, Part 1

Some T-SQL best practices include thinking in a relational way, always remembering NULLs and the three-valued-logic, realizing the full implications of using the NOLOCK hint and therefore avoiding...

SQL Server Log Files

SQL Server logs can make troubleshooting problems simpler—if you know where to look. Here are 5 SQL Server 2005 log files that might come in handy....


IAMs: Keeping Track of Space Used

Every SQL table and index has at least one Index Allocation Map (IAM). Learn more about IAMs and how much space is actually allocated to a SQL Server table....

8 Useful (and Free) SQL Server Downloads

The best free SQL Server downloads to help you do your job....

SQL Server's Trace and Replay Tool

The trace and replay tool in SQL Server Profiler provides a powerful yet flexible tool for comparing and analyzing performance between different environments....


More Top Stories

Product Review: NetWrix SQL Server Change Reporter 2.2

This change-auditing solution lets you monitor, track, and report changes occurring on multiple SQL Server instances across a company.

Introducing Microsoft Power View

Power View is an easy-to-use business intelligence (BI) tool that helps people make sense of their data.

Using Registered Servers in SSMS

The Registered Servers tool in SQL Server Management Studio lets you easily save the connection information for multiple SQL Server instances.

Query Performance Tuning

Performance tuning is half science and half art form. Learn about the science half of the tuning process.

T-SQL Best Practices, Part 2

Itzik continues his discussion of T-SQL best practices; he discusses cloud compatibility, date and time best practices, the importance of writing in a standard way, and ...

Things You Might Not Know about SQL Server 2012

Microsoft SQL Server 2012 has major new features, such as the new Business Intelligence edition, as well as smaller changes to licensing and a new LocalDB edition.

SQL Server Database Corruption–Part X: Page Level Restore Operations

In my previous post in my ongoing series on SQL Server database corruption I covered a list of best practices for responding to database corruption when it happens. In that post I ...

Azure Trust Services

Microsoft recently launched Trust Services for Windows Azure, an application-level encryption framework that can be used to protect sensitive data stored on the Windows Azure ...


advertisement

Featured Event

More Events