SQL Bits: 8 Most Important New Features In SQL Server 2012

by Dmitry Kirsanov 16. February 2013 07:00

SQL Server 2012

If you are developer, then you work with relational databases as well. And if you work in a Windows world, most likely your system of choice is Microsoft SQL Server.

With every new DBMS release we find something that changes the way we solve common problems in new solutions. SQL Server 2012 is no exception.

In SQL Server 2012, instead of just enhancing the productivity and robustness of the server, Microsoft solved a number of architectural problems we previously had to deal with in our applications when working with SQL Server.

Problems like saving files in databases, load balancing database clusters and simple restoration of data, finally got the minimum viable solution, which should only improve with time.

More...

Introduction to Windows 8 Development: XAML Controls

by Dmitry Kirsanov 29. January 2013 11:00

This is the second part of Controls section of my introduction to Windows 8 Development, and today we are going to review the developing of XAML applications for Windows Store. First part is available here.

A little off topic

One of my favorite quotes belongs to Ludwig Mies van der Rohe, and that is – “The God is in the details”. I’ve checked – this was the sixth time I quoted him in my blog, and the first three quotes insist that devil is in details as well. Depends from the details, I guess. And there are many details of both kinds in the ways you develop HTML5 or XAML applications for Windows Store or Windows Phone.

Sometimes it’s pure HTML5, sometimes it’s XAML application with web browser control to display HTML5 contents. Sometimes you have UI preview, and sometimes you have to use external editor, like Blend. Some controls belong to particular technology and have no counterparts in another… So when someone is saying “it’s a matter of style” again, I look like this:Cheshire Cat in Tim Burton's Alice in Wonderland

Because when you are in nights-and-weekends marathon for having your Big Idea project done (or should I say – a marathon-long race?), you could see the difference between technologies, and it’s displayed in form of a price tag, where the currency is time.

There are few things that could buy you some time. Your expertise in domain is one of them, and that’s where the difference between technologies matter most. Other things include the value of your brand (if Microsoft or Google would release a copy of your project a few months later, it would be a tough time for you, so their brands could buy them some time and grant market share), the availability of ready made components (elements of the framework, third party controls and libraries) and perhaps some performance boosters like Resharper.

And since I mentioned the competition, maybe you wouldn’t like to publish your work as open-source HTML5 / JavaScript project, but rather as half-compiled XAML/C# one?

More...

Introduction to Windows 8 Development: Working with Controls

by Dmitry Kirsanov 14. January 2013 08:00

Windows 8 everyday controls

One essential part of Windows 8 software development is developing the user interface. Which means – placing right controls in right place, and make them an organic part of overall user experience. And what an exciting topic is that!

In Windows 8, there are only few new controls, but the ones you knew were changed drastically. You can choose either XAML or HTML5 for your application, and among other things, the set of available controls will change, so now you’ll have to master your skills of using more controls than before.

The “same” controls may look the same at the screen, but they are different inside. HTML5 provides you with additional controls specified in HTML5 standard, and you don’t have to worry about multi-browser support (unless you want to keep the certain degree of compatibility, anyway), but the problem is – HTML5 is not covered fully by MSIE 10, which provides you it’s HTML5 engine – the Trident.

We’ll cover both native and 3rd party controls available to you for both XAML and HTML5 applications. For the sake of simplicity, this article will be more about HTML5, while the next one – about XAML controls, and the third part – about general rules and principles of user interface design in Windows 8. Then we’ll cover Windows Phone 8 controls as well.

More...

Introduction to Windows 8 Development: Working with Sensors

by Dmitry Kirsanov 5. January 2013 09:00

Nearly all mobile devices (not necessarily cell phones, but anything that’s mobile enough) these days have sensors. And that will be our topic for today.

By the way, the way the term “mobile” is used today, reminds me an old anecdote with lady asking an IT guy, who tried to explain the difference between floppy disk and hard disk, whether that floppy disk isn’t hard enough for him. So, let’s settle on the definition that mobile devices are not stationery.

As we found previously, Windows 8 supports many platforms, and each platform has it’s own sensors, and new sensors are invented and need to be supported by OS.

Also, you may find out that your mobile device has more sensors than listed in your device specs. For instance, you may enjoy such sensors as compass and inclinometer, even though you have no such hardware in your device, and that’s because some sensors are “fusion”, or “virtual” – i.e. their data are results of computational analysis of data from other, “real” or “raw” sensors.

More...

Introduction to Windows 8 App Development: HTML5 or XAML?

by Dmitry Kirsanov 30. December 2012 15:19

As you, perhaps, already know, in Windows 8 you can develop Windows Store applications by using one of 3 ways:

MetroLanguageProjections

It’s either C++ native application using DirectX, or C# / VB .NET application using XAML, or HTML5 / CSS3 / JavaScript application.

Although Microsoft says that it’s more a matter of style, there are some advantages and disadvantages in using each of these methods and we are going to discuss them now.

As you know, Windows 8 is the first Microsoft’s operating system whose kernel works on servers, workstations, tablets and even mobile phones, which means that it supports a lot of scenarios beyond the scope of any single platform. Windows 8 shares it’s kernel with Windows Server 2012 (servers), Windows RT (ARM based tablets) and Windows Phone 8 (mobile phones), but fortunately you can’t build application that would work on each platform without changes. This reminds me Linux (shares kernel with Android) and MacOS (shares kernel with iOS) – even though at low level it’s the same OS, what’s stands on the shoulders of that kernel is what makes real difference. As Ludwig Mies van der Rohe said, “the God is in the details”.

More...

Introduction to Windows 8 Apps for Software Developers

by Dmitry Kirsanov 29. December 2012 16:24

Earlier this month, I wrote an introduction to Windows 8 Store for those who didn’t attend any course or online event, but would like to learn about it.

I met quite a few people so far, who wanted to go through Windows 8 development labs without knowing anything about how Windows 8 works, what are the new key components and so on. Needless to say, practice without even the basic theory is a waste of time.

So, this is the second part of about 10-part introduction to Windows 8 for Software Developers, and this time we’ll talk about the Metro Style application principles – what they are, how they work, what you should know first.

More...

The Price of Effective Training

by Dmitry Kirsanov 21. December 2012 08:00

I’ve finished an experiment today. For a bit more than a week I was going to prepare myself for a Microsoft certification exam 70-480, which is about HTML5, CSS3 and JavaScript. I had good prior knowledge of HTML 4, some basic JavaScript and (as I thought) good enough CSS. However, this was about the next, more advanced level.

The experiment was simple – even though I had access to quite expensive courses and official training materials, I was only going to use free video training created by Microsoft, which is available for everyone at Channel9. And what do you know? 900 / 1000.

More...

Creating Windows 8 Store Apps: Introduction to Windows Store for Software Developers

by Dmitry Kirsanov 15. December 2012 13:16

For a long time I had an itch to create an introduction to Windows 8 Metro Apps development with using either XAML or HTML 5 and JavaScript, but had no time to begin. So here it goes.

This will be the first part of (hopefully) many and I’ll begin with explaining the Windows Store – what it is, how it works and why I think it should matter for you.

More...

How To Ruin a Good Idea, part 2

by Dmitry Kirsanov 17. November 2012 06:34

New technologies allow us to reach new goals. Different tool sets enrich scenarios and it becomes easy to do things we couldn’t dream about before. We implement features so fast, that sometimes we just can’t analyze the impact until the most loyal customers uninstall our app.

Once upon a time I’ve downloaded the mobile application which made my phone a toy that could be handed to a kid. Just like the Kid’s Corner in Windows Phone 8, but for Android. It contained a few badly written games, but it was not the reason why I uninstalled it.

In Android, just like in Windows 8, you can use other apps to enrich your application with their services. Connect to social networks, send e-mails and whatever else.

What this particular application did – it used my e-mail application to send e-mail to developer of that application, to automatically register me as it’s user. I realized that only when I’ve received an e-mail with the password and warm “thank you” for registration which I didn’t commit or solicit.

In some countries that’s crime which could cost you your business.

The morale is – sometimes you can’t do what you can do. You can use contracts in Windows 8 (or their analogs in Android and iOS), but you shouldn’t do anything that your customer is not aware of and can’t cancel before it happens.

The Possible Future of Reporting Services

by Dmitry Kirsanov 15. October 2012 14:04

Today, if you’ll visit the MSDN Labs, you won’t find there much about Microsoft SQL Server Reporting Services. The reason is simple – Microsoft doesn’t consider reporting to be the edge technology. The frontier of changes and fountain of creativity is somewhere else. Usually what you see in there is something that is complex or very important for Microsoft. Neither is a category for reports.

However, I recognize the trend, which is, although relatively distant, could shift the position of Reporting Services and perhaps make it more widespread, potentially adding more jobs to the market.

More...


Month List