SQL Server Articles
Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET
ASP.NET Hosting Guide
Detailed guide to shared, VPS and dedicated hosting.
Backup and Restore of an Analysis Services Database
Introduction One of the most important responsibilities of a database administrator is to make sure that all the databases are backed up across environments managed by them. In my earlier article titled Importance of Database Backups and Recovery Plan I discussed the importance of a good database backup and recovery plan for all the user [...]
Exchange Server Performance – Optimizing Database Availability Groups (DAG)
Under a DAG configuration, mailbox data is replicated across several hosts. The result of this is that in Exchange Server 2010 it is now less important to build in system level redundancy. If a DAG node fails, as opposed to rebuilding it, we can simply build a node, add it as a replica, the data will replicate to it.
Using DML Triggers to Capture Multiple Events
AS DBAs we often need to develop DML triggers to capture multiple entries which are either INSERTED, UPDATED or DELETED from a table. A few months back, I came across a situation where the Application Development Team asked me to write a logic to notify the DBA if any records were either INSERTED,UPDATED or DELETED [...]
Reporting Services 2008 R2: Geospatial Visualization – Part II
This is the continuation of my previous article: Reporting Services 2008 R2: Geospatial Visualization – Part I. Part I discussed the main characteristics related to the Map Report Item, Data sources for spatial data, how to create a map report using shapefiles, and finally add analytical data to it. Our goal in the part is [...]
Optimizing Performance of SQL Server Reports
There is not much the report writer can do to speed things up, compared to the DBAs and the people buying the hardware. Nevertheless, I wanted to share some ideas that may or may not work in your situation. Use indexes in your database When writing stored procedures, I prefer to keep my query as [...]
Know your Data with Data Profiling
Introduction According to the “Data Quality and the Bottom Line: Achieving Business Success through a Commitment to High Quality Data.” The Data Warehousing Institute. Report Series 2002, data quality problems cost U.S. businesses more than $600 billion per year. Why such a cost? If your data is not up to quality, your KPIs and data [...]