Visual Studio Image Library now available for download

One of the challenges in any application development is trying to make your application look like it's really designed for the target environment. Using the same icons/images that are used in the target environment, and for the same purposes, helps greatly with this.

It's great to see that Microsoft have published an image library for Visual Studio that lets your own applications use the same images that they use in the operating system.

You'll find info about it (and the download) here:

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

 

CTP for Power View and SSAS Multidimensional Cubes

When Power View appeared, one of the big outcries was "but what about connecting to existing cubes!".

Great to see that the SQL Server team have addressed that. A CTP that allows connecting Power View to SSAS Multidimensional cubes is now available:

http://blogs.msdn.com/b/analysisservices/archive/2012/11/29/power-view-for-multidimensional-models-preview.aspx

Help the team get this out the door by trying it and providing feedback.

Visual Studio 2012 Update 1 now available for download

Good to see the Visual Studio 2012 team get update 1 out the door. I'm using it now and am pretty happy with it.

I like the way that the tools are now being updated out of band. Hopefully, the SQL BI folk will get their templates updated to VS2012 soon too.

You can get it here: http://www.microsoft.com/visualstudio/eng/downloads#d-visual-studio-2012-update

Detailed list of what's changed is here: http://blogs.msdn.com/b/visualstudioalm/archive/2012/11/26/visual-studio-and-team-foundation-server-2012-update-1-now-available.aspx

 

Skype support and dead parrot sketches

We as an industry have a lot to answer for. One thing is the level of support provided for users. Here's the conversation I'm having with Skype right now. It feels like being in a Monty Python skit. I was really hoping that when Microsoft purchased Skype that things might improve.

 

8:33:44 PM greglow

Initial Question/Comment: Subscriptions (Unlimited Country, Unlimited Europe, Unlimited Region, Unlimited World)

8:33:44 PM System

Thank you for contacting Skype Customer Support!

8:33:49 PM System

Donna Faye has joined this session!

8:33:50 PM System

Connected with Donna Faye

8:33:50 PM System

Thank you for contacting Skype Customer Support!

8:33:54 PM System

Please hold for the next available Live Support Agent.

8:33:59 PM Donna Faye

Hello! Welcome to Skype Live Support! My name is Donna L. How may I help you?

8:34:09 PM greglow

I've got a subscription (skypename greglow)

8:34:21 PM greglow

It's set to auto-renew

8:34:45 PM greglow

Why have I been getting messages about my Skype number expiring, if it's set to renew automatically

8:34:54 PM greglow

and has recently renewed automatically

8:35:09 PM Donna Faye

Thank you for the information.

8:35:29 PM Donna Faye

To better assist you may I know your Skype name, please?

8:35:37 PM greglow

greglow

8:35:44 PM Donna Faye

Thank you.

8:36:14 PM Donna Faye

I understand your concern that you receive an email notification stating that your calling subscription will about to expire. Am I right?

8:36:43 PM greglow

No, I got an email telling me that one of my Skype numbers was going to expire

8:37:08 PM greglow

When I went to the website, it said it was part of the subscription and the subscription was set to auto-renew

8:37:18 PM greglow

The subscription auto-renewed on Oct XXth

8:37:24 PM greglow

But the number still expired

8:37:43 PM greglow

When I logged on today, it said that the number had expired and that I had 52 days left to reactivate it

8:37:58 PM greglow

I did that but am trying to understand why that happens at all

8:38:36 PM greglow

Why do you expire numbers that are part of auto-renewing subscriptions?

8:39:49 PM Donna Faye

Upon checking your account, your calling subscription link to three Online Numbers.

8:39:55 PM greglow

correct

8:40:10 PM greglow

but until an hour or so ago, one of them had expired. why?

8:40:54 PM Donna Faye

Let me explain to you that now Online Number are detach to a calling subscription unlike before it was attach to the calling subscription so therefore each Online Number will recur individually.

8:41:29 PM Donna Faye

Upon checking your account it shows that all your Online Number will expire on October XX, 2013

8:41:44 PM Donna Faye

If you don't want to be charged again for you can cancel it anytime.

8:41:59 PM greglow

I have set it to charge automatically

8:42:06 PM greglow

so why do the numbers expire?

8:42:32 PM Donna Faye

No they are not expired they are all active.

8:42:33 PM greglow

if there is an automatic payment set up, why does anything expire?

8:42:52 PM greglow

yes, but one of them was expired, and I only fixed it a few hours ago

8:43:07 PM greglow

I'm trying to understand why it expired

8:44:54 PM Donna Faye

The email you got just notify you that you should have good enough funding source of your calling subscription and Online Number in order for this to recur.

8:45:12 PM greglow

Agreed. I did that but the number still expired. Why?

8:45:38 PM Donna Faye

However do not worry on this hence all Online Number are active and not expired.

8:45:41 PM greglow

When I logged on today it said that the number had expired and that I had 52 days left to reactivate it. Why did that happen?

8:46:14 PM Donna Faye

May I know the Online Number you are pertaining, please?

The number that had expired was (07) XXXX XXXX (Australia)

8:49:19 PM Donna Faye

Okay, do not worry on this Online Number because this will expire on October XX, 2013.

8:49:38 PM Donna Faye

Thank you for all the information.

8:49:46 PM greglow

I understand that it won't expire now until next year. I'm trying to understand why it stopped working this time

8:49:51 PM greglow

so I can avoid that next time

8:50:39 PM Donna Faye

What do yo stop working, you mean that Online Number is unable to be reach out?

8:50:59 PM Donna Faye

*what do you mean by stop working

8:51:18 PM greglow

The Skype number +61 7 XXXX XXXX stopped working because it expired

8:51:32 PM Donna Faye

No, this into expired.

8:51:34 PM greglow

I'm trying to understand why it expired

8:51:50 PM greglow

Sorry I don't follow "this into expired"

8:52:39 PM Donna Faye

Let me inform you that this Online Number is not expired.

8:52:54 PM Donna Faye

Please disregard the notification you see on your Skype account.

8:53:02 PM greglow

Sorry, this is getting very frustrating. I already told you I fixed it today. I want to know why it happened.

8:53:20 PM Donna Faye

Hence I can rest assured you that this is active until October XX, 2013.

8:53:21 PM greglow

So I can avoid it happening again, on this account, or on our other accounts

8:53:34 PM greglow

Can I speak to someone who really understands this please?

Donna Faye

Skype send a notification to Skype users for their Skype product in order for them to be aware the expiration of your product however your Online Number still active on your account hence when your calling subscription Unlimited World recur your Online Number also recur.
 
8:57:59 PM Donna Faye
 
I do apologize for this matter, please allow me to resolve this issue for you.
 
9:02:48 PM greglow
 
My question is still the same: if it's set to auto-pay, why did it expire?
 
9:03:50 PM greglow
 
Why did it stop working? Why did I have to "reactivate" it?
 
9:04:08 PM greglow
 
Why didn't it just keep working if it's set to auto-pay?
 
9:04:30 PM greglow
 
This isn't a difficult concept
 
9:04:34 PM Donna Faye
 
Let me clarify to you that this is not the really expired what is emphasizing on this is when you don't have good enough funding source when you calling subscription recur the Online Number will possibly expired but seem that you have a good funding source then this will continue until 2013.
 
9:05:10 PM greglow
 
When I logged on today, it was not working, and your website said it had expired and that I had 52 days left to reactivate it
 
9:05:17 PM greglow
 
Why?

and so on, and so on, and so on….

 

Suggestion: ALLFILES option for RESTORE

The default action when performing a backup is to append to the backup file yet the default action when restoring a backup is to restore just the first file.

I constantly come across customer situations where they are puzzled that they seem to have lost data after they have completed a restore. Invariably, it's just that they haven't restored all the backups contained within a single OS file. This happens most commonly with log backups but also happens when they have not restored the most recent database backup file.

It is not trivial to achieve this within simple T-SQL scripts, when the number of backup files within the OS file is unknown. It really should be.

I'd like to see a FILES=ALLFILES option on the RESTORE command. For RESTORE DATABASE, it should restore the most recent database backup plus any subsequent log files. For RESTORE LOG (which is the most important missing option), it should just restore all relevant log backups that are contained.

If you agree, you know what to do: please vote:  

https://connect.microsoft.com/SQLServer/feedback/details/769204/option-to-restore-all-backups-files-within-a-media-set

Alternately, how would you write a T-SQL command to restore all log backups within a single OS file where the number of files is unknown? Would love to hear creative solutions because all the ones that I think of are pretty messy and need dynamic SQL.

 

Update from Ola Hallengren: Target multiple devices during SQL Server backup

Ola has produced another update of his database management scripts. If you haven't taken a look at them, you should. At the very least, they'll give you good ideas about what to implement and how others have done so. The latest update allows targeting multiple devices during backup. This is available in native SQL Server backup and can be helpful with very large databases. Ola's scripts now support it as well.

Details are here:

http://ola.hallengren.com/sql-server-backup.html

http://ola.hallengren.com/versions.html

The following example shows it backing up to 4 files on 4 drives, one file on each drive:

EXECUTE dbo.DatabaseBackup
@Databases = 'USER_DATABASES',
@Directory = 'C:\Backup, D:\Backup, E:\Backup, F:\Backup',
@BackupType = 'FULL',
@Compress = 'Y',
@NumberOfFiles = 4

And this example shows backing up to 16 files on 4 drives, 4 files on each drive:

EXECUTE dbo.DatabaseBackup
@Databases = 'USER_DATABASES',
@Directory = 'C:\Backup, D:\Backup, E:\Backup, F:\Backup',
@BackupType = 'FULL',
@Compress = 'Y',
@NumberOfFiles = 16

Ola mentioned that you can now back up to up to 64 drives.

 

Opinion: Passwords as a concept are completely broken

One thing you get to do as you get older, or have been around the industry for a long time, is to pontificate. My pet topic today is passwords. I think that they are, as a concept, now completely broken and have been for a long time.

We tell users:

1. Pick something really complex

2. Don't write it down

3. Change it regularly

4. Use a different password for each site, and often each role that you hold in each site

5. Deal with the fact that we apply different rules for passwords on each site

etc, etc.

Is this even humanly possible? I don't think it is. Yet we blame the users when "they" get it wrong. How can they be getting it wrong when we design a system that requires super-human ability to comply. (These guys are potential exceptions: http://www.worldmemorychampionships.com/)

We are the ones that are getting it wrong and it's long overdue that we, as an industry, need to apply our minds to fixing it, instead of assuming that users should just deal with it.

SQL Down Under Show 51 – Guest Conor Cunningham – Now online

Late last night I got to record an interview with Conor Cunningham.

Most people that know Conor have come across him as the product team wizard that knows so much about query processing and optimization in SQL Server. Conor is currently spending quite a lot of time working on Windows Azure SQL Database, which we used to know as SQL Azure.

I'm still trying to think of a good way to say "WASD". I suppose I'll pronounce it like "wassid". Windows Azure SQL Reporting is easier. I think it just needs to be pronounced like "wazza" with a very Australian accent.

In the show, we've spent time on the current state of the platform, on dispelling a number of common misbeliefs about the product, and hopefully on answering most of the common questions that seem to get asked about it. We then ventured into Federations, Data Sync, and Reporting.

You'll find the show (and previous shows) here: http://www.sqldownunder.com/Resources/Podcast.aspx

Enjoy!

PS: For those that like transcripts, we've got the process for producing them much improved now and the transcript should also be up within a few days.

SQL Down Under Podcast 50 – Guest Louis Davidson now online

Hi Folks,

I've recorded an interview today with SQL Server MVP Louis Davidson. In it, Louis discusses some of his thoughts on database design and his latest book.

You'll find the podcast here: http://www.sqldownunder.com/Resources/Podcast.aspx

And you'll find his latest book (Pro SQL Server 2012 Relational Database Design and Implementation) here: http://www.amazon.com/Server-Relational-Database-Implementation-Professional/dp/1430236957/ref=sr_1_2?ie=UTF8&qid=1344997477&sr=8-2&keywords=louis+davidson

Enjoy!