Adventures in Powershell SSIS Administration Programming
In January 2009, I released version 1.4 of SQL Server Powershell Extensions which included a Library of functions for working with...
2009-06-19
1,537 reads
Blog Posts
Best Thing I Learned at PASS Summit
If you haven't heard, PASS is running a contest where you could win conference registration to this year's PASS Community...
2009-06-19
1,268 reads
Moron's Guide to SSIS : Episode 2 - Introduction to the Dataflow
Today Pragmatic Works release it’s second comedic training video featuring Dustin Ryan as “Dustin” and Brian Knight as “Gary” Dustin’s...
2009-06-19
690 reads
The Lowest Bar
In my Modern Resume presentation, I tried to structure it to go from easy to hard things to do in...
2009-06-19
728 reads
Enabling Checkpoints in your SSIS Packages
Checkpoints are a great tool in SSIS that many developers go years without even experimenting with. I hope to enlighten...
2009-06-18
13,025 reads
Learning a New Development Platform
This past week at work we have been having some in-depth training. The interesting thing is it hasn't been SQL...
2009-06-18
1,334 reads
PASS Connector Editorial for June 17, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-06-18
653 reads
The Cost of E-books
What’s the cost of e-books? It’s an interesting question that I have always wondered. I found this account of the...
2009-06-18
725 reads
The secret skill revealed in the dusty booklet
Going through one’s father’s belongings after his death is
always a poignant, bitter-sweet experience. I was going through his most
precious books...
2009-06-18
1,985 reads
ALSSUG...soon!
Yes, ALbanian SQL Server User Group will start soon with first meeting and registering the new users. So we will...
2009-06-17
495 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