SQL Server Articles


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

Automate Audit Requests

User Review Periodically, an internal auditor would stop by my desk and ask me to show them all the users and permissions on a particular database.  This is easily gathered, and most of us know how to do this.  I produce this list, and send it on to the requestor.  The next question is ‘What […]

Notifications for SQL Server Agent Restarts

Introduction In this article we will set up an email notification at the SQL Server level whenever SQL Server and the SQL Server Agent Restarts. The article will   useful for DBA’s who support a large number of database servers which they cannot manually connect to   daily to check the SQL Server status, SQL job status […]

Data Mining Cluster Analysis in SQL Server

Grouping is something we naturally do in our day to day life. We group foods depending on taste, we group friends depending on their different attributes.  Clustering is an algorithm which finds natural groupings inside your data when these groupings are not obvious. It finds the hidden variable that accurately classifies your data. How Clustering […]

Report SQL Server Percentage Backup Completion and Time Completion

When executing a backup from a t-sql command, it is difficult to know what percentage has completed and when the backup will be complete. When you are taking a backup, you can specified STATS = 10 like following. BACKUP DATABASE [AdventureWorks2012] TO DISK = N’D:\MYBackup\AdventureWorks2012.bak’ WITH NOFORMAT, NOINIT, NAME = N’AdventureWorks2012-Full Database Backup’, SKIP, NOREWIND, […]

Controlling Growth of a Distribution Database

I was recently asked to set up Transactional Replication comprising of 29 publishers as well as same number of subscribers. One interesting challenge was that the size of the distribution database suddenly increased from few MB’s to around 62 GB and as a result the disk on which the production database was hosted quickly filled […]

Creating A Financial Year Dimension Using SSAS

A common requirement of financial reports is to have a financial year dimension for analysing the fiscal year data. This is complicated by the fact that financial years differs from country to country. Creating A Fiscal Year Using SSAS Dimension Wizard The financial year can be implemented easily using the SSAS dimension wizard. Let us […]

Copy Only Backups for Adhoc Backups

Introduction In most organizations backup plans are implemented using full differential and transactional log backups. The normal scenario would be take a full backup on Sunday (off peak hours), differential backup daily at mid-night and transactional log backups on hourly basis. What if there is a requirement to refresh on the test/development environment with production […]

Refresh the Staging Server with Production Data – A Real World Scenario.

Recently I had to restore the Production Reporting Database Server onto our Staging environment for testing. This database was around 280 GB in size with around 120 GB of data in the Primary Data File (.mdf), 130 GB of data in the Secondary Data File (.ndf) and around 30 GB of Transactional Log File (.ldf). […]

Implementing Transactions in SQL Server – Part II

In Implementing Transactions Part I I briefly described the role of Transactions in SQL Server and outlined a very basic implementation. In this second part, I will explain how a DBA can best implement Transactions in scripts that are to be deployed on production databases. One of the regular tasks of a DBA is to […]

SSAS Deployment Strategies

Introduction Building a data warehouse and then a cube based on the data warehouse has become child’s play, thanks to Microsoft’s business intelligence tools. SQL Server Analysis Service is used to build cubes for slicing and dicing data. After the cube has been built we need to deploy it to the SSAS server in order […]

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |