Early technical preview of JDBC 6.3.1 for SQL Server released!

We are delighted to release a new early technical preview of the JDBC Driver for SQL Server.  Precompiled binaries are available on GitHub and also on Maven Central. Below is a summary of the new additions to the project, changes made, and issues fixed. Added Added support for datetime/smallDatetime in TVP #435 Added more Junit…


SQL Server to Azure SQL Database data movement options and considerations with changing schemas and triggered refreshes

In this post we will look at the problem where we need to move the data at irregular intervals from an on-premise SQL instance with a constantly changing schema to an Azure SQL database. While there many different options in terms of performance and complexity we will look at some of the more common options…


Early technical preview of JDBC 6.3.0 for SQL Server released!

We are delighted to release a new early technical preview of the JDBC Driver for SQL Server. This preview release addresses issues found in the Prepared Statement improvements and adding support for sql_variant data type. Precompiled binaries are available on GitHub and also on Maven Central. Below is a summary of the new additions to…


Announcing the JDBC 6.2 RTW!

We are pleased to announce the full release of the Microsoft JDBC Driver 6.2 for SQL Server. The RTW release rolls up all new functionality and bug fixes released in preview releases 6.1.1 to 6.1.7. The 6.2 RTW introduces support for: Azure Active Directory (AAD) on Linux Federal Information Processing Standard (FIPS) enabled Java virtual…


When is the Best Day to See Your Favorite Baseball Team?

Hello Dear Reader!  Continuing on our focus of real data, last year Josh Luedeman (@JoshLuedeman) were trying to figure out this exact problem.  How could we find real, free, and very cool data?  Enter RetroSheet.org. RetroSheet is a team of volunteers that have managed to salvage the play by play data for every game of baseball from…


Spider-Man Homecoming Twitter Sentiment

Hello Dear Reader!  This past Thursday night I took my son Zachary to see Spider-Man Homecoming, it was an amazing movie with a fantastic cast.  Both of us are BIG comic book guys, and we enjoyed it immensely.  As a matter of fact we both enjoyed it so much that I couldn’t help but wonder…


“What are you waiting for?” – Introducing wait stats support in Query Store

Troubleshooting waits previously. Nobody likes to wait. SQL database is multithreaded system that can handle thousands of queries executed simultaneously. Since queries that are executed in parallel compete for the same resources (tables, memory, etc) they might need to wait for the resources to be available to proceed with execution. These cumulative waits can be…


Cloud SOLID Part I: Cloud Architecture and the Single Responsibility Principle

Authored by Casey Watson. Edited by RoAnn Corbisier. Reviewed by Rick Rainey and Kirk Evans. This article is also available as a Whitepaper PDF download on Azure.com: Whitepaper Download What is SOLID? First introduced in 2003 by Robert “Uncle Bob” Martin, SOLID principles are a set of prescriptive guidelines that, when followed, can help developers write code…


Azure SQL databases in logical servers, elastic pools, and managed instances

Azure SQL Database is a Database as a Platform service designed for applications that will use database as self-contained service. Databases can be grouped together to simplify management options or share the resources. There are different options that can be used to bound databases in the groups, which will be explained in this post.


Exported database from Azure SQL failed to be imported to Azure SQL or to local SQL Server

Symptoms:  When using blob auditing on Azure SQL Server or Database, after you export database to .bacpac file if you import the database to another Azure SQL DB that already have blob auditing enabled at the server level you may get this error message: Could not import package. Error SQL72014: .Net SqlClient Data Provider: Msg…