June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

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

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