Whitepaper editing

Hi Folks,

I posted a day or so back about the whitepaper on plan caching and recompilation being published.

Today I had a query from a reader and found that the editor has messed up an example.

For example, I had this example of a query that's almost identical but where the query plan would be different:

SELECT ProductID
FROM Sales.SalesOrderDetail
GROUP BY ProductID
HAVING AVG(OrderQty) > 5
ORDER BY ProductID;

SELECT productid
FROM Sales.SalesOrderDetail
GROUP BY ProductID
HAVING AVG(OrderQty) > 5
ORDER BY ProductId;

"Helpfully" the editor changed it to:

SELECT ProductID
FROM Sales.SalesOrderDetail
GROUP BY ProductID
HAVING AVG(OrderQty) > 5
ORDER BY ProductID;

SELECT ProductID
FROM Sales.SalesOrderDetail
GROUP BY ProductID
HAVING AVG(OrderQty) > 5
ORDER BY ProductID;

And undid the point of the example…

Whitepaper: Plan Caching and Recompilations in SQL Server 2012

Hi Folks,

Over the last year, I've been working on an update to the whitepaper Plan Caching in SQL Server 2008 as a background task.

A great group of reviewers have been involved at various stages during the process. Thank you to Paul White, Andrew Kelly, Kalen Delaney, and Rubén Garrigós from the SQL community, along with Leigh Stewart and Jack Li from the SQL Server product team for sharing your knowledge and ideas.

Gail Erikson from the SQL documentation team let me know today that the latest version Plan Caching and Recompilation in SQL Server 2012 is now available:

http://msdn.microsoft.com/en-us/library/dn148262.aspx

Enjoy!

 

SQL Down Under – Show 57 – Karen López – Data Modelling, Database Refactoring, Space Data, and Open Data

Hi Folks,

I got to record another podcast today. Show 57 features guest SQL Server MVP Karen López. Karen is well-known in the SQL Community, on her blog and is prolific on Twitter.

In the show, Karen discusses her experiences related to data modelling, including tools, round-tripping, traceability, and model-driven development. She also covers some common mistakes she encounters in this area. Later in the show Karen discusses the challenges in database refactoring, her interest in all things to do with space, and her interest in the open data movement.

The show is now available: http://www.sqldownunder.com/Resources/Podcast.aspx

Enjoy!

SQL Server BI Tooling now in Visual Studio 2012 Shell

This is really exciting. One of the complaints from those using the BI tools (SQL Server Data Tools) has been that they were tied to the Visual Studio 2010 shell, when the rest of their development work had moved to Visual Studio 2012.

The SQL Server BI team has now released the VS2012 versions of these project templates. You'll find details the download here:

http://www.microsoft.com/en-us/download/details.aspx?id=36843

The Reporting Services team blog about it is here:

http://blogs.msdn.com/b/sqlrsteamblog/archive/2013/03/06/sql-server-data-tools-business-intelligence-for-visual-studio-2012-released-online.aspx 

And the Analysis Services team blog about it is here:

http://blogs.msdn.com/b/analysisservices/archive/2013/03/06/sql-server-data-tools-business-intelligence-for-visual-studio-2012-released-online.aspx 

One nice aspect that I've found is that I have been able to open BI projects in VS2010 again, even after editing them in VS2012. I wasn't expecting that to be possible so it must mean that the project format hasn't changed.

One hint on installation though:

Make sure you choose the "New Instance" option (strange as that might seem). Otherwise, you'll get an error that says the following:

Rule "Same architecture installation" failed.

Enjoy!

Windows Azure SQL Reporting – now configurable in the new portal

Scott Guthrie blogged yesterday about a raft of new changes to the Azure platform.

Of interest to SQL folk are really three main changes:

* SQL Reporting has made its way into the new portal (ie: you no longer have to flip back to the old portal to work with it. Hopefully Data Sync will do the same soon).

* Better options now exist for downloading blobs from Azure Storage. (This could include, for example, SQL Server backups made using BACKUP TO URL).

* New tools for monitoring the usage and availability of VMs.

For others, it's good to see that you can now upload .cer certificate files, not just .pfx certificate files when working with cloud services, and also interesting to see Android support added to mobile services.

You'll find Scott's post here: http://weblogs.asp.net/scottgu/archive/2013/03/04/windows-azure-updates-android-support-sql-reporting-services-active-directory-more.aspx

SQL Down Under Show 56 – Thomas LaRock – DBAs moving to architect, constant learning, Azure, big data

I recorded another podcast today with Thomas LaRock, aka SQL Rock Star.

In this show, Tom and I discussed the migration of many DBAs into architect roles, the challenges in constant learning (and useful resources for doing so), the hype around big data, the role of Windows Azure in our future, and upcoming PASS events.

It's online now: https://www.sqldownunder.com/Resources/Podcast.aspx

Enjoy!

Improvements in the Red Gate source code control suite

One aspect of SQL Server related development that I see done quite badly when visiting client sites is source code control. So many sites have almost nothing in place for this important aspect of development. By comparison, it's rare now that I visit an application development organisation that doesn't have at least reasonable source code control in place. Many DBAs seem to have grown up in environments where source code control systems weren't in use.

I've been pleased to see the Red Gate folk continuing to work in this direction and to expand their toolsets. A while back, they released Source Control for SQL Server: http://www.red-gate.com/products/sql-development/sql-source-control/ but I was also interested to note their upcoming release of Source Control for Oracle: www.red-gate.com/source-control-for-oracle While I focus predominantly on SQL Server, many sites I work with use more than one type of database engine, and the other engine is often Oracle. So it's useful to be able to use a single system for both.

These tools support TFS (which I tend to use mostly now) and SVN which I often see at client sites, usually in conjunction with a Tortoise front end.

If you aren't using source code control in your own site, you should start looking at these types of tools.

Hardware Sizing Guide for SSAS Tabular

Over the last few months, I've been a tech reviewer on John Sirmon and Heidi Steen's new whitepaper.

It's published today on MSDN: Hardware Sizing a Tabular Solution (SQL Server Analysis Services)

Its goal is to help you determine the amount of memory and CPU resources needed to accommodate query and processing workloads in a production environment.

Recommended!