Azure SQL Database Script for Size
Sometimes you may not want to flip over to the Azure portal to grab the database size, such as the used space below. So here is a handy script...
2019-08-12
25 reads
Blog Posts
Execution Plans: Statistics
Watch this week’s Statistics video on YouTube. Last week we looked at what execution plans are and how you can view them. This week I want to discuss what data...
2019-08-12 (first published: 2019-07-30)
695 reads
Information Measurement with SQL Server Part 4.6: The Jaccard Distance and Its Relatives
By Steve Bolton …………Over the course of this inexpert exploration of the distance measures used for such data mining applications as clustering, we’ve gradually introduced a system of classification...
2019-08-12 (first published: 2019-07-29)
580 reads
sp_RestoreScript 1.5 Release
We’ve released sp_RestoreScript 1.5. This is only a minor release but adds the type of the backup file to the output. You can grab the latest version from our...
2019-08-12
16 reads
Azure SQL Database Elastic Scale Part 1 - What is Sharding?
Azure SQL Database Elastic Scale Part 1 - What is Sharding?MARCH 19, 2015
This week, Microsoft introduced an update to Azure SQL...
2019-08-09 (first published: 2015-03-19)
15,600 reads
Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards
Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the ShardsMAY 28, 2015
For those of you who have...
2019-08-09 (first published: 2015-05-28)
4,113 reads
Dynamic Data Masking
Dynamic Data MaskingFEBRUARY 26, 2015
Have you ever wanted to only show parts of a field to certain sets of users...
2019-08-09 (first published: 2015-02-26)
8,871 reads
Fantasy Football - A League of Our Own - Want to Play?
It feels daft me saying the football season is only 9 days away, when in fact The Ashes cricket series is only starting today at Edgbaston. The Ashes are...
2019-08-09 (first published: 2019-08-01)
338 reads
Index Fragmentation in Azure SQL Database
Index Fragmentation in Azure SQL DatabaseFEBRUARY 4, 2015
Recently, I read the articles Stop Worrying About SQL Server Fragmentationand When Does...
2019-08-09 (first published: 2015-02-03)
13,516 reads
Life Support 2008 – Audit Logons
Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance.
Related...
2019-08-09 (first published: 2019-07-17)
271 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers