The Basic TRY..CATCH
Have you written a TRY..CATCH statement in T-SQL? I hadn’t done it for most of my career, since the construct...
2015-03-24
1,190 reads
Blog Posts
The shaky bug in SSIS
You may or may not have noticed it after installing SQL Server 2012: the designer interface in Visual Studio 2010/2012...
2015-03-24
743 reads
Use the WordPress Revision Counter to Keep Shipping Posts
I haven’t been at this blogging thing an extremely long time, and I certainly haven’t been as consistent as I’ve...
2015-03-24
707 reads
Using New-TimeSpan to convert friendly time
The question was this:
This is just a quick/fast snippet in response to that question, but I can think of a...
2015-03-24
453 reads
Who is cjsommer?
I’ve been a problem solver as far back as I can remember, always looking for a new challenge. I love...
2015-03-24
259 reads
0 to Speaker
Recently the last day to submit a session for the 2015 Pass Summit rolled around. I mention this because I...
2015-03-23
699 reads
Exam Prep 70-463: Executing packages in SSIS 2012
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-03-23
1,071 reads
Fix Inconsistent Line Terminators in SSIS
There is a flat file processing issue I’ve run into a number of times over the years, and it’s come...
2015-03-23
2,310 reads
Getting out of the ground with TSQL Smells.
At SQLBits I had a number of conversations with a number of people over TSQL Smells, my open source project...
2015-03-23
684 reads
How to resolve Space issue in SQL server 2005 TIP #93
Hello friends,
Many times we face space issues with our database. To resolve this problem SQL Server 2005 provided one more...
2015-03-23
769 reads
Blogs
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...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
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