Upgrade to SQL Server 2012

SQL Server 2012 offers several useful features. The most used is probably the ability to paginate results without the need to use nested queries. However, AlwaysOn is certainly not in the background, providing higher availability, the ability to install on Windows Server Core and more management options from the PowerShell environment. The database backup can be easily saved to Windows Azure a SSMS has improved IntelliSense. Read more ›

Automatic generation of change scripts

With the development of the application, its database is also developing. While old assemblies can be replaced with new ones without much difficulty, changing the database is not so easy. Its data must be preserved. In this case, the easiest way is to run a SQL script that promotes the database to the desired state. It can be written manually, but it is much more convenient to use the possibilities of SQL Server Management Studio and have the scripts generated automatically. A new table can be regenerated. However, not its modification. Read more ›

SQL Server Compact 4

Microsoft released a new version of its embedded database last week. Previous versions of this database were used only with desktop applications. It wasn't designed to handle multiple requests at the same time. This has changed in the new version. It can be used from multiple fibers at the same time without fear of falling or getting stuck. This significantly expanded its scope of activity to include deployment on web servers. There is no need to install the database, just copy a few files. Read more ›