Planning a High Availability and Disaster Recovery Plan in Madison, WI
I’ll be doing a precon for SQLSaturday #387 in Madison Wisconsin on April 10th, 2015 titled “Planning a High Availability and Disaster...
2015-03-19
1,186 reads
Blog Posts
SQL Server 2014 Deprecated Features
SQL Server 2014 Deprecated Features – Database Engine
Everyone looks at the new features when trying to determine when to upgrade from...
2015-03-19
2,039 reads
Stupid T-SQL Tricks – Part 2: Retrieving Columns Set to the Current DEFAULT CONSTRAINT Value
“Heeeeeere’s Johnny!” – Ed McMahon introducing Johnny Carson for the Tonight Show
If you’re old enough to remember the Tonight Show hosted...
2015-03-19
756 reads
T-SQL – How to get the Financial Quarter details of a date field
declare @table table
(
[Paid Date] date
)
insert into @table
values('20150102'),('20150512'),('20150830'),('20151231'),('20141230')
;WITH Quarters AS (
SELECT Q = 'Q1', MonthBegin = 1, MonthEnd = 3 UNION
SELECT Q = 'Q2',...
2015-03-19 (first published: 2015-03-11)
7,791 reads
24HOP Russian Edition
Spoke at 24HOP Russian edition.
Interesting experience.
It is difficult to determine mood of audience if there is no visible audience 🙂
And...
2015-03-18
582 reads
ALTER SCHEMA TO ADD PERMISSIONS
I’m sure some of you have wanted to do this:
ALTER SCHEMA Steve AUTHORIZATION Steve
You realize this doesn’t work, and you...
2015-03-18
990 reads
Can an EKM Save The World of Data? - WaterOx Consulting
Reading Time: 4 minutesQuis custodiet ipsos custodes? Who will guard the guards themselves? – Latin...
The post Can an EKM Save The...
2015-03-18 (first published: 2015-03-10)
6,963 reads
Why not NOLOCK?
Most senior DBAs I’ve met shudder when they hear NOLOCK. Ever wonder why? For the same reason they shudder at...
2015-03-18
1,228 reads
Women in Technology
Warning: rant forthcoming.
I don’t get the women in technology problem. Oh, I understand and see the problem. I also understand...
2015-03-18
471 reads
Exam Prep 70-463: SSIS Expressions
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-03-17 (first published: 2015-02-26)
8,654 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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