T-SQL Enhancement: THROW
When bulding solid T-SQL solutions, it is often necessary to implement some level of error handling. One of the most...
2011-06-14
1,142 reads
T-SQL Enhancement: Sequence
Many applications need sequentially incremental number as unique/primary key for records. SQL Server 2008 supports identity columns as the primary...
2011-06-07
530 reads
T-SQL Enhancements in SQL Server Denali (2011)
In the next couple of weeks we’ll do a series of blog posts with some of the T-SQL enhancements that...
2011-06-07
457 reads
Speaking at 24 Hours in the Cloud
On June 1st GITCA will run a 24 hour round-the-world virtual event focusing on Cloud Computing. Please visit http://sp.GITCA.org/sites/24Hours for...
2011-05-31
1,577 reads
Blogs
Mistakes IT Shops Without a DBA Make
By Kevin3NF
We get it. There’s no budget for a DBA on staff, or even a...
A New Word: Waldosia
By Steve Jones
waldosia– n. a condition in which you keep scanning faces in a crowd looking...
Deploy at Low Priority
By Zikato
Learn how to deploy schema changes in an always-online SQL Server environment without a...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Linking/Bridge Table/ Or Surrogate Keys?
The system I'm working on is MS Access, but the principles of dimensional modeling...
How to Download and Restore AdventureWorks 2019 Database
Comments posted to this topic are about the item How to Download and Restore...
Question of the Day
Counting Bits IV
What does this code return in SQL Server 2022+?
select bit_count(2.4)See possible answers