Most important feature of SQL 2014
There are a whole raft of cool new features in 2014 including things like In-Memory OLTP, increased Azure integration/options and...
2014-04-29
1,640 reads
Blog Posts
Speaking At the Pinellas SQL Group on August 18, 2014
I’ve committed to presenting but haven’t decided on the presentation yet. It will probably be a remote presentation because it’s...
2014-04-29
1,268 reads
SQL Server Quickie #13 – Hash Join Operator
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-04-29
1,823 reads
Team-based Database Development: Playing Nice With Others
Here are the slides and links to awesome resources for my presentation, “Team-based Database Development: Playing Nice With Others”
If you...
2014-04-29
2,650 reads
What is a Non-Clustered Columnstore Index?
First introduced in SQL Server 2012, the Columnstore index is a new in-memory feature that allows for the creation of...
2014-04-29
5,580 reads
[SQL Snacks Video] SQL Server Table Partitioning 103
Welcome back for part 3 of my SQL Snack Pack on Table Partitioning! If you have not watched the first two...
2014-04-28
932 reads
Central Management Studio CMS
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-28 (first published: 2014-04-21)
1,971 reads
How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ?
Steps : How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ?
1) Open SQL Server Installation...
2014-04-28
775 reads
Last Weeks Top “Reading” Links #81
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-04-28
649 reads
PowerShell-Input-Validation Scripts
Input values are validated using various mechanisms. let’s start by examining how you would validate input parameters in Windows PowerShell...
2014-04-28
2,001 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