Both SQL Server express and MySQL are two of the Relational Database Systems (RDBMS) available today. Both are freely available and meant for running smaller or embedded databases, yet there are also significant differences between them.
SQLAuthority News – Shaivi Dave – Baby SQLAuthority
Six days ago, on September 1st, 2009 07:03:40 AM, God blessed us with beautiful baby girl. As per Hindu Namkaran Sanskar (naming ritual), we have decided to name her as Shaivi Dave. Thank you all for all the wonderful suggestions for the baby name. Selecting the right name for the little one is really one of the most challenging tasks. According to Vedas, in Hindu religion, each occasion of a person’s life calls for elaborate rituals. After the birth of a child, naming ceremony or the Namkaran Samskar is considered one of the most important events.
SQL SERVER – Importance of Database Schemas in SQL Server
Beginning with SQL Server 2005, Microsoft introduced the concept of database schemas. A schema is now an independent entity- a container of objects distinct from the user who created those objects. Previously, the terms ‘user’ and ‘database object owner’ meant one and the same thing, but now the two are…
Read More
SQL SERVER – Find Gaps in The Sequence
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.
SQL SERVER – FIX – ERROR : Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)
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 MoreSQL SERVER – Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
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 MoreSQL SERVER – What is Data Mining – A Simple Introductory Note
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
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
SQL SERVER – Download Script of Change Data Capture (CDC)
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 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…
Read More