Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
All Articles career-gaps-resume-600x400

SQL SERVER – Find Gaps in The Sequence

Pinal Dave
SQL Tips and Tricks
SQL Identity, SQL Scripts, SQL Server

I have previously written two articles on the subject of missing identity and both are very well received by community. I had great fun to write article as many SQL Server expert participated in both the articles. Expert Imran Mohammed had provided excellent script to find missing identity. Please read both the articles for additional information before reading this article about finding gaps in the sequence.

Read More

SQL SERVER – FIX – ERROR : Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Replication, SQL Scripts
I have set up replication at many different organization. One error I quite commonly face is after I have removed replication I can not remove database. When I try to remove the database it gives me following error. Cannot drop the database because it is being used for replication. (Microsoft…
Read More

SQL SERVER – Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Business Intelligence, SQL Documentation, SQL Download, SQL White Papers, SQLAuthority Author Visit
In my recent Business Intelligence Training Roadshow August September 2009 I quite often get request to provide more details about Analysis Service Cubes for Excel 2007 PivotTable. Here is the white paper on the same subject. Microsoft Office Excel 2007 takes advantage of most of the features in Microsoft SQL…
Read More

SQL SERVER – What is Data Mining – A Simple Introductory Note

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Business Intelligence, Data Warehousing
According to MacLennan et al. (2009), data mining is defined as “the process of analyzing data to find hidden patterns using automatic methodologies.” Consider the following simple example that explains this concept. By analyzing the data on the items purchased from a supermarket or a chain of such stores, information…
Read More
All Articles sql-mirrored-backup2

SQL SERVER – Mirrored Backup and Restore and Split File Backup – Introduction

Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Data Storage, SQL Restore, SQL Scripts, SQL Server

Introduction – Mirrored Backup

This article is based on a real life experience of the author while working with database backup and restore during his consultancy work for various organizations. We will go over the following important concepts of database backup and restore.

Conventional Backup and Restore
Spilt File Backup and Restore
Mirror File Backup
Understanding FORMAT Clause
Miscellaneous details about Backup and Restore

Read More

SQLAuthority News – Application and Multi-Server Management

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Business Intelligence, Data Warehousing, SQL Documentation, SQL Download, SQL White Papers
SQL Server 2008 R2 – Application and Multi-Server Management SQL Server Technical Article Title: SQL Server 2008 R2Application and Multi-Server Management Introduction Writers: Geoff Allix Technical Reviewers: Joanne Hodgins, Omri Bahat, Morgan Oslake Published: February 2010 SQL Server 2008 R2 introduces new management tools to help improve IT efficiency and…
Read More