Feeds:
Posts
Comments

Archive for the ‘SQL Azure’ Category

SQL SERVER – Azure Interview Questions and Answers – Guest Post by Paras Doshi – Day 25 of 31

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Azure, SQL Interview Questions and Answers, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on July 25, 2011 | 10 Comments »

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Please read the Introductory Post before continue reading interview question and answers. Paras Doshi is known SQL Azure Expert has written following guest blog post to keep alive the spirit of Interview Questions and Answers Series. I encourage all the readers [...]

Read Full Post »

SQL SERVER – Extending SQL Azure with Azure worker role – Guest Post by Paras Doshi

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Azure, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on June 13, 2011 | 8 Comments »

This is guest post by Paras Doshi. Paras Doshi is a research Intern at SolidQ.com and a Microsoft student partner. He is currently working in the domain of SQL Azure. SQL Azure is nothing but a SQL server in the cloud. SQL Azure provides benefits such as on demand rapid provisioning, cost-effective scalability, high availability [...]

Read Full Post »

SQL Azure – SQL Azure Throttling and Decoding Reason Codes

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Azure, SQL Puzzle, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on May 29, 2011 | 3 Comments »

I was recently reading on the subject SQL Azure Throttling and Decoding Reason Codes and end up reading the article over here. What I really liked is the explanation of the subject with Graphic. I have never seen any better explanation of this subject. I really liked this diagram. However, based on reason code one [...]

Read Full Post »

SQL SERVER – A Quick Notes on SQL Azure

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Azure, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on May 28, 2011 | 4 Comments »

I was recently attending a small meeting where I was asked if I can share few things to be considered when designing SQL Azure database. Today I am sharing the same notes over here. Disclaimer: This is no way a complete guide – this is some notes which are compiled in short meeting. SQL Azure [...]

Read Full Post »

SQL SERVER – Copy Database from Instance to Another Instance – Copy Paste in SQL Server

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Azure, SQL Backup and Restore, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on May 27, 2011 | 19 Comments »

SQL Server has feature which copy database from one database to another database and it can be automated as well using SSIS. Make sure you have SQL Server Agent Turned on as this feature will create a job. The same job will execute the task. Make sure that SSIS is properly configured as well with [...]

Read Full Post »

Older Posts »