Determining Database Size in Azure SQL Database V12

A question that is frequently asked by customers using Azure SQL Database is “How can I determine the size of my database programmatically?” Interestingly, different people may be talking about different things when asking this question. Is it the size of all database files on disk? Is it the size of just the data files?… Read more

Real-World Azure SQL DB: Unexpected Database Maximum Size Limit

Reviewed by: Kun Cheng, Sanjay Mishra, Denzil Ribeiro, Arvind Shyamsundar, Mike Weiner, and Murshed Zaman The Problem: A Production Outage A customer using Azure SQL Database recently brought an interesting problem to our attention. Unexpectedly, their production workload started failing with the following error message: “The database ‘ProdDb’ has reached its size quota. Partition or… Read more

SQLCAT @PASS Summit 2015

Are you coming to the PASS Summit 2015 in Seattle? SQLCAT will be in full force at the PASS Summit 2015. We will also bring along our colleagues from the broader AzureCAT. SQLCAT Sessions SQLCAT sessions are unique. We bring in real customer stories and present their deployments, architectures, challenges and lessoned learned. This year… Read more

Be aware of the difference in isolation levels if porting an application from Windows Azure SQL DB to SQL Server in Windows Azure Virtual Machine

[One more post recovered from archives.]   Author: Sanjay Mishra, Tim Wieman Technical Reviewers: Mike Weiner, Shep Sheppard, Prem Mehra, Chuck Heinzelman, James Podgorski, Silvano Coriani, Madhan Arumugam Ramakrishnan, Sunil Agarwal, Guy Bowerman   Windows Azure SQL Database and SQL Server in Windows Azure Virtual Machine are two different data storage options and are best… Read more

SQLCAT.Com – eBook Downloads

As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to post new SQL Server content. This was done to minimize reader confusion and to streamline content publication.  MSDN SQLCAT blogs already includes most SQLCAT.COM Content and will continue to be updated with more SQLCAT learnings.  You can also… Read more

Linked Servers to SQL Azure

Authors:  Kevin Cox & Michael Thomassy Contributors: Lubor Kollar Technical Reviewers: Shaun Tinline-Jones, Chuck Heinzelman, Steve Howard, Kun Cheng, Jimmy May Overview   Connecting directly to a SQL Azure database from a reporting tool (like Microsoft Excel and PowerPivot, or SQL Server Reporting Services) from your desktop or local data center is possible using a… Read more

New Release of SQL Server Migration Assistant (SSMA) includes migration from MySQL and to SQL Azure

Wanted to let the community know the SQL Server Product Group just released version 4.2 of the SQL Server Migration Assistant!  With this version, Microsoft has announced the release of the first version of SQL Server Migration Assistant (SSMA) for MySQL!   Microsoft refreshed the existing SSMA family of products for Oracle, Sybase and Access. Brand new… Read more

SQL Azure Customer Best Practices

The SQLCAT team and the SQL Azure team have been working closely together with a number of customers even before we launched our CTP (Community Technology Preview) in November, 2009 at the PDC (Professional Developers Conference).  After our production release in January, 2010, we’ve continued working with some interesting customers and have captured a number… Read more