Azure SQL DB VS SQL Server For the DBA
Being the start of the new year and with new projects most likely starting again I would like to share...
2019-01-07
299 reads
Being the start of the new year and with new projects most likely starting again I would like to share...
2019-01-07
299 reads
Once again I would like to share with you an article I wrote about backing up (and restoring) a SQL...
2019-01-01 (first published: 2018-12-19)
2,732 reads
I wrote a guest article for an IT consultancy on Azure SQL Database, more specifically DTUs and vCore options. At...
2018-12-17
869 reads
Sometimes I like to see and know what SQL server is doing under certain operations and recently I wrote an...
2018-12-11
219 reads
I would like to share a link to my Azure SQL Database Stairway series hosted over at SQLServerCentral. As stated...
2018-12-06
448 reads
If you decide to use IP addresses to control what services have access to your Azure SQL Database, then understanding...
2018-12-04
223 reads
When learning new technologies many people will go towards training courses (in person or online) but many also go for...
2018-11-15
255 reads
This is kind of a follow up from my last blog post about a scale down request issue. (https://blobeater.blog/2018/11/07/azure-sql-database-aborting-scale-request/) I...
2018-11-14
219 reads
Scaling up or down an Azure SQL Database is a very common task. Whilst common it is also very easy...
2018-11-07
280 reads
One of the features Microsoft wants us to use for Azure SQL Database is Automatic Tuning. Automatic Tuning is a...
2018-11-01
286 reads
By Steve Jones
One of the things that many DBAs struggle with is managing space across an...
I'm excited to tell you about the "SQL from A to Z" learning track....
The post Introduction to Advanced Analytics appeared first on Joyful Craftsmen.
Comments posted to this topic are about the item The Cloud Security Problem, which...
Thanks in Advance! I'm having trouble grouping all counts and sums on one line...
I have a table like below ID Ident source val opendate closedate IsActive --------------------------------------------------------...
In SQL Server 2022, what does this statement do?
CREATE STATISTICS CustomerStats1 ON DimCustomer (CustomerKey, EmailAddress) WITH AUTO_DROP = ONSee possible answers