Deleting Azure SQL DB
So you want to do a clean-up exercise in Azure and remove some databases. You go to delete a database...
2018-08-28
224 reads
All About SQL
My Azure SQL Database Elastic Job is Broken!
I use elastic pools. They are a fabulous way of saving money when running many Azure SQL Databases, that is...
2018-08-23
322 reads
The Good The Bad and The SLA
Lets just get straight to the point, Azure SQL Database across all service tiers gives you the customer a SLA...
2018-08-20
255 reads
SQL Reserved vCores
Have you ever heard of SQL Reserved vCores? Well I never until recently. With this concept you have the ability...
2018-08-16
339 reads
Azure SQL DW – Query Labels
Using a query label in Azure SQL DW (Data Warehouse) can be a really handy technique to track queries via...
2018-08-14
354 reads
Azure SQL Data Warehouse and Backups
Just because the cloud movement is strong doesn’t mean the end of “DBA’s”, it does mean a change in skills...
2018-08-07
403 reads
SQL Server – Blocking a Truncate
The truncate option is fast and efficient but did you know that it takes a certain lock where you could...
2018-07-31
544 reads
PsPing your Azure SQL Server
PsPing tool is part of the sysinternals PsTools download found – ( https://docs.microsoft.com/en-us/sysinternals/downloads/psping) This is the tool of choice when wanting to...
2018-07-23
643 reads
SQL Agent for Azure SQL Database? Not quite
The following post shows my preferred way to automate / schedule some code against my Azure SQL Database. No it is...
2018-07-16 (first published: 2018-07-09)
2,387 reads
Azure SQL Elastic Pools – Moving Databases
If you read official Microsoft documentation about naming conventions for your SQL elastic pools, it is hard to find any...
2018-07-09 (first published: 2018-07-02)
1,942 reads
Blogs
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Forums
Automating Export of PowerQuery to SQL Server using DAX Studio...?
I wrote a PowerQuery that parses a table from a PDF, and I want...
Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.
Comments posted to this topic are about the item Attaching an SQL Server database...
Superseded Indexes
Comments posted to this topic are about the item Superseded Indexes
Question of the Day
Superseded Indexes
Which of these indexes is superseded by another?
See possible answers