SQL Server Articles

SQL Server implements three different physical operators to perform joins. In this article series we will examine  how each  operators works, its advantages and challenges. We will try to understand the logic behind the optimizer’s decisions on which operator to use for various joins using (semi) real life examples and how to avoid common pitfalls. [...]

xx

What is Default Trace? A default trace in SQL Server is a standard server side trace which is installed by default in SQL Server 2005 onwards. As BOL states: “Default trace provides troubleshooting assistance to database administrators by ensuring that they have the log data necessary to diagnose problems the first time they occur.” Thus [...]

In most companies, roles and responsibilities are clearly defined for the various teams, whether it is the database team, application team or the development team. In some cases, the application team might own a number of jobs but they may not have direct access or the high level privileges required to run it on the [...]

This article leverages the examples and concepts explained in the third part of this spatial data series which develops a “BI-Satellite” app ( Reporting spatial data with SSRS 2008 R2 and Reports Builder 3.0 Part-III ) Overview: In the previous part of this article series, we saw how we can report spatial data on a [...]

Overview Development of any analytical solution normally ends with a form of  report, whether it is a normal tabular report or a sophisticated interactive dashboard.   In the first part of our BI-Satellite project, we devised a way to geocode location based spatial data using SSIS and Bing Maps. Thereafter in the next part we plotted [...]

This article leverages the examples and concepts explained in the first part of this spatial data series which develops a “BI-Satellite” app ( Geocoding Text-Based Spatial Data for Use In SSIS Packages Part-I ) Overview Text based location information is the starting point for spatial data analysis, but this information is generally not directly consumable [...]

xx

Introduction Restoring any database is a critical task which will be  complicated by the database to be  restored being a publisher database. For the purposes of this article, I will assume familiarity with the different types of replication and their features. All   examples in this article  are with respect to transactional replication. Let us consider [...]

xxx