New Azure storage account type
In Azure, there previously has been only one kind of storage account, which is now called a “General Purpose” storage...
2016-05-04
1,076 reads
James Serra's Blog
SQL Server 2016 available June 1st!
Woo hoo! Microsoft has announced that SQL Server 2016 will be generally available on June 1st. On that date all four...
2016-05-02
657 reads
Big Data architectures
Over the last few years I have been involved in reviewing the architectures of various companies that are building or have...
2016-05-12 (first published: 2016-04-29)
3,119 reads
Azure SQL Database pricing
Pricing Azure SQL database is difficult because various database service tier options such as database transaction units (DTU’s), max database size,...
2016-04-22
2,183 reads
Analytics Platform System (APS) AU5 released
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU5),...
2016-04-14
868 reads
Scaling Azure VM’s
There are so many benefits to the cloud, but one of the major features is the ease of use in...
2016-04-05
657 reads
My latest presentations
I frequently present at user groups, and always try to create a brand new presentation to keep things interesting. We...
2016-03-29
911 reads
Data loading into Azure SQL Data Warehouse
Azure SQL Data Warehouse (SQL DW) is a new platform-as-a service (PaaS) that distributes workloads across multiple compute resources, called massively parallel processing (MPP)....
2016-03-23
603 reads
Microsoft Azure Government
I’m sure you are aware of Microsoft Azure, but are you aware there is special version of Azure for U.S....
2016-03-15
700 reads
SQL Server on Linux!
Looks outside: pigs are flying!
In an announcement yesterday, SQL Server will be made available on Linux. The private preview of...
2016-03-08
905 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