July « 2009 « SQL Server Journey with SQL Authority

Archive for July, 2009

SQL SERVER – Introduction to Cloud Computing

Posted in Pinal Dave, Software Development, SQL, SQL Authority, SQL Documentation, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged Cloud Computing on July 31, 2009 | 15 Comments »

Introduction “Cloud Computing,” to put it simply, means “Internet Computing.” The Internet is commonly visualized as clouds; hence the term “cloud computing” for computation done through the Internet. With Cloud Computing users can access database resources via the Internet from anywhere, for as long as they need, without worrying about any maintenance or management of [...]

Read Full Post »

SQLAuthority News – Author’s Birthday – Top 7 Commenters – Volunteers

Posted in About Me, Database, DBA, Pinal Dave, Readers Contribution, Readers Question, Software Development, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on July 30, 2009 | 36 Comments »

Today is July 30 and I am very happy; it’s my Birthday, celebration time!!! The most common question I receive on my every birthday is -what are my plans for birthday. Let me share my plans here today. Additionally, if you are interested to know when SQL Server was born read my post SQLAuthority News [...]

Read Full Post »

SQL SERVER – 2008 – Copy Database With Data – Generate T-SQL For Inserting Data From One Table to Another Table

Posted in Best Practices, Database, DBA, Pinal Dave, Readers Question, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology on July 29, 2009 | 100 Comments »

Just about a year ago, I had written on the subject of how to insert data from one table to another table without generating any script or using wizard in my article SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE. Today, we will go [...]

Read Full Post »

SQL SERVER – 2008 – Design Process Decision Flow

Posted in Pinal Dave, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLServer, T SQL, Technology on July 28, 2009 | 7 Comments »

I was recently invited by a company that is primarily using other RDBMS as their primary database for solutions. It was a different experience for me, as I am used to having pretty good SQL Server Smart crowd in my presentations, but this time there were smart people but no SQL Server experts in front [...]

Read Full Post »

SQL SERVER – List All Missing Identity Values of Table in Database

Posted in Pinal Dave, Readers Contribution, SQL, SQL Authority, SQL Function, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, T SQL, Technology, tagged Identity on July 27, 2009 | 37 Comments »

The best part of any blog is when readers ask each other questions. Better still, is when a reader takes the time to provide a detailed response. A few days ago, one of my readers, Yasmin, asked a very interesting question: How we can find the list of tables whose identity was missed (not is [...]

Read Full Post »

Older Posts »