Microsoft certification changes
A recent Microsoft blog post announced that they are releasing five new Microsoft Certified Solutions Expert (MCSE) and Developer (MCSD) specialties. ...
2016-10-05
768 reads
Blog Posts
MOSL – Memory Optimised Scripts Library
SQL Server 2014 was one amazing release, which had a very interesting codename – “Hekaton”, meaning that the principal news in...
2016-10-05
537 reads
Notes about Postponing SQLSaturday Orlando Due to the Hurricane
We’ve been monitoring the weather all week, thinking that today was the day we had to decide. We didn’t want...
2016-10-05
421 reads
Overview of Published Articles – 2016Q3
Here is an overview of the articles I published in the third quarter of 2016.
What’s New in SQL Server Integration Services...
2016-10-05
523 reads
SQL Live Health Check - part 2 - historical data and configuation
In the previous post (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2016/09/30/say-hello-to-sql-live-health-check-part-1/) I talk about the main screen where you can have a single glance of the...
2016-10-05
1,307 reads
Studying Failures
Over the weekend, I went to the local theater to watch Sully, the movie about the US Airways pilot who...
2016-10-05 (first published: 2016-09-26)
1,312 reads
This Week In Data – Episode 7 (The Importance of Data Testing)
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-10-05
440 reads
Understanding the new MAXDOP settings in SQL 2016
If you have just begun using SQL Server 2016 or you have been using it for a while now you...
2016-10-05
3,087 reads
Where Do We Go To Share?
No one reads blogs any more.
Twitter is dying.
Facebook is broken.
LinkedIn? Please.
G+. Is that even on any more?
Where do we go...
2016-10-05
478 reads
Yup, @StrateSQL’s Running for the PASS Board of Directors
Why I’m Running
Over the past few years, I’ve been considering running for the PASS Board of Directors and this year appears...
2016-10-05
886 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
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...
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