Query Store for Azure PostgreSQL
Query Store is not just for Microsoft SQL Server and Azure SQL Database anymore. Microsoft announced back in Oct 2018...
2019-03-12
365 reads
Query Store is not just for Microsoft SQL Server and Azure SQL Database anymore. Microsoft announced back in Oct 2018...
2019-03-12
365 reads
Query Store is not just for Microsoft SQL Server and Azure SQL Database anymore. Microsoft announced back in Oct 2018 that Query Store was available in Public Preview for...
2019-03-12
9 reads
I am very proud and happy to be a Friend of Redgate for a ninth year! I had to ask Redgate when...
2019-01-26
202 reads
Additional vCore-based elastic pools and single databases have been expanded for the general purpose, business critical, and hyperscale service tiers....
2019-01-10
171 reads
The business critical tier for Azure SQL Database Managed Instance is now available. Customers needing a higher level of high...
2018-12-04
37 reads
As of October 2018, Azure SQL Database Managed Instance is now generally available in the general purpose tier. Business Critical...
2018-10-03
48 reads
I am very excited about my upcoming IEAzure class being held in London, September 10th and 11th at the Marriott in Kensington (London).
This...
2018-08-08
356 reads
I am a little late in posting this, but I still wanted to share. It is a huge honor to...
2018-08-08
350 reads
This month’s T-SQL Tuesday from Riley Major (b|t) asks us to figure out a way to give back to the...
2018-05-08
397 reads
Azure SQL Database Managed Instance is bridging the gap between 0n-premises SQL Server and Azure SQL Database. Azure SQL Database...
2018-03-31
727 reads
By Steve Jones
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...
By Steve Jones
Life gets better as you replace transactions with relationships. – from Excellent Advice for...
I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...
At NXG Electrical, our seasoned professionals provide effortless heating, ventilation, and air conditioning services...
Comments posted to this topic are about the item Understanding Bit Manipulation Functions: BIT_COUNT,...
Comments posted to this topic are about the item Mixed Backups
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex] FILE = N'thirdone' , FILE = N'thirdtwo' , FILEGROUP = N'second' TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GOSee possible answers