SQL Server News–29th March 2016
This past weekend is one of my favourite holiday weekends - the 4 day Easter weekend 🙂 Although I have had to...
2016-03-29
610 reads
Blog Posts
SQL Server Service Broker – Service Architecture
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging...
2016-03-29
1,094 reads
SQLBits in Space
It’s coming in May. The official UK SQL Server 2016 launch event is SQL Bits and the conference returns to...
2016-03-29 (first published: 2016-03-22)
1,396 reads
Talking about the Query Store at SQLBits!
From the 4th till the 7th of May 2016 one of the biggest SQL Server conference in the world will...
2016-03-29
765 reads
Cross Database Query in Azure SQL Database
You can’t query across databases in Azure SQL Database… or can you?
Let’s check. I’ve created two new databases on an...
2016-03-28 (first published: 2016-03-21)
3,118 reads
Notes from the March 2016 oPASS Meeting
Quick notes:
Chinese food instead of pizza (thanks Shawn!)The wine bar is doing some remodeling to make better use of the...
2016-03-28
593 reads
Recertification, too easy?
3 years I was awarded the MCSE: Data Platform certification and as per the recertification rules, I needed to recertify...
2016-03-28 (first published: 2016-03-21)
1,793 reads
SQL Nexus in Copenhagen
The Nordic SQLNexus conference is taking place in Copenhagen on May 2-4. I’ve never been to the event, or the...
2016-03-28
592 reads
Why I Love #SQLSaturday
PASS SQLSaturdays are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of...
2016-03-28
471 reads
Why you shouldn’t use SELECT *
I answered an interesting question on SE today (ever notice how many posts come from stuff I read on forums?)...
2016-03-28
505 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