SQL Prompt
I downloaded and installed SQL Prompt from Red Gate this morning. If
you aren't aware, PromptSQL was bought by Red Gate...
2006-05-23
1,623 reads
Blog Posts
Disaster Recovery and SQL Server, Part I
The last few weeks I've been working on disaster recovery procedures
for my organization. We review them at least yearly to...
2006-05-20
1,650 reads
Backing up virtual machines on VMware ESX Server
I know VMware and Virtual Server
technology is becoming more and more prevalent in organizations as both
packages can greatly reduce hardware...
2006-05-17
1,616 reads
DR in Processes
The list server here at SQLServerCentral.com has a few quirks, one of which is that it doesn't run as a...
2006-05-15
1,426 reads
Security Myths
It's funny, but most articles in magazines get lost on my desk. I get quite a few subscriptions and rarely...
2006-05-15
1,440 reads
Apprenticeships
An interesting post on Database Apprenticeships. I think this is probably something we need in software development more than as...
2006-05-12
1,430 reads
Nice Article on Security Myths in May/June 2006 Issue of TechNet Magazine
The May/Jone 2006 issue of TechNet Magazine has a feature on security. One of the articles is titled Deconstructing Common...
2006-05-12
1,532 reads
Review of SQL Server 2005 Integration Services, Part 1 of 4
Back in First Impressions of Professional SQL Server 2005 Integration Services,
I indicated I felt the book was worth the buy...
2006-05-10
1,458 reads
Excellent article on cracking SQL Server passwords
The SQLServerAdvisor mailing from SearchSQLServer.com had a link to a
very good article on cracking SQL Server passwords. The article, by
Kevin...
2006-05-09
1,598 reads
Share Your OPML
Dave Winer announced bringing back Share Your OPML
on Friday. I wasn't keeping up with many RSS feeds back when the
original...
2006-05-08
1,554 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
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...
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