Azure SQL Database and Trace Flags
You cannot enable trace flags (globally or by session) within Azure SQL Database but did you know that some global...
2019-02-26
596 reads
Arun Sirpal
Azure SQL Database Online Columnstore Unicorn and Rainbow Theory
As Microsoft states “online clustered columnstore index build enables you to optimize and compress your data with minimal downtime without...
2019-02-21
178 reads
Azure SQL Database and Transaction Log
Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know...
2019-02-13
183 reads
Automating T-SQL for Azure SQL Database via Logic Apps
Have you ever wanted to capture the T-SQL, waits, sessions IDs (etc) at a specific time for Azure SQL Database?...
2019-02-06
221 reads
SQL Server Looking into Differential Backups
I seem to be writing solely about Azure so to shake things up a bit I am going back to...
2019-02-05
178 reads
Classify your Azure SQL Database
Here I am talking about SQL Data Discovery & Classification feature that is built into Azure SQL Database. With this feature you...
2019-02-04
186 reads
Azure SQL Database Roadmap
I do not usually link straight to other blog posts or technical papers but I really had to with this...
2019-01-24
302 reads
Azure SQL Database and Transaction Log
Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know...
2019-01-23
1,342 reads
Azure SQL Database – Reduce the workload before initiating another service objective update
Getting straight to the point, I initiated a very common task recently, another scale up request. However, a new message...
2019-01-21
230 reads
Moving off SQL Server 2008 / R2 – What can Azure offer?
You will very likely know that SQL Server 2008 / R2 end of support is on July 9th 2019. Not that...
2019-01-15
242 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
Count of Total Appointments within 30 days of each Appointment Date
Good Afternoon. I have a Table where each Record: 1) Represents an Appointment. 2)...
Reporting Services in Managed Instance
Hi , one of my on-premises servers one server is having databases and one...
EXTENDED EVENTS Track What's Logging In
Simple one looking for a script that can track what's logging in from where...