Video – Creating Azure SQL Database
A quick 2 minute upload (with sound, my voice) showing you how easy it is to create an Azure SQL Database using the Azure portal and then using SSMS...
2019-04-23
32 reads
Arun Sirpal
Scaling SQL Elastic Pools
There are a few ways to scale a SQL elastic pool. For this blog post I show you how to scale up. It can be done via the Azure...
2019-04-15
53 reads
Tuning Azure SQL Elastic Pools
The below image is a beautiful picture, now it could be worse. The red line and the green line could peak at the same time and for a very...
2019-04-11
149 reads
SQL Server 2019 Suspend/Resume TDE
Yes, a really nice new shiny feature where we have the ability to suspend and resume the encryption scan for TDE – Transparent Data Encryption which is available in...
2019-04-02
152 reads
New Improved Azure Elastic Jobs
There is a new way to setup Azure elastic jobs to run against a target group of databases (targeting an elastic pool). I actually found the process quite messy...
2019-03-27
16 reads
Sizing your Azure SQL Database
Do you want to identify the correct Service Tier and Compute Size ( was once known as performance level) for your...
2019-03-20
656 reads
SQL Server – max server memory
Another re-post of a video from last year, this time showing you an in-built protection of setting max server memory...
2019-03-14
479 reads
SQL Server Deadlocks
A quick video clip showing how to create a deadlock in SQL Server and find information about it.
2019-03-13
1,112 reads
T-SQL Tuesday Sharing Cookies
It has been a while since I have participated in a T-SQL Tuesday but I felt the urge to do...
2019-03-12
420 reads
Azure SQL Data Warehouse Query Store
I personally think that query store has been a fantastic feature. I find myself using it for query performance troubleshooting...
2019-03-05
615 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
WHERE condition using ='value' returns different results that using IN('value')
Have an interesting scenario - user found a discrepancy with rows returned when running...
Complex Query (Multiple Tables & Joins) - Need to Restrict to Max Date
I am using the query listed below. USE GAGETRAK_26237 SELECT G.Gage_ID 'ID', G.Model_No 'Model',...
Unknown Token Received From SQL Server
I have an issue when a stored procedure is executed from the SQL Server...