A pattern to match correctly on a value or a NULL
As you may have noticed if you read my blog I learn a lot from trolling various forums. In this...
2015-08-05
1,291 reads
Blog Posts
Architecture VC AlwaysOn Questions Answered
On July 15th, 2015 I spoke to the PASS Architecture Virtual Chapter about AlwaysOn Failover Cluster Instances and AlwaysOn Availability...
2015-08-05
1,136 reads
DBTA – StretchDB, a Cool New Feature in vNext SQL Server
Originally appearing in my monthly column at Database Trends & Applications magazine. When it comes to cloud-based database management, there are really only two players: Amazon, the value leader,...
2015-08-05
12 reads
Halloween at PASS–Donate for some fun
This year’s PASS Summit will end on Oct 30, which is just before Halloween in the US. I’m sure lots...
2015-08-05 (first published: 2015-07-29)
1,911 reads
Kerberos Configuration Manager for SQL Server v3
By David Postlethwaite
I’m speaking about Kerberos for the SQL DBA at SQL Saturdays in Oslo, Gothenburg and Utrecht in September...
2015-08-05
2,258 reads
PASS Needs You!
It’s time.
No more procrastinating. No more complaining about the process from the outside. No more excuses.
You have to run for...
2015-08-05
577 reads
Synchronous Processing in the SSIS Script Component
Without a doubt, the most versatile data flow tool in the SSIS arsenal is the script component. This control grants...
2015-08-05 (first published: 2015-07-29)
2,890 reads
Using Kickstarter to Save Neil Armstrongs Spacesuit
Ran across this while visiting the Air & Space Museum over the summer, the Smithsonian launched a Kickstarter campaign to raise...
2015-08-05
675 reads
An interesting way of aliasing TIP#107
I recently gone through something and found a unique way of aliasing. I thought it must be share so other...
2015-08-04
581 reads
Credentials and Proxies: Getting Started
If you’ve been a DBA for more than a day, you probably have a pretty good idea of what a...
2015-08-04
8,811 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