Upgrade your SQL Server to scale before adding new hardware

In SQL Server Tiger team, we closely partner with our customers and partners to ensure they can successfully run and scale their Tier 1 mission critical workloads and applications on SQL Server. Based on our experience and interactions with customers, we found that most customers running older releases of SQL Server and experiencing performance and… Continue reading Upgrade your SQL Server to scale before adding new hardware

Understanding data security in cloned databases created using DBCC CLONEDATABASE

DBCC CLONEDATABASE feature was first introduced in SQL Server with SQL Server 2014 SP2 and was later added to SQL Server 2016 with SP1. The primary design goal for DBCC CLONEDATABASE which the SQL Product team had in mind is to provide mechanism to create fast, minimally invasive and transaction ally consistent database clones, useful… Continue reading Understanding data security in cloned databases created using DBCC CLONEDATABASE

Remote Blob Storage (RBS) client library setup requirements in SQL Server 2016

Cross post from https://blogs.msdn.microsoft.com/sql_server_team/remote-blob-storage-rbs-client-library-setup-requirements-in-sql-server-2016/ Remote BLOB Store (RBS) is a client library with SQL Server which allows developers to store, access, retrieve binary large objects (BLOBs) outside SQL Server database files while still maintaining the ACID properties and transactional consistency of data in Blob store. RBS allows you to efficiently utilize storage and IO resources… Continue reading Remote Blob Storage (RBS) client library setup requirements in SQL Server 2016