Opinions, tips, and news orbiting Microsoft
First published on MSDN on Jan 29, 2017
Reviewed by: Mike Weiner, Murshed Zaman
A fundamental part of ensuring application resiliency to failures is being able to tell if the application database(s) are available at any … Continue reading How to Check Database Availability from the Application Tier
First published on MSDN on Dec 20, 2016
Authored by Murshed Zaman
Reviewers: Dimitri Furman, John Hoang, Mike Weiner, Denzil Ribeiro, Joe Yong
Background:
Azure SQL Data Warehouse service (SQL DW) uses a … Continue reading Azure SQL DW: Moving to a different region with restore from backup option
First published on MSDN on Dec 08, 2016
Reviewed by
: Dimitri Furman,Sanjay Mishra, Mike Weiner
With the introduction of the
Temporal
feature in SQL 2016 and Azure SQL Database, there is an ability to time t… Continue reading Improve query performance on memory optimized tables with Temporal using new index creation enhancement in SP1
First published on MSDN on Nov 10, 2016
Reviewed by: Kun Cheng, John Hoang, Sanjay Mishra, Borko Novakovic, Denzil Ribeiro, Murshed Zaman
Have you ever got that sinking feeling after hitting the Execute button in S… Continue reading Oops Recovery with Temporal Tables
First published on MSDN on Oct 20, 2016
Reviewed by: Steven Green, Peng Song, Xiaochen Wu, Kun Cheng, Sanjay Mishra
Introduction
Database migration from SQL Server to Azure SQL Database is a process that many or… Continue reading Migrating from SQL Server to Azure SQL Database using Bacpac Files
First published on MSDN on Oct 20, 2016
Reviewed by: Sanjay Mishra, Umachandar Jayachandran, Dimitri Furman, Jeannine Nelson-Takaki, Joe Sack, Kun Cheng, Eric Burgess
One of the most exciting features in SQL Server 2016 … Continue reading Do it right! Deploying SQL Server R Services on computers without Internet access
First published on MSDN on Oct 19, 2016
Authored by Sanjay Mishra
Sanjay Mishra
Reviewed By: Dimitri Furman, Murshed Zaman, Kun Cheng
If you have tried to use BULK INSERT or bcp … Continue reading SQLSweet16!, Episode 10: “I can eat glass …”, but can I load it into a database?
First published on MSDN on Oct 13, 2016
Authored by Sanjay Mishra
Are you coming to the
PASS Summit 2016
in Seattle? SQLCAT will be in full force at the PASS Summit 2016, and we will also bring along our… Continue reading SQLCAT @PASS Summit 2016