SSC bought out by Red Gate... Now what?
One of the highlights of my weekday mornings is reading the editorial by
Steve Jones of SQLServerCentral.com. However, this past...
2006-11-23
1,537 reads
Tim Mitchell
Essential Audio for .NET Pros
For your listening enjoyment, I have compiled a list off essential audio for .NET developers and SQL DBAs. This list...
2006-10-06
1,378 reads
SQL Injection... is this still a problem?
For some reason, today I came across at least a half-dozen blog posts and articles about how to avoid SQL...
2006-10-03
1,417 reads
Dallas Code Camp 2006
Generally I don't look forward to giving up an entire Saturday at work. However, today's Dallas Code Camp was an...
2006-08-29
1,573 reads
Be on the lookout for the mistakes of others
I've come to learn that there are some really flaky systems out there. Not just a few quirks here and...
2006-06-15
1,386 reads
SQL Server Connections
I found out today that I will get to attend the SQL Server Magazine Connections conference (part of the DevConnections...
2005-12-21
1,398 reads
PASS 2005: Day Four
Day Four wrapped up SQL Pass 2005. As a first time attendee to this event, my head was swimming by...
2005-10-01
1,352 reads
PASS 2005: Day Three
Day Three of PASS had a decidedly better start than did the previous day. After finally figuring out the effective...
2005-09-29
1,294 reads
PASS 2005: Day Two
Day Two at PASS started out on a sour note. Rewind about 36 hours, to when I was checking in...
2005-09-28
1,539 reads
PASS 2005: Day One
This year, I have the opportunity to attend the SQL PASS event in Grapevine, Texas. This is my first PASS...
2005-09-28
1,407 reads
Blogs
Generating Random Strings with GenAI
By Steve Jones
One of the things I’ve been experimenting with in AI is taking things other...
Heading to SQL Bits 2025
By Steve Jones
I’ll be at SQL Bits tomorrow, Saturday Jun 20, 2025 for the final day...
Exploring the Next Gen General Purpose Tier in Azure SQL Managed Instance
By John
In a recent video, I took a hands-on look at the Next Gen General...
Forums
SSRS error: The Value for the image 'Image1' has a constant value...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
XML_COMPRESSION for existing tables
We are in the process of upgrading to SQL Server 2022 and would like...
How to Choose the Right Tool for MS SQL to PostgreSQL Migration
Comments posted to this topic are about the item How to Choose the Right...
Question of the Day
Adding Defaults
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers