April « 2011 « SQL Server Journey with SQL Authority

Archive for April, 2011

SQL SERVER – CTAS – Create Table As SELECT – What is CTAS?

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on April 30, 2011 | 10 Comments »

I have been working with the database for many years and I am aware of many common terminologies. Recently I was attending training myself and the instructor used the word ‘CTAS’ in the class. One of the attendees did not know the definition of this abbreviation. From this, I realized that not all of us [...]

Read Full Post »

SQL SERVER – Denali – Executing Stored Procedure with Result Sets

Posted in PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on April 29, 2011 | Comments Off

After reading my earlier article SQL SERVER – Denali – Executing Stored Procedure with Result Sets, one of the readers asked if this new feature (syntax) support multiple resultset of the stored procedure? Very interesting question indeed as most of the stored procedures that I usually come across have more than one resultset. I quickly look [...]

Read Full Post »

SQL SERVER – Denali – Executing Stored Procedure with Result Sets

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, T SQL, Technology on April 28, 2011 | 12 Comments »

Here is a normal conversation I heard when I saw that the function (UDF) was used instead of the procedure (SP). Q: Why are you using User Defined Function instead of Stored Procedure? A: I cannot SELECT from SP, but I can from UDF. SQL Server’s next version ‘Denali’ is coming up with a very [...]

Read Full Post »

SQL SERVER – Introduction to SQL Azure – Creating Database and Connecting Database

Posted in PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on April 27, 2011 | 7 Comments »

I recently logged into new Azure Portal and I really think the product team has done excellent job to make it user-friendly and self intuitive. Here are the quick steps I have done after I logged into the portal here: https://windows.azure.com/ Purchased subscription Created Server Created Database Connect using Database Honestly it is that simple. [...]

Read Full Post »

SQLAuthority News – Pluralsight On-Demand FREE for SQL Server Course

Posted in Best Practices, Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Training, SQLAuthority News, SQLServer, T SQL, Technology on April 26, 2011 | 16 Comments »

The Moral of Story You can watch the most popular SQL Server – TSQL course on Pluralsight On-Demand for FREE for the next 48 hours. It starts NOW! The Story Learning is always difficult. After learning how to apply your knowledge, learning in real life is even more difficult. Technology is moving faster than the [...]

Read Full Post »

Older Posts »