The compression of backup in SQL Server has been supported since the release of 2008 R2. But I was surprised that this feature is not enabled by default!
To discover if your server has this feature currently set, you can run this small query:
SELECT value FROM sys.configurations WHERE name = 'backup compression default'
If the value returned is 1, then compression is already enabled. If the returned value is 0 and you want to enable the feature, you can do it by running this query:
EXEC sys.sp_configure 'backup compression default', 1
That will default all the backup (otherwise specified) to compress backups.
Note that as stated in Features Supported by the Editions of SQL Server 2014, the Express nor the Web editions support this feature.
I had one database in particular that the size of the backup was 3.5gb uncompressed. After enabling that feature, the size of the backup went down to 850mb. Your mileage may vary!
Of course this setting is also available if you open the Properties of your server (under Database settings).
Finally, it is also available to the backup command line. But I really recommend setting it at the server level so that all backups can automatically benefit from this feature.
This is the first article of 2016! Happy New Year.
Sometimes, when building applications, you need to warn users that something just happened but this warning doesn’t always have to be intrusive. In those occasion, a modal message box is not appropriate.
This is exactly what this article is about: showing very simple non-blocking notifications from a WPF application. I will even provide you links to other more complete, fancier and complex components to use (but still free).
If you are interested by that article, have a look at http://emoreau.com/Entries/Articles/2016/01/WPF-application-notifications.aspx
I really hope that I won't surprise anybody saying that SQL Server 2016 is just around the corner. It is now in technical preview if you have a spare machine (or a VM) to test it. The publicly available CTP is available from http://www.microsoft.com/en-ca/server-cloud/products/sql-server-2016/.
A free e-book is also available from http://blogs.msdn.com/b/microsoft_press/archive/2015/12/22/free-ebook-introducing-microsoft-sql-server-2016-mission-critical-applications-deeper-insights-hyperscale-cloud-preview-edition.aspx. They even have a smaller PDF version optimized for mobile reading.
I just published my last article for 2015.
Embedding a component as a resource in an application simplifies the distribution because you have less resources (files) to distribute.
A couple of months ago, I have shown how to embed a font into a WPF application. But we are not limited to fonts. DLLs from Class library can be embedded as well but it is a bit more complex to use them.
This month, I will show you how to embed a .Net DLL into a .Net application. I believe that this trick can be useful in very specific situation. But for large applications, I would never recommend to use this solution!
You can read this article from http://emoreau.com/Entries/Articles/2015/12/Embedding-a-DLL-in-a-Net-application.aspx
I just finished rewriting an article I have written in 2007 about licensing a .Net application.
The original article still has a lot of reads and generates a lot of questions. The questions are mostly because the sample I wrote at that time was misleading and contained both the client application and the key generation parts.
I have recreated the sample in 3 different projects (a common class library, a test project and a key generation project). It should be easier for you to understand what goes where!
You can read it from http://emoreau.com/Entries/Articles/2015/11/Licensing-a-Net-application--2015-edition.aspx
I am just back from a week in Redmond for the annual MVP Summit. I have met a lot of friends over there.
The only thing I can tell you is not to miss the Microsoft Connect() online and free event that will be held November 18-19. Last year, they made some great announcement and from what I read between the lines, it should be as exciting this year.
You can check the agenda by going to http://connect2015.visualstudio.com/
Since yesterday, I wasn't able to open Excel files located on the network which were previously running just fine.
I was receiving errors saying that the file was corrupted or the Excel splash screen was simply freezing trying to open the file.
To add to this strange issue, the same file when copied on my desktop was opening just fine!
I haven't changed anything on my computer. I even tried a Office 2016 repair. So surely one of the Windows Update pushed automatically to my Windows 10!
I have been able to fix my issue by following the steps listed on https://forum.openoffice.org/en/forum/viewtopic.php?f=15&t=42387 (even if I don't have Open Office installed!).
Lately, I had remote users testing one of my application. These users were not SnagIt users. They asked me to add a button to the application that will automatically create an email and attach the snapshot just taken.
So that was my inspiration for this month article which you can read from http://emoreau.com/Entries/Articles/2015/10/Taking-a-snapshot-of-a-screen-in-WPF.aspx.
La cédule du prochain samedi SQL (SQL Saturday) est maintenant connue. Une grande nouveauté, 2 salles offriront des sessions. Vous avez donc plus de variété dans les sessions offertes. Des sessions seront offertes en français et en anglais.
L'événement est ouvert à tous mais l'inscription est obligatoire! L'événement lui-même sera gratuit grâce à des commandites de PASS mais nous demandons 10$ pour le diner.
L'inscription et le paiement du 10$ se font sur le site de PASS: http://www.sqlsaturday.com/466/eventhome.aspx
Cet événement est organisé par les membres de MSDEVMTL.
The schedule of the next SQL Saturday is now public. The event will offer 2 tracks for more sessions available to you. Sessions will be offered in French and English.
The event itself is open to everybody but you need to register. The event is free (thanks to our sponsor PASS) but you need to pay 10$ for the lunch.
Registration and the payment need to done on the PASS web site: http://www.sqlsaturday.com/466/eventhome.aspx
This event is organized by the members of MSDEVMTL.
I just published a new article about the WPF Calendar control which is available since WPF 4.0.
This article shows you how to customize important behaviors of the control to give a better user experience.
You can read the article from http://emoreau.com/Entries/Articles/2015/09/Customizing-the-WPF-Calendar-control-.aspx