Data gateway confusion
Microsoft has created data gateways as a way that cloud products such as Power BI and Azure Machine Learning can...
2016-12-21
417 reads
James Serra's Blog
What is HTAP?
I have been seeing the term “HTAP” mentioned a lot recently, and I thought I would briefly explain the term....
2016-12-14
324 reads
Total Cost of Ownership (TCO) Calculator
For a long time clients would ask me how to determine the cost savings by migrating their applications and databases...
2016-12-06
1,229 reads
Azure Advisor
Azure Advisor is a really cool personalized recommendation engine that provides you with proactive best practices guidance on High Availability,...
2016-12-01
314 reads
Analytics Platform System 2016 Release
Microsoft has a new release for the Analytics Platform System (APS). This appliance update is called APS 2016 and has...
2016-11-29
520 reads
PASS Summit Announcements: PolyBase enhancements
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. I’m writing a set...
2016-11-22
271 reads
Microsoft Connect(); announcements
Microsoft Connect(); is a developer event from Nov 16-18, where plenty of announcements are made. Here is a summary of the...
2016-11-17
618 reads
PASS Summit Announcements: Microsoft Professional Program for Big Data
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. I’m writing a set...
2016-11-15
1,093 reads
Azure SQL Server 2016 VM
With Windows Server 2016 just been released, now is the perfect time to build an Azure VM with SQL Server...
2016-11-10
997 reads
PASS Summit Announcements: SQL DW free trial
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. I’m writing a set...
2016-11-08
513 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