sqluninterrupted.com
SQL Engine | SQLUNINTERRUPTED
https://sqluninterrupted.com/category/sql-server/sql-engine
I am just a medium, SQL Server the Goal. Category Archives: SQL Engine. SQL Community Session–Indexing Basics and Writing Optimal Queries. Posted by Sourabh Agarwal. On January 10, 2016. Back in December 2015, I had the privilege to present a couple of sessions to the SQL Server Community in Delhi-NCR region in India. During the sessions I talked about the following topics. Paul Randal’s blog around Clustered GUIDs and associated fragmentation. Bart Duncun’s blog on Row Goal Issues. On July 8, 2015.
sqluninterrupted.com
Introduction to Stretch Databases with SQL Server 2016 | SQLUNINTERRUPTED
https://sqluninterrupted.com/2015/06/21/introduction-to-stretch-databases-with-sql-server-2016
I am just a medium, SQL Server the Goal. Introduction to Stretch Databases with SQL Server 2016. Posted by Sourabh Agarwal. On June 21, 2015. Its been a long time since I have written a blog and what better way to start again than by writing about one of the most interesting features being introduced in SQL Server. In a series of blogs over the next few weeks, I will try and get into the details of how Stretch Databases are implemented and some of the inner workings of the feature to watch out for. Once ...
sqluninterrupted.com
Sourabh Agarwal | SQLUNINTERRUPTED
https://sqluninterrupted.com/author/sourabhagarwal
I am just a medium, SQL Server the Goal. SQL Community Session–Indexing Basics and Writing Optimal Queries. Posted by Sourabh Agarwal. On January 10, 2016. Back in December 2015, I had the privilege to present a couple of sessions to the SQL Server Community in Delhi-NCR region in India. During the sessions I talked about the following topics. Paul Randal’s blog around Clustered GUIDs and associated fragmentation. Bart Duncun’s blog on Row Goal Issues. Paul White blog on Distinct Aggregations. As I had m...
sqluninterrupted.com
Business Continuity and Disaster Recovery with Azure SQL Databases | SQLUNINTERRUPTED
https://sqluninterrupted.com/2015/06/26/business-continuity-and-disaster-recovery-with-azure-sql-databases
I am just a medium, SQL Server the Goal. Business Continuity and Disaster Recovery with Azure SQL Databases. Posted by Sourabh Agarwal. On June 26, 2015. Technorati Tags: Azure SQL Database. During one of the recent Azure Conference, I had talked about the Business Continuity and Disaster Recovery options available with Windows Azure SQL Databases. The presentation I used is included below. Larr; Introduction to Stretch Databases – Part Two. Leave a Reply Cancel reply. Enter your comment here. Create a f...
sqluninterrupted.com
compression | SQLUNINTERRUPTED
https://sqluninterrupted.com/tag/compression
I am just a medium, SQL Server the Goal. Zipping and Unzipping Files – The Fast and Furious Way. Posted by Sourabh Agarwal. On July 7, 2015. We tired multiple options like, calling exe’s (rar, unrar, 7-zip) from PowerShell, but that did not scale well. Eventually we settled on the .NET Compression routine (.NET 4 and above) to this. We saw overwhelming results when using .NET routines ( 13-15 times better execution speed) during compression and decompression. Compression Results using rar/7-zip. Enter yo...
sqluninterrupted.com
July | 2015 | SQLUNINTERRUPTED
https://sqluninterrupted.com/2015/07
I am just a medium, SQL Server the Goal. Monthly Archives: July 2015. Introduction to Stretch Databases – Part Three. Posted by Sourabh Agarwal. On July 8, 2015. Continuing with my earlier posts on Stretch Databases Part1. I will discuss some key aspects to keep in mind when we stretch a database. Note- SQL Server 2016 is still in preview and some of this information can change in the future. Insert, Update and Delete. Msg 3609, Level 16, State 1, Line 3. If SQL Server is not able to connect to the remot...
sqluninterrupted.com
Storage Engine | SQLUNINTERRUPTED
https://sqluninterrupted.com/category/sql-server/sql-engine/storage-engine
I am just a medium, SQL Server the Goal. Category Archives: Storage Engine. Introduction to Stretch Databases – Part Two. Posted by Sourabh Agarwal. On June 24, 2015. In my earlier post. Enabling stretch option for a table is very simple, and can be done by right clicking on the table and selecting the stretch option. The T-SQL Syntax is. Test RemoteArchive ENABLE REMOTE DATA ARCHIVE WITH. MIGRATION STATE = ON. Test RemoteArchive ENABLE REMOTE DATA ARCHIVE WITH. MIGRATION STATE = OFF. A new column (batch...
sqluninterrupted.com
decompression | SQLUNINTERRUPTED
https://sqluninterrupted.com/tag/decompression
I am just a medium, SQL Server the Goal. Zipping and Unzipping Files – The Fast and Furious Way. Posted by Sourabh Agarwal. On July 7, 2015. We tired multiple options like, calling exe’s (rar, unrar, 7-zip) from PowerShell, but that did not scale well. Eventually we settled on the .NET Compression routine (.NET 4 and above) to this. We saw overwhelming results when using .NET routines ( 13-15 times better execution speed) during compression and decompression. Compression Results using rar/7-zip. Enter yo...
sqluninterrupted.com
.Net | SQLUNINTERRUPTED
https://sqluninterrupted.com/tag/net
I am just a medium, SQL Server the Goal. Tag Archives: .Net. Zipping and Unzipping Files – The Fast and Furious Way. Posted by Sourabh Agarwal. On July 7, 2015. We tired multiple options like, calling exe’s (rar, unrar, 7-zip) from PowerShell, but that did not scale well. Eventually we settled on the .NET Compression routine (.NET 4 and above) to this. We saw overwhelming results when using .NET routines ( 13-15 times better execution speed) during compression and decompression. Uploading multiple Report...
SOCIAL ENGAGEMENT