Use cases of various products for a big data cloud solution
There are a tremendous amount of Microsoft products that are cloud-based for building big data solutions. It’s great that there...
2017-10-11
2,411 reads
James Serra's Blog
What’s new in SQL Server 2017 presentation
I just uploaded a new presentation called “What’s new in SQL Server 2017”. It covers all the new features in...
2017-10-06
741 reads
Microsoft Ignite Announcements
Many product announcements were made this week at Microsoft Ignite, and I wanted to give a quick overview of all...
2017-09-28
948 reads
Distributed Writes
In SQL Server, scaling out reads (i.e. using Active secondary replicas via AlwaysOn Availability Groups) is a lot easier than scaling out...
2017-09-21
730 reads
Azure Archive Blob Storage
Last week Microsoft released a public preview of a new service called Azure Archive Blob Storage, offering customers a lower-cost...
2017-08-31
1,031 reads
Data Virtualization vs Data Warehouse
Data virtualization goes by a lot of different names: logical data warehouse, data federation, virtual database, and decentralized data warehouse....
2017-08-24
903 reads
Microsoft Big Data Certification Exams
I previously blogged about Microsoft certification changes, and since then there have been some new Microsoft Big Data certifications exams released:
Already...
2017-08-08
682 reads
Azure Analysis Services web designer
Microsoft has released a preview of the Azure Analysis Services web designer. This is a browser-based experience that will allow...
2017-08-02
678 reads
Azure SQL Data Sync 2.0
Azure SQL Data Sync has been ignored for quite some time, but has finally gotten an update (it’s in public...
2017-07-20
588 reads
4TB disk sizes for Azure IaaS VMs available
Microsoft has introduced two new disk sizes for Azure IaaS VMs in P40 (2TB) and P50 (4TB) for both managed...
2017-07-07
1,026 reads
Blogs
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...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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