I posted another podcast over the weekend. Late last week, I managed to get a show recorded with Adam Machanic. Adam’s always fascinating. In this show, he’s talking about what he’s found regarding increasing query performance using parallelism. Late in the show, he gives his thoughts on a number of topics related to the upcoming SQL Server 2014.
Enjoy!
The show is online now: SQL Down Under Podcast
2013-06-30
I have to say that I continue to be frustrated with finding out how to do things in Windows 8. Here’s another one and it’s recorded so it might help someone else. I’ve also documented what I tried so that if anyone from the product group ever reads this, they’ll understand how I searched for it and might try to make it easier.
I wanted to add a network loopback adapter, to have a fixed IP address to work with when using an “internal” network with Hyper-V. (The fact that I even need to do this is also painful. I don’t know why Hyper-V can’t make it easy to work with host system folders, etc. as easily as I can with VirtualPC, VirtualBox, etc. but that’s a topic for another day).
2013-06-13
If you have followed any of the Azure website forums, you’d realize that having SSL available was one of the highest rated requests. That’s hardly surprising given the number of clients that want to use these sites for eCommerce work.
So it’s really good to see that Scott Guthrie and the team have been listening and that SSL is now available. To see the details, click on the “SSL” button in the “Learn More” area of the Azure pricing page. An FAQ is also provided.
2013-06-03
Yesterday I was at a site where they decided to change the service account for the SQL Server services on a set of systems. After changing the service accounts, SQL Server restarted just fine on all machines except one.
I had used the SQL Server Configuration Manager to make the changes (important to not just use the Services applet in Administrative Tools) but I got the typical error telling me that the service wouldn’t start in a timely fashion. The server was running SQL Server 2008 R2 SP2.
2013-05-30
I was so glad to hear today that Azure is expanding to Australia. This helps with two remaining areas of concern that I’ve heard from a variety of customers:
With both these concerns now disappearing, it’s time for more Australian customers to get involved with Azure if they’ve been resisting so far.
2013-05-21
Hi Folks,
On Thursday night, I got to record a podcast with Reza Rad. I was interested to speak to Reza after reading his SQL Server 2012 Integration Services Cookbook.
In the show, we discuss SQL Server Integration Services (SSIS) extensibility and some aspects of performance tuning for SSIS.
You’ll find the show here: SQL Down Under Podcast
Enjoy!
2013-05-13
I posted the other day about a hotfix that’s needed after you apply SQL Server 2012 SP1 CU3, to still be able to open or edit SSIS projects or database maintenance plans in SSDT.
However, I found that after I applied CU3 and the hotfix, that all my stored credential details for SQL Servers was gone. That was particularly nasty for all my Azure-related logons. I had to set them up again.
2013-04-09
Cumulative Update 3 for SP1 for SQL Server 2012 caused a number of problems with SSIS packages. This also applies to database maintenance plans as they are also SSIS packages.
After applying the update, you could get this error when opening an SSIS package:
The type initializer for ‘Microsoft.DataTransformationServices.Design.SharedIcons’ threw an exception.
Value of ’null’ is not valid for ‘stream’. (System.Drawing)
If you edit a maintenance plan, you could get this error:
2013-04-06
In Melbourne, it was the coldest morning of the year so far but I didn’t mind getting up at 5:30AM to record an interview with Marco Russo. Marco is well-known in the SQL BI community for his writing and presentations.
SQL Down Under show 58 is now online: https://sqldownunder.com/podcast
In this show, Marco discusses concepts and experiences from working with tabular data models in SQL Server Analysis Services.
Enjoy!
2013-04-01
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:
2013-03-19