Azure SQL Database vs SQL Data Warehouse
I am sometimes asked to compare Azure SQL Database (SQL DB) to Azure SQL Data Warehouse (SQL DW). The most important...
2016-08-17 (first published: 2016-08-10)
1,934 reads
James Serra's Blog
What is the Lambda Architecture?
Lambda architecture is a data-processing architecture designed to handle massive quantities of data (i.e. “Big Data”) by using both batch-processing and...
2016-08-08 (first published: 2016-08-05)
3,231 reads
Multi-tenant databases in the cloud
For companies that sell an on-prem software solution and are looking to move that solution to the cloud, a challenge...
2016-07-20
1,177 reads
Azure SQL Data Warehouse is now GA
The Azure SQL Data Warehouse (SQL DW), that I blogged about here, is now generally available. Here is the official...
2016-07-13
586 reads
Virtualization does not equal a private cloud
I see a lot of confusion when it comes to creating a private cloud. Many seem to think that by...
2016-07-07
1,354 reads
Azure SQL Data Warehouse pricing
The pricing for Azure SQL Data Warehouse (SQL DW) consists of a compute charge and a storage charge. For compute, it is...
2016-06-23
890 reads
SQL Server 2016 is here!
Today is the day: SQL Server 2016 is available for download! You can download all the versions (enterprise, standard, web,...
2016-06-01
967 reads
Azure Storage pricing
Azure storage is a great, inexpensive solution for storing your data in the cloud. There are many types of Azure...
2016-05-25
936 reads
Migrate from on-prem SQL server to Azure VM IaaS
Hopefully you went through my presentations Should I move my database to the cloud?, Introducing Azure SQL Database and Implement SQL Server on an...
2016-05-26 (first published: 2016-05-18)
3,178 reads
Azure Speed Testing
Have you ever wondered what Azure region would be the fastest to host your applications when those applications are accessed from your...
2016-05-11
1,546 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