SQL Internals Reading Data Records Part 6: Variable Length Data
Welcome back Dear Reader to Part 6 on our series of how to read a Data Record. In Part 1...
2012-07-09
1,150 reads
SQLBalls
Differences in the Null Bitmap between SQL 2005 and 2012
Hello Dear Reader, I’ve been working on a series for BIDN.com, the Business Intelligence Developers Network, on how to read...
2012-07-05
1,166 reads
SQL 2000 TIPS AND TRICKS DECK AND DEMOS
Hello Dear Reader today I'm going to be presenting on SQL 2000 Upgrade tips and tricks for Pragmatic Works Training...
2012-06-28
1,190 reads
Cross Database Views and Schema Binding
One of the most interesting things I've found as a DBA is learning about features in other RDBMS platforms. Sure...
2012-05-31
2,599 reads
MAGICPASS Tonight It’s All About Encryption
http://www.flickr.com/photos/shuck/3971270079/
Tonight I will be live in front of my home town crew at MagicPASS, lead by the one and only...
2012-05-16
687 reads
SQL Rally Deck's and Demo's Up
Hello Dear Reader! I'm coming to you live from the wonderful SQL Rally in Dallas Texas. I have two sessions...
2012-05-10
489 reads
Thank You to the People That Get Us There
http://www.flickr.com/photos/saygoodie/4548042971/
Hello Dear Reader starting today out in Dallas Texas at the Dallas Convention Center is the Second Annual SQL Rally. ...
2012-05-09
668 reads
T-SQL Tuesday #30 TOP 5 Rules for the SQL Community *Screw Ethics
Chris Shaw (@SQLShaw|Blog) is hosting T-SQL Tuesday this month. It has been a while since I participated and this month...
2012-05-08
810 reads
SQL Saturday 130 Deck & Scripts Live
Hello Dear Reader, greetings from SQL Saturday 130 in Jacksonville. This is just a quick post to say that the...
2012-04-28
1,166 reads
See you at SQL Saturday 130 Jacksonville!
http://www.flickr.com/photos/rohicks/4788477593/
Hello Dear Reader, this Saturday April 28th is SQL Saturday 130 in Jacksonville FL! The good people from the Jacksonville...
2012-04-26
897 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