SQL server and Java?
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...
2019-07-29
84 reads
Arun Sirpal
Azure SQL Database Connect and Query
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...
2019-07-25
17 reads
Moving Databases into Azure SQL Elastic Pools
Quite a simple requirement (when I needed it a few months ago). Study my Azure SQL database environment below. As you can see I have a standard elastic pool...
2019-07-22
30 reads
Azure SQL Database SLA Updates
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...
2019-07-19
210 reads
Connecting - Level 4 of the Stairway to Azure SQL Database
Learn how to configure connectivity and firewall rules for your Azure SQL Database
2019-07-17 (first published: 2018-09-26)
3,050 reads
SQL Server 2019 Query Store And SSMS
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...
2019-07-17
27 reads
Azure SQL Elastic Jobs
The purpose of an Elastic Job is to execute a T-SQL script that is scheduled or executed ad-hoc against a group of Azure SQL databases. Targets can be in...
2019-07-11
179 reads
Microsoft MVP #2
It is always a dark art trying to suss out why he/she is an MVP? Do they deserve it? What does it take? Why can’t I get it? The...
2019-07-05
22 reads
Azure Cosmos DB – Graph DB
Using Graph DB is a good way to show relationships between entities (more specifically a vertex and edges). This is why you would use this approach over classic SQL...
2019-06-24
19 reads
Azure SQL DB Maxdop Hint
I had a good question from JP via a comment on my blog about whether you can use the MAXDOP query hint in Azure SQL Database. The answer? Yes....
2019-06-24
25 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers