Let us learn about XML Document in TSQL using XSD by Jacob Sebastian.
SQLAuthority News – A Daily Doze of Technology – Alvin Ashcraft’s Morning Dew
A common question that I receive is regarding how I keep myself updated with latest information about technology and what is going on at present. I read lots of blogs and books. I am usually traveling 4 days in my any regular work week. I read physical books at the…
Read MoreSQL SERVER – Size of Index Table for Each Index – Solution
Earlier I have posted small question on this blog and requested help from readers to participate here and provide solution. Please read the original Puzzle here. SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table The puzzle was to write…
Read MoreSQL SERVER – Azure Start Guide – Step by Step Installation Guide
As SQL Azure CTP is released I have included here step by step guide for how to configure the CTP. For pricing and introduction please read SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing First it has to be configured online at Login using…
Read MoreSQLAuthority News – SQL Server R2 Resources Downloads, Documentations
Microsoft SQL Server 2008 R2 November Community Technology Preview Building on SQL Server 2008, R2 provides an even more scalable data platform with comprehensive tools for managing your databases and applications, improving the quality of your data, and empowering your users to build rich analyses and reports using tools they…
Read MoreSQLAuthority News – Subscribe to Blog – Search a Blog
Quite often I get request if I send blog post in newsletter or through email. Here are few important links. You can for sure get email of my post, however, I strongly suggest to visit blog as if there are any updates in my post they are reflected on blog.…
Read MoreSQLAuthority News – SQL Server 2008 Analysis Services Performance Guide
Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white paper organizes performance tuning techniques into the following three segments. Enhancing Query Performance – Query performance directly impacts the quality of the end user experience. As such, it is the primary benchmark…
Read More