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
18 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
73 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
21 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,003 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
Monday Monitor Tips: Projecting Disk Space
By Steve Jones
One of the things that many DBAs struggle with is managing space across an...
SQL from A to Z: Your Path to SQL Mastery this Fall
I'm excited to tell you about the "SQL from A to Z" learning track....
Introduction to Advanced Analytics
The post Introduction to Advanced Analytics appeared first on Joyful Craftsmen.
Forums
The Cloud Security Problem
Comments posted to this topic are about the item The Cloud Security Problem, which...
Merge rows in SQL
I have a table like below ID Ident source val opendate closedate IsActive --------------------------------------------------------...
Blocking Connection to Server
Good Afternoon, We recently procured a service management software for our company, which uses...
Question of the Day
AUTO_DROP Statistics
In SQL Server 2022, what does this statement do?
CREATE STATISTICS CustomerStats1 ON DimCustomer (CustomerKey, EmailAddress) WITH AUTO_DROP = ONSee possible answers