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
Blog Posts
SQL 2016 – Dynamic Data Masking
One of the new features that’s coming with SQL Server 2016 is Dynamic Data Masking. DDM is designed to allow...
2016-04-22 (first published: 2016-04-13)
2,133 reads
SQL Server 2016 – It just runs faster SQL Server Engineer Blog Post Overview
In March the CSS SQL Server Engineers started to blog about various new enhancements made to the SQL Server Engine...
2016-04-22 (first published: 2016-04-13)
3,045 reads
Upcoming Webinars
Next week I am participating in two exciting webinars that I want to share with you!
Improve App Uptime: Tips from MVP...
2016-04-22
528 reads
Broken Left Join
Here is a simple example of a LEFT JOIN that returns the sales stats for all employees under 21.
SELECT e.Name,...
2016-04-21
571 reads
Cardinality Estimator - Part 2- Out of Date Statistics
Continuing from our series on Cardinality Estimator 2014, Let us look at the first difference between 2 CE models. The...
2016-04-21 (first published: 2016-04-12)
2,009 reads
Columnstore Indexes: Finally Awesome in SQL 2016
Columnstore indexes are amazing for optimizing the performance of large rowcount queries that would otherwise look like a SCAN operation in...
2016-04-21
648 reads
How Long Did That Job Run?
When you use the msdb tables to try to gather information on your SQL Server Agent jobs, inevitably you will...
2016-04-21 (first published: 2016-04-14)
4,208 reads
How Two PASS Chapters Join Forces to Run One SQLSaturday In Orlando
We’re lucky enough to have two PASS chapters here in Orlando, oPASS and MagicPASS. Both in Orlando, but about 40...
2016-04-21
552 reads
Loading Data into Clustered Columnstore Index with SSIS
I’m using a clustered columnstore index (CCI) on one of my fact tables at a client. The row size is...
2016-04-21
1,836 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