2011-05-24
3,048 reads
T-SQL
2011-05-17
3,178 reads
2011-05-11
2,899 reads
2011-05-10
3,126 reads
Check your Digits
The most persistent struggle in data processing has been to ensure clean data. There are many ways that data can be incorrect and a database must check, as best it can, that the data is correct. The CHECK constraint is ideally suited for this sort of work, and the checking routine can become quite complex when dealing with check digits in data.
2011-04-28
3,328 reads
Adding Column to a SQL Server Table
This article examines the difference between adding a nullable column to a table or a column with a default value.
2011-04-27
5,393 reads
2011-04-26
3,144 reads
2011-04-25
3,054 reads
Remove tab,line feed and carriage return frome text field
Remove tab,line feed and carriage return frome text field
2011-04-28 (first published: 2011-04-21)
3,330 reads
2011-04-18
2,809 reads
Blogs
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...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers