http://www.sqlshare.comAndrew Novick is a SQL Server consultant building business solutions with the Microsoft tools. His expertise in database design, T-SQL coding, SQL Server security, database performance tuning, and database partitioning can be a valuable asset to many projects. Andrew Novick also offers training and mentoring services to relevant projects. His writing on computing can be seen at his web site http://www.NovickSoftware.com and many videos can be seen here on JumpStart TV1440http://www.sqlshare.com/SQLAzurePricingandBilling_785.aspxhttp://www.sqlshare.com/SQLAzurePricingandBilling_785.aspxSQL Azure isn't just a database in the cloud, it's database services billed as a utility, and that means you're going to get a bill each month. Andy does a great job of explaining the basics of pricing and also shows you how to monitor your usage on a day to day basis, good way to avoid end of month billing surprises!Mon, 28 Jun 2010 00:00:00 ESThttp://www.sqlshare.com/FirewallConfigurationforSQLAzure_777.aspxhttp://www.sqlshare.com/FirewallConfigurationforSQLAzure_777.aspxOnce you've set up a SQL Azure server you're all ready to go, right? Not quite. You've got to decide what IP addresses can connect to it. Not hard, but maybe not expected either for those of us used to working within a corporate zone where such things are already handled. Luckily it's not hard to do as you'll see in this great demo!Sun, 13 Jun 2010 00:00:00 ESThttp://www.sqlshare.com/SQLAzureAddingandDroppingDatabases_781.aspxhttp://www.sqlshare.com/SQLAzureAddingandDroppingDatabases_781.aspxIts funny how even the smallest video can yield some unexpected learning. CREATE and DROP work pretty much as expected, but did you know that there is a db_manager role you can assign users to if you need to delegate those tasks? Or that if you create a database and drop it, you still get charged for one day?Sun, 13 Jun 2010 00:00:00 ESThttp://www.sqlshare.com/ConnectingtoSQLAzureUsingVariousTools_782.aspxhttp://www.sqlshare.com/ConnectingtoSQLAzureUsingVariousTools_782.aspxSo far we've built a database on Azure and set the firewall rules, how you manage it remotely? Andy demonstrates connecting using SQL 2008 R2 Management Studio and SQLCmd, then changes to Visual Studio 2010 and shows how that works as well. Note the use of SQLCmd - little trick there in the user name, and while the password can be specified in the command line, Andy did not so that he could enter the password with you seeing it!Sun, 13 Jun 2010 00:00:00 ESThttp://www.sqlshare.com/QueryDifferencesinSQLAzure_783.aspxhttp://www.sqlshare.com/QueryDifferencesinSQLAzure_783.aspxDid you know that you can use USE? Or that SELECT INTO doesn't work? There are some definite differences between what we can do in the 'standard' SQL Server and what we can do in Azure. Nothing that can keeps us from getting work done, but seeing them here will reduce the learning curve and frustration level when you launch your first Azure project!Sun, 13 Jun 2010 00:00:00 ESThttp://www.sqlshare.com/IntroductiontoSQLAzure_764.aspxhttp://www.sqlshare.com/IntroductiontoSQLAzure_764.aspxThe first step in working with SQL Azure is to set up an account and provision a server. It only take a couple of minutes and when you're done you'll have a server name and a full fledged DNS path to it as well. We'll have more on this topic soon!Mon, 17 May 2010 00:00:00 ESThttp://www.sqlshare.com/using-computed-columns-in-udfs_600.aspxhttp://www.sqlshare.com/using-computed-columns-in-udfs_600.aspxComputed columns are a way to add virtual columns to a table and can be a powerful technique (when used appropriately). In this video function wizard Andy Novick shows you how to go beyond simple expressions in a computed column by using a user defined function as part of the definition. Worth watching!Wed, 28 Jan 2009 00:00:00 ESThttp://www.sqlshare.com/error-handling-with-udfs_601.aspxhttp://www.sqlshare.com/error-handling-with-udfs_601.aspxUser defined functions have some limitations and quirks when it comes to error handling, and in ways you might not expect! Andy Novick has put together a great illustration of the differences in error handling between stored procedures and user defined functions.Wed, 28 Jan 2009 00:00:00 ESThttp://www.sqlshare.com/inline-udfs-in-sql-server_602.aspxhttp://www.sqlshare.com/inline-udfs-in-sql-server_602.aspxView or function, which should you use? Inline user defined functions are definitely interesting easy to learn how to use. Join Andy Novick for the quick intro that will have you creating these functions in no time at all!Wed, 28 Jan 2009 00:00:00 ESThttp://www.sqlshare.com/multistatement-udfs-in-sql-server_603.aspxhttp://www.sqlshare.com/multistatement-udfs-in-sql-server_603.aspxMultistatement user defined functions are an interesting way to package and reuse code. This video by well known author Andy Novick shows you what multistatement user defined functions are and how to create them in your SQL Server database. Worth watching!Wed, 28 Jan 2009 00:00:00 ESThttp://www.sqlshare.com/scalar-udf-parameters-explained_604.aspxhttp://www.sqlshare.com/scalar-udf-parameters-explained_604.aspxIn this video Andy explain how parameters are called "by value" in user defined functions.Wed, 28 Jan 2009 00:00:00 ESThttp://www.sqlshare.com/data-access-with-scalar-udfs_605.aspxhttp://www.sqlshare.com/data-access-with-scalar-udfs_605.aspxThis video shows you how to use data access inside of a scalar user defined function Wed, 28 Jan 2009 00:00:00 ESThttp://www.sqlshare.com/what-is-a-scalar-udf_606.aspxhttp://www.sqlshare.com/what-is-a-scalar-udf_606.aspxSQL Server allows us to create several different types of user defined functions to let us reuse code. Andy Novick explains what a scalar UDF is and provides some great examples of how to create and use them.Wed, 28 Jan 2009 00:00:00 ESThttp://www.sqlshare.com/sql-server-system-function_607.aspxhttp://www.sqlshare.com/sql-server-system-function_607.aspxThis video introduces some of the system functions like fn_virtualfilestats and fn_listextendedproperty. Some of these have been replaced by system tables in SQL 2005 and later, but you can still use them and they may already be in use in code you own!Wed, 28 Jan 2009 00:00:00 ESThttp://www.sqlshare.com/user-defined-functions-metadata_608.aspxhttp://www.sqlshare.com/user-defined-functions-metadata_608.aspxThis video shows you how to use the metadata for user defined functions in SQL Server.Wed, 28 Jan 2009 00:00:00 ESThttp://www.sqlshare.com/user-defined-function-tips_609.aspxhttp://www.sqlshare.com/user-defined-function-tips_609.aspxThis video gives you some information about how to structure UDF's, naming UDF's and the proper way to use comments in UDF's - all great tips from Andy Novick, the SQL function man!Wed, 28 Jan 2009 00:00:00 ESThttp://www.sqlshare.com/testing-udfs_610.aspxhttp://www.sqlshare.com/testing-udfs_610.aspxDBA's tend to think of testing as something done by testers! In this video Andy Novick discusses why he writes simple tests for all his user defined functions and gives you a view into why those tests are useful both now and later.Wed, 28 Jan 2009 00:00:00 ESThttp://www.sqlshare.com/you-cant-do-that-with-udfs_611.aspxhttp://www.sqlshare.com/you-cant-do-that-with-udfs_611.aspxUser defined functions are useful, but sometimes promise more than they can deliver. Just like Clint, a UDF has to know it's limitations, and so do you. Andy Novick does a great job of showing you live the limitations of user defined functions (and visit his profile to see many other great function focused videos).Wed, 28 Jan 2009 00:00:00 EST