MS SQL Server (EN)

  • Introduction to SQL Server 2016: new features & improving security

    SQL Server 2016 new features and security improvmentSQL Server is the main relational database management product from Microsoft. It has been around in one form or another since the late 1980s (developed in partnership with Sybase), but as a standalone Microsoft product since the early 1990s. During the last 20 years, SQL Server has changed and evolved, gaining newer features and functionality along the way.

  • Introduction to the Family of SQL Server Products

    Microsoft SQL Server Compact 4.0   

    Microsoft SQL Server Compact 4.0 is a compact database that is embedded inside Nexus and other desktops around the world. It is ideal for also embedding in web applications. SQL Server Compact 4.0 provides developers a common programming model with other SQL Server editions. This is important for developing both native and managed applications. SQL Server Compact provides outstanding flexibility, but in a small footprint.

  • Microsoft Azure SQL Data Warehouse - what's new?

    Microsoft's Azure SQL Data Warehouse is a massively parallel processing (MPP) data warehousing appliance built for any volume of relational data and provides integration to Hadoop. Azure SQL Data Warehouse can provide up to 100x performance gains over other SQL Server platforms. This is the MPP platform that provides linear scalability for when data volumes grow and the number of users increases.

  • MS SQL Server 2016: new Database Engine features

    SQL Server 2016 Database Engine new featuresThe engine features section is traditionally the most important, or interesting, for most DBAs or system administrators when a new version of MS SQL Server is released. However, there are also numerous engine feature improvements that have tangential meaning for developers too. So, if you are a developer, don't skip this section or you may miss some improvements that could save you some trouble later on!

  • SQL Server 2017 new Engine features for DBAs and developers

    The Engine features section is traditionally the most important, or interesting, for most DBAs or system administrators when a new version of Microsoft SQL Server is released. However, there are also numerous engine feature improvements that have tangential meanings for developers too. So, if you are a developer, don't skip this artice - or you may miss some improvements that could save you some trouble later on!

  • SQL Server 2017: new security features

    The last few years have made the importance of security in IT extremely apparent, particularly when we consider the repercussions of the Edward Snowden data leaks or multiple cases of data theft via hacking. While no system is completely impenetrable, we should always be considering how we can improve the security of the systems we build. These considerations are wide ranging and sometimes even dictated via rules, regulations, and laws. Microsoft has responded to the increased focus on security by delivering new features to assist developers and DBAs in their search for more secure systems.