PASS Connector Editorial for August 12, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-08-12
414 reads
Blog Posts
So many topics, so many blogs.......What says you?
So, what should I talk about next? There's so much going on in the world of SQL Server (ie: 2008,...
2009-08-12
731 reads
SQL Quiz 5: SANs Mirroring
My turn to answer Chris Shaw’s questions “Do I feel I have a reliable SAN solution?” and “Describe Database Mirroring...
2009-08-12
631 reads
SQL Saturday Baton Rouge – Session Evaluations
I received my evaluation summary from the SQL Saturday event in Baton Rouge earlier this month. This was the first...
2009-08-12
755 reads
SQLSaturday Advisory Council
Cross posted on the SQLSaturday blog as well.
We started SQLSaturday back in May 2007 because we wanted a SQL event...
2009-08-12
560 reads
ThrowAway Scripts
Although I tend to write a lot of formal scripts, as part of the development process I'll explore an object...
2009-08-12
551 reads
Which version of SSIS-DTS Package Search is right for you
The download page for SSIS-DTS Package search presents three choices:
SSIS-DTS Package Search for SQL Server 2000 on Windows x86SSIS-DTS Package...
2009-08-12
1,465 reads
Writing Technical Content for PASS
We’ve just posted our core guidelines for technical content on sqlpass.org. The short story is there are three main ways...
2009-08-12
871 reads
Data Theft
Is employee data theft on the rise? I saw this blog post on the subject, but I had to take...
2009-08-11
792 reads
Does File Exist Check in SSIS
A very common need in SSIS is to check to see if a file exist before you run what could be...
2009-08-11
15,178 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