Azure SQL Database Script for Size
Sometimes you may not want to flip over to the Azure portal to grab the database size, such as the used space below. So here is a handy script...
2019-08-12
19 reads
Arun Sirpal
Microsoft Azure and Oracle Cloud
Microsoft and Oracle recently announced a joint cloud partnership (I have seen the word multi/cross-cloud to explain this) which I found very fascinating to read. It is currently in...
2019-08-07
23 reads
Azure SQL Database Clustered Columnstore Index
You can read about columnstore indexes here (https://azure.microsoft.com/en-gb/blog/transforming-your-data-in-azure-sql-database-to-columnstore-format/). I won’t rehash the material but high level, these index types are optimized for analytical queries and high compression of data...
2019-08-06
154 reads
SQL Server Management Studio
Hopefully you know that SSMS is a separate install from the main SQL Server install. You can find the binaries from Microsoft (https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms) Using SSMS version 18.2, whilst playing...
2019-08-01
74 reads
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
80 reads
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
14 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
22 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
204 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,013 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
25 reads
Blogs
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...
Monday Monitor Tips: Lots of Postgres Options
By Steve Jones
Redgate Monitor is growing to include more than just Microsoft SQL Server monitoring. We...
Forums
Hash Joins IV
Comments posted to this topic are about the item Hash Joins IV
How to Load a Fabric Warehouse: Data Engineering with Fabric
Comments posted to this topic are about the item How to Load a Fabric...
Adding the Right Value
Comments posted to this topic are about the item Adding the Right Value