SQL server and Java?

Posted on July 29, 2019 by blobeater

I was generally reading about SQL Server and how things have changed since the days of just having it within a Windows Eco-system only. It then led me to a cool website, SQL Server development – build an app using SQL server where you can get to see the high-level requirements of starting to build a solution based on a wide variation of languages and operating systems. https://www.microsoft.com/en-us/sql-server/developer-get-started/

There are many combinations possible with SQL Server being the back-end database of choice.

Continue reading →

Azure SQL Database Connect and Query

Posted on July 25, 2019 by blobeater

There is a lightweight and quick way to start querying your database in Azure which doesn’t involve SQL Operations Studio or Management Studio. You can use the query editor within the Azure portal, that is, if you desire.

Continue reading →

Moving Databases into Azure SQL Elastic Pools

Posted on July 22, 2019 by blobeater

Quite a simple requirement (when I needed it a few months ago). Study my Azure SQL database environment below.

Continue reading →

Azure SQL Database SLA Updates

Posted on July 19, 2019 by blobeater

I am sure many missed the updates to Azure SQL Database SLA (Service Level Agreement). It used to be 99.99% across all tiers but split between two different high-availability architectural models. Basic, Standard and General Purpose tiers had its own model and the Premium / Business Critical tiers had a different one.

Continue reading →

SQL Server 2019 Query Store And SSMS

Posted on July 17, 2019 by blobeater

While not specific to SQL Server 2019 (I was using this version to do some testing) I was struggling to find how to change the time period of analysis for the Query Store reports within SSMS.

Continue reading →