Azure SQL Database and Columnstore Indexes
I have come to understand the importance of using columnstore indexes when my queries are aggregating and scanning across many...
2018-04-19 (first published: 2018-04-09)
2,200 reads
Arun Sirpal
4 Improvements to Azure SQL Database
If I was a wizard I would make these 4 improvements to Azure SQL Database. They are in no particular...
2018-04-12 (first published: 2018-04-05)
2,181 reads
Azure SQL DW – Let’s Shuffle?
Initially, the main focus of this post was going to be quick and about using the latest version of SSMS...
2018-04-12
874 reads
Azure SQL Database – Failed to Delete Database Nightmare
After demo building and testing features out within Azure SQL Database I like to delete the databases to save costs....
2018-04-03
371 reads
Database Has Been Paused
I was looking forward to do some work with Azure SQL Data Warehouse (DWH) when I hit the new query...
2018-04-03 (first published: 2018-03-27)
3,463 reads
Azure SQL Database and Cost Threshold for Parallelism
We all know that the magic figure for cost threshold for parallelism is 5 by default, meaning if the estimated...
2018-03-26 (first published: 2018-03-16)
2,325 reads
Backup and Restore Options for Azure SQL DB
I have decided to do a summary blog post on backup and recovery options for Azure SQL Database. If you...
2018-03-26
579 reads
SQL Vulnerability Assessment for Azure SQL Database
Back in September 2017 Microsoft announced a new security feature for Azure SQL Database called the SQL Vulnerability Assessment (VA)....
2018-03-22
996 reads
Understanding DBCC FLUSHAUTHCACHE
This command only applies to Azure SQL Database, at a high level it empties the database authentication cache for logins...
2018-03-14
732 reads
Azure SQL Database – Allow Azure Services to Access Server
When you create a “logical” Azure SQL Server (I say logical because we are not really physically creating anything) there...
2018-03-09 (first published: 2018-03-01)
2,486 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers