Menu

Microsoft virtualization upgrade 4 Free One of the greatest things about cloud-based virtualization is that updates are rolled out by providers and don’t require end users to do anything. In the latest example of this, Microsoft just drastically increased the speed of its virtual machines for almost everyone using its platform. Azure: Microsoft’s virtualization platform…

Microsoft Azure SQL Database, there are good reasons why outsourcing to the cloud makes sense for many applications. Microsoft Azure SQL Database provides a SQL Server-based, multi-tenant database as a service in the Azure cloud, removing IT hardware and server management tasks from your data center. Azure platform as a service (PaaS) allows you to…

SQL Azure Disaster Recovery Plan The allure of cost savings, greater flexibility, and more agility, many organizations are eyeing the cloud as an alternative for deploying new applications, including those with high database performance requirements, 72% annual growth rate of cloud-based databases through 2018. We are build up the setup SQL server Cluster in Azure…

The Microsoft SQL Server Migration Assistant, which is often abbreviated to just SSMA, comes in different versions that support the migration from several of the most common database formats. The one we’re most interested in is SSMA for Access, but there’s also separate versions that will migrate from MySQL databases, or Oracle databases, or a…

What’s new for SQL Server 2017 running on Linux. CTP 2.0 now The CTP 2.0 release contains the following improvements and fixes: Added Log Shipping functionality for SQL Server Agent. Localized messages of mssql-conf. Linux path formatting are now compatible throughout the SQL Server Engine. But support for “C:\” prefixed paths will continue. Enabled DMV…

SQL Server 2016 – Temporal Tables The temporal table feature in SQL Server 2016 is a breakthrough in data warehousing, because we no longer need to do anything to store the historical values. Data warehouse by approximately 15% half of the ETL development effort which is about 30%; the other 70% is analysis, design, database…

SQL Server 2014’s new In-Memory OLTP, with its 2x-30x performance improvements, provides a pretty compelling reason to migrate to SQL Server 2014—in spite of the fact that SQL Server 2014 was released just two years after the last SQL Server 2012 release. There are two basic strategies for upgrading to a new SQL Server release.…

Products retiring On April 12, 2016 the following products will NO longer be supported: SQL Server 2005 .Net Framework 2.0 System Center Data Protection Manager 2006 Visual Studio 2005 Dynamics CRM 3.0 Windows Embedded for Point of Service On July 12, 2016 the following products will NO longer be supported: BizTalk Server 2006…

Setting the Memory Options Manually. Use the two server memory options, min server memory and max server memory, to reconfigure the amount of memory (in megabytes) that is managed by the SQL Server Memory Manager for a SQL Server process used by an instance of SQL Server. Error: PLE: Page Life Expectancy is number of seconds a…

MS SQL database backup file SQL Server 2016 Community Technology Preview 2 (CTP2) through current version). To make your database secured and protective; it helps you to restore your inaccessible files of the main database when any type of corruption or damage occurs. But, what if backup also corrupt, while attempting to restore database from…

SQL Server 2012, there is a new setup feature introduced which can apply a patch to SQL Server bits before the server is even set up for the first time. You download a cumulative update patch from the hotfix link in the Kb articles below links, then point setup to the right folder and it…

MS SQL Server problem’s. MS SQL Server is a separate technology, it is often the case that when problems occur, uncertainty arises regarding the root cause, and problem scope is rarely well outlined. Although many of the details here are not specific to SQL Server problems, they are good practices for troubleshooting many types of complex IT…