Nice to see the increase in maximum database size on SQL Azure kicked up to 150GB.
In most enterprises I go into, there are a few databases that wouldn’t fit but now the vast majority of databases would fit in SQL Azure.
Also included in the November release are federations and an updated management portal.
More info here: http://msdn.microsoft.com/en-us/library/windowsazure/ff602419.aspx
2011-12-13
Over the years, I’ve seen several causes of this error in SQL Server Integration Services but today I came across another one.
You can get this error if you’ve used 3rd party components (particularly data sources) and the licensing for those components has expired.
Hope that helps someone sometime.
2011-12-13
One of the things that I have been pestering the SQL team to do is to name their updates according to what is contained in them. For example, instead of just:
sqlncli.msi
What I’d prefer is that the file was called something like:
SQLServerNativeClient2k8SP1CU3x64.msi
So I normally rename them as soon as I receive them, to avoid confusion in future. However, today I found that doing so caused me a problem. After renaming the file, and installing it, the installation failed with the error:
2011-11-26
It’s great to see that volume 2 of MVP Deep Dives is now available and will be distributed at the PASS summit next week. I’m really sad that I won’t be at the book signing next week but I’d encourage you all to get along, order a copy and have it signed.
A huge thanks has to go to Kalen Delaney for her management of this project and a big thanks to my fellow editors Louis Davidson, Brad McGehee, Paul Nielsen, Paul Randal, and Kimberly Tripp for their efforts. A special mention for Paul Nielsen whose ideas and spirit around volume 1 that have continued into this new volume.
2011-10-06
Part of the value in the ongoing evolution of the T-SQL language is that we are moving further and further towards being declarative rather than prescriptive ie: we are able to tell SQL Server what we want, rather than how to do it. Over time, that raises more and more possibilities for the optimizer to work with us to achieve a better outcome.
For example, note the following query against the AdventureWorksDW database:
2011-09-11
With SQL Server, there often seems to be an over-emphasis on the items that provide bullet points for the marketing brochure. Yet, small but useful changes to the product can make a more profound impact on DBAs/developers than the new items that are highlighted by those bullet points.
One of the things I loved about Reporting Services in SQL Server 2008 R2 is the amount of focus they provided on ease of use. In particular, the addition of data bars, lookup functions, pagination control, rendering targets in expressions, domain scope, etc. made a huge difference to anyone that really needs to build reports.
2011-09-11
I’ve been doing some work with PowerPivot and SharePoint/Excel Services this week. I wanted the user interface to have slicers for:
But I wanted the slicer to be preselected for the current month. There is no property on the slicers to set a default value. I read a number of websites and the suggestion was to use VBA code to set the value. This works but if you want to have the VBA code run at workbook open, you have to create a macro-enabled workbook, and these are not supported by Excel Services.
2011-08-11
Ola has updated his index optimization scripts again. The update relates to logging to a table.
You’ll find the scripts here: http://ola.hallengren.com/
2011-07-19
When using the Usage Based Optimization wizard (or the Aggregation Design Wizard), on the screen that asks you to enter counts. There is a button that says “Count” but after using it, you might still be confronted by the message ““Estimated Count or Partition Count must be specified for cube objects that require counting”. It’s not overly helpful, given you have just asked it to count them itself.
If you see this, look through the list of dimensions and find any that have red squiggles under them. Then open each and find the attributes that also have squiggles and update those counts. Make sure that all squiggles disappear.
2011-07-06
I spent last week on campus in Redmond with the SQL Server Analysis Services Maestro program. It was great to have a chance to focus on SSAS for a week. As part of that, I did quite a bit of reading as I had quite a bit of travelling time. Ironically, I re-read a few books.
The first was Marco Russo, Alberto Ferrari and Chris Webb’s book Expert Cube Development with Microsoft SQL Server 2008 Analysis Services. I’ve often told BI classes that I’ve been teaching that this is a really good book and highly recommended. Re-reading it confirmed that. I thoroughly enjoyed reading it again.
2011-06-21
