SSIS Configurations: When and How
Configurations in SSIS are a lovely tool that when implemented correctly can greatly reduce package maintenance. It is very possible...
2011-06-14
881 reads
Blog Posts
Too Many Disasters To Choose From (T-SQLTuesday)
I’m ashamed to admit that somehow this months T-SQL Tuesday has completely blindsided me, which is kind of ironic really when you consider...
2011-06-14
451 reads
'Topping and Tailing' strings in database tables
/*
When you are having to extract just part of a string in TSQL, there are a number of techniques you...
2011-06-14
2,222 reads
T-SQL Enhancement: THROW
When bulding solid T-SQL solutions, it is often necessary to implement some level of error handling. One of the most...
2011-06-14
1,209 reads
T-SQL Tuesday #19 – Disaster Recovery
This month Allen Kinsel hosts T-SQL Tuesday #19 with a disaster recovery theme. This is the blog party idea started...
2011-06-14
856 reads
T-SQL Tuesday #19 – Disasters & Recovery
When I first read this article, I thought to myself “I have no clue on this one. What could I...
2011-06-14
733 reads
T-SQL Tuesday #19 - Disasters & Recovery
When I heard Allen Kinsel’s (aka @sqlinsaneo|Twitter) Invitation to T-SQL Tuesday #19 – Disasters & Recovery, for some reason, I read it...
2011-06-14
1,592 reads
T-SQL Tuesday #19 – Disasters & Recovery
There are three types of disasters that are seldom expected. Read about the fun of dealing with these different types of disasters.
Related Posts:
The Mystery of Missing Backup Files December...
2011-06-14
3 reads
T-SQL Tuesday 19 Disasters and Recovery
This post is my contribution to T-SQL Tuesday, hosted this month by Allen Kin (blog | twitter).
A first step in any disaster recovery...
2011-06-14
1,475 reads
T-SQL Tuesday Mirroring and SSWUG
This month’s T-SQL Tuesday is hosted by Allen Kinsel (Blog|Twitter) and covers “disasters and recovery”. My favorite DR solution is...
2011-06-14
700 reads
Blogs
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...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
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