SQL Server Articles

Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET

Reporting Services 2008 R2: Geospatial Visualization – Part I

Geospatial Visualization is one of the key new features of SQL Server 2008 R2 Reporting Services.SQL Server provided geospatial data with SQL Server 2008 and you may have noticed (or perhaps used) the two geospatial data types in SQL Server 2008 : geometry and geography. This support is further extended with Reporting Services 2008 R2 […]

Migrating to Windows Server 2008 R2


Using SQL Server Default Trace

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 […]

Running SQL Server Jobs using a Proxy Account

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 […]

Working with Spatial Data Part IV – Developing a Geospatial Dashboard (GIS)

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 […]

Working with Spatial Data Part III – Reporting Spatial data using Reports Builder 3.0

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 […]

Working with Spatial Data Part II – Plotting Shapes and Storing Geocoded Data

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 […]

Getting Started with PowerShell for SQL Server


Restoring a Publisher Database in SQL Server

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 […]