September « 2009 « SQL Server Journey with SQL Authority

Archive for September, 2009

SQL SERVER – SQL Server Desktop Screen Background

Posted in Pinal Dave, SQL, SQL Add-On, SQL Authority, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Website Review, SQLServer, T SQL, Technology on September 10, 2009 | 1 Comment »

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 regular reader of his blog. Few of the other interesting posts written by him [...]

Read Full Post »

SQL SERVER – Difference between SQL Server Express and MySQL

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology, tagged MySQL on September 9, 2009 | 14 Comments »

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. SQL Server Express is a freely-available small-brother version of Microsoft’s enterprise system, SQL Server. It is the successor to [...]

Read Full Post »

SQLAuthority News – Shaivi Dave – Baby SQLAuthority

Posted in About Me, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on September 8, 2009 | 27 Comments »

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. Thank you all for all the wonderful suggestions for the baby name. Selecting the right name for little one is really one of the [...]

Read Full Post »

SQL SERVER – Importance of Database Schemas in SQL Server

Posted in Pinal Dave, SQL, SQL Authority, SQL Documentation, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged Schema on September 7, 2009 | 20 Comments »

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 separate. This concept of separation [...]

Read Full Post »

SQL SERVER – Find Gaps in The Sequence

Posted in Pinal Dave, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged Identity on September 6, 2009 | 7 Comments »

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 [...]

Read Full Post »

« Newer Posts - Older Posts »