Azure / Sql – New offers and capabilities for SQL 2008 Server

As you may know (otherwise, this is it, you know ), SQL Server 2008/2008 R2 is going out of support in July 2019 (https://support.microsoft.com/en-us/lifecycle/search/14917), while Windows Server 2008 is going to be out of support in January 2020 (https://support.microsoft.com/en-us/lifecycle/search/12925). To help you migrate your workloads still running on these systems, Microsoft is extending the security updates support for 3 years when running these systems on Microsoft Azure. That said, it…

Read More

Azure – Data classification and protection now available for SQL

SQL Information Protection now includes new capabilities to help identify, classify or monitor data stored in your SQL databases.   Use on Azure SQL To start using these new capabilities, go to your Azure ARM portal (https://portal.azure.com) and reach your SQL Server blade. Then access the SQL database you want to Advanced Threat Protection configuration blade to turn on the feature Once enabled you will be able to access the…

Read More

Azure – SQL Vulnerability Assessment

Microsoft has introduced a new feature to help you ensuring your Azure SQL services are secured. This feature is called SQL Vulnerability Assessment and is available on preview; the good news is you can also use it with your on-premises SQL servers. It has been designed in a way that even non security/SQL expert can gain advantage of it. The SQL VA uses a knowledge base of rules to identify…

Read More

Beta – New version of Windows, SQL and Azure

As you may already know, if not this is it , Microsoft has made some major announcements last week about the future version of Windows Server (Windows Server 2012 R2), SQL server (SQL Server 2014), System Center (System Center 2012 R2) and Windows Azure. So, if you want to start evaluating these new coming version you can go to the Eval Center here http://technet.microsoft.com/en-au/evalcenter/dn205292.aspx

Read More

Various – All Microsoft e-books

As you may already know, Microsoft is publishing frequently e-books related to deployment or technology usage. To help you finding these e-books, a wiki page has been created which is listing all Microsoft e-books published today. Use this page to find and download your missing e-book on Office, Office 365, SharePoint, SQL, Windows or development tools (Visual Studio / Azure) http://social.technet.microsoft.com/wiki/contents/articles/11608.e-book-gallery-for-microsoft-technologies-en-us.aspx

Read More

SQL 2012 – Always On feature installation and configuration

With SQL 2012, Microsoft has introduced a new high availability functionality called Always On. This feature allows you to manage high availability for specific set of database called Availability Database. For those who are familiar with Exchange 2010, this can be compared with DAG feature. Prerequisites installation To use Always On SQL feature you must deploy an Enterprise Edition of Windows Server as this is the one which includes cluster…

Read More

Microsoft Products – Schedule delivery date for incoming products

As you may already know, there is a lot of incoming new product version for the next 12 to 24 months, including the waited Windows 8. Microsoft has published an initial schedule of delivery. Keep in mind this may still change will product groups are still working on many of these products. Windows 8 Anticipated release: Between Q3 2012 and early 2013 (UPDATED 1/12) Anticipated release date: Beta expected "late…

Read More

SQL Denali – Free ebook “Introducing Microsoft SQL Server Code Name “Denali””

As you may already know, Microsoft is working on the next version of SQL, codename SQL Denali – officially called SQL 2012. To start learning (and enjoying) SQL Denali, Microsoft is offering a free ebook (still in writing progress) http://go.microsoft.com/FWLink/?Linkid=229829 Microsoft SQL Server Denali delivers significant enhancements to well-known, critical capabilities like high availability and disaster recovery. These enhancements promise to assist organizations in achieving the highest mission-critical confidence to…

Read More

SQL – SQL 2005 SP 4 now available

Microsoft has released the Service Pack 4 for SQL 2005. This may be the last SP for SQL 2005 – think to move to newer SQL version. SQL 2005 SP 4 includes SQL Server 2005 SP3 cumulative updates 1 to 11, customer requested fixes, and the SQL Server 2005 SP4 database engine support for DAC operations. You can download Service Pack 4 from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b953e84f-9307-405e-bceb-47bd345baece&displaylang=en

Read More

SQL Server – Next version is available in beta

Microsoft has published a beta version of the next SQL edition, called Denali. You can download the first CTP here http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9 Has part of the evolution, you will have: Enhanced mission-critical platform: A highly available and scalable platform designed to with greater flexibility, lower TCO, ease of use, and the performance required by the most mission-critical applications. Developer and IT Productivity: New additional tools will help developers build innovative applications…

Read More

SQL – Service Pack 2 for SQL Server 2008 now available

Microsoft SQL Server 2008 Service Pack 2 (SP2) is now available for download. These packages may be used to upgrade any edition of SQL Server 2008. We remain committed to providing our customers with essential changes via Service packs. Service Pack 2 contains updates for SQL Server Utility, Data-Tier Application (DAC), as well as integration capability for Microsoft Reporting Services with the Microsoft SharePoint 2010 Technologies. Service Pack 2 introduces…

Read More

SQL Server – Free ebook: Introducing Microsoft SQL Server 2008 R2

Our purpose in Introducing Microsoft SQL Server 2008 R2 is to point out both the new and the improved in the latest version of SQL Server. Because this version is Release 2 (R2) of SQL Server 2008, you might think the changes are relatively minor—more than a service pack, but not enough to justify an entirely new version. However, as you read this book, we think you will find that…

Read More