Mid-Week Update
Just a short mid-week update, David Postlethwaite has been selected to speak at SQL Saturday Vienna which is being held...
2015-01-15
597 reads
Blog Posts
SELECT INTO Improvements in SQL Server 2014 !
SQL Server 2014 is a great release with high performance features like In Memory OLTP, Updatable Column Store Indexes etc.
These features still...
2015-01-15 (first published: 2015-01-13)
10,089 reads
TSQL Tuesday #62: Invitation to Healthy SQL – Why Page Verify?
I don’t think anyone’s ever been happy to get a support call at 11pm on a Saturday night. However this...
2015-01-15 (first published: 2015-01-13)
6,304 reads
What to Expect When Transitioning from DBA to Consultant
Last week, Boris Hristov (b|t), the organizer of #SQLHangout, invited William Durkin (b|t) and me to a SQL Hangout about transitioning...
2015-01-15
543 reads
Award from MSSQLTIPS.com
Today, I am excited and humbled to learn that I am awarded “Rookie of the Year – 2014” by MSSQLTips.com.
I have...
2015-01-14
314 reads
Award from MSSQLTIPS.com
Today, I am excited and humbled to learn that I am awarded “Rookie of the Year – 2014” by MSSQLTips.com.
I have...
2015-01-14
672 reads
Excel 2013 Conditional Formatting for Columns
If you have two columns in an Excel sheet, and you want to conditionally format fields in the second column...
2015-01-14
757 reads
Execute the Current Statement–SQL Prompt
This is a great little feature in SQL Prompt that I wrote about at SQLServerCentral. It’s Current statement Execution, which...
2015-01-14
1,278 reads
HOWTO: Filter Dacpac Deployments
Updated 2015-02-02 I have changed the details about passing multiple filters at the bottom, see the codepex site for full details.
tldr; Download the filter from: https://agilesqlclub.codeplex.com/releases/view/610727 put the dll...
2015-01-14
52 reads
HOWTO: Filter Dacpac Deployments
Updated 2015-02-02 I have changed the details about passing multiple filters at the bottom, see the codepex site for full...
2015-01-14
1,235 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