Buck Woody (MSFT) has published a blog post about SQL Server Desktop Screen Background. I really like the SQL Server Desktop background and I have replaced that background on my work laptop. I came across this particular post because I am a regular reader of his blog. Few of the other interesting posts written by him are following.
SQL SERVER – Difference between SQL Server Express and MySQL
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 More