SQL Archives - Page 388 of 519 - SQL Authority with Pinal Dave

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

September 5, 2009

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…

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

September 4, 2009

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…

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

September 3, 2009

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…

SQL SERVER – Download Script of Change Data Capture (CDC)

September 1, 2009

Pinal Dave

SQL

Best Practices, CDC, Change Data Capture, SQL Download, SQL Server

My article written on subject of Introduction to Change Data Capture (CDC) in SQL Server 2008 is quite a popular and I have received many request for uploading the script associated with this subject.

SQLAuthority News – Baby SQLAuthority is here!

September 1, 2009

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

September 1st, 2009 07:03:40 AM was one of the most beautiful moment of my life! God has graced us with baby girl. Nupur (my wife) and I am very happy today. We have no words to express our happiness. Baby girl and mother both are very healthy. We have yet…

SQLAuthority News – Effect of Oracle acquiring MySQL – A Delayed Analysis

August 31, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, MySQL, Software Development

On 20 April 2009, Oracle Corporation announced its acquisition of Sun Microsystems in a deal worth about US$ 6 billion. This would have been just another one of corporate mega-deals that sound interesting in the news but really have no effect on your life. Except for the fact that with…

SQLAuthority News – Application and Multi-Server Management

August 30, 2009

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…