2008-06-04
4,368 reads
2008-06-04
4,368 reads
When Nigel Rivett takes us on a tour of the apparently innocuous subject of Identity Columns in TSQL, even the seasoned programmer is due for one or two surprises.
2008-06-04
5,440 reads
Enforcing your data's integrity is probably the single most important issue you face when designing a database. Validating user input is one way of keeping bad data from making its way into your analyses and reports.
2008-06-04
3,708 reads
This script will generate a restore statement with supporting MOVE operations to a new directory structure.
2011-12-13 (first published: 2008-05-29)
3,862 reads
Procedure to find any object such as table/stored procedure by its name, or find for ant text inside stored procedures, functions.
2012-04-18 (first published: 2008-05-28)
2,779 reads
This is a stored procedure to add a columns to multiple tables, if column doesn't exist
2013-07-09 (first published: 2008-05-27)
946 reads
2008-05-27
5,147 reads
Find available keys when merging two tables with duplicate keys.
2008-05-26
4,533 reads
It's a well known fact that there's no such thing as a true "array" in SQL Server and that you can't pass a table as a parameter... but you can get a lot closer than you think.
2010-01-08 (first published: 2008-05-22)
32,546 reads
2008-05-19
4,648 reads
By Steve Jones
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family,...
By Rob Sewell
In the WordPress community, badges aren’t just for scouts.
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers