Azure SQL Database and Trace Flags
You cannot enable trace flags (globally or by session) within Azure SQL Database but did you know that some global...
2019-02-26
594 reads
You cannot enable trace flags (globally or by session) within Azure SQL Database but did you know that some global...
2019-02-26
594 reads
As Microsoft states “online clustered columnstore index build enables you to optimize and compress your data with minimal downtime without...
2019-02-21
177 reads
Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know...
2019-02-13
183 reads
Have you ever wanted to capture the T-SQL, waits, sessions IDs (etc) at a specific time for Azure SQL Database?...
2019-02-06
221 reads
I seem to be writing solely about Azure so to shake things up a bit I am going back to...
2019-02-05
177 reads
Here I am talking about SQL Data Discovery & Classification feature that is built into Azure SQL Database. With this feature you...
2019-02-04
186 reads
I do not usually link straight to other blog posts or technical papers but I really had to with this...
2019-01-24
301 reads
Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know...
2019-01-23
1,331 reads
Getting straight to the point, I initiated a very common task recently, another scale up request. However, a new message...
2019-01-21
230 reads
You will very likely know that SQL Server 2008 / R2 end of support is on July 9th 2019. Not that...
2019-01-15
242 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