A Microsoft SQL Server community of 1,785,893 DBAs, developers and SQL Server users

How do you make data available to analysts who want to blend data with R or Power Query tools? Why with OData services.  Read more...

One of the most important SQL Server DBA tasks is checking logical hard drive details such as the total capacity, free disk space, and used space by the SQL Server data and log files. In this tip we look at a method to view this information in a faster and simpler way.  Read more...

Learn how to do SQL Server continuous integration at the first in a new series of Database Lifecycle Management Training Workshops, in Silicon Valley on March 27. To celebrate the launch, places for this workshop are free.   Read more...

We frequently need to discover the source of issues with our databases. This article provides information on how to detect replication on a database as a possible source of issues.  Read more...

How often do you check your query plans to see if they contain any warnings? If you're missing them, it means that you're not getting all those hints about missing indexes, join predicates or statistics. Is the query optimiser trying to tell you about implicit conversions? Dennes shows how to view the warnings in plan cache for a particular database using SQL.  Read more...

This article shows how to find missing rows in a table using a outer join.   Read more...

The options that you need to select when setting up an Azure Storage service account allow you to specify the durability and high-availability of your data, but they don't provide for data recovery to a point-in-time. In fact, it means that some of the bad things that can happen to data are more efficiently replicated to all copies. Backup is quite a separate issue.  Read more...

SQL Saturday is coming to Richmond on March 21, 2015. Join us for a free day of SQL Server training and networking. There are also paid-for pre-con sessions available from Tim Mitchell and Kevin Kline. Register while space is available.  Read more...

An article about how we underestimate the power of joins and degrade our query performance by not using proper joins  Read more...

Most large organizations have implemented one or more big data applications. As more data accumulates internal users and analysts execute more reports and forecasts, which leads to additional queries and analysis, and more reporting. The cycle continues: data growth leads to better analysis, which generates more reporting. Eventually the big data application swells with so much data and querying that performance suffers.   Read more...

All the system-level configuration settings and login account information of SQL server are stored in the corresponding SQL Master Database...  Read more...

T-SQL EXCEPT and INTERSECT Both T-SQL EXCEPT and INTERSECT are set based operators that combine multiple query results back in the same...  Read more...