Random problems
Building random numbers can be challenging for people working in T-SQL. New author Chris Nowicki brings a solution he used to get a random number assigned to each row of a result set.
Support Your Local SQL Server User’s Group
Are user groups dying out in the age of the Internet? It seemed that way for awhile, but Brad McGehee gives some reasons why you should think about attending a meeting.
Dynamic SQL execution on remote SQL Server using EXEC AT
In this tip I am going to start my brief discussion with OPENQUERY and OPENROWSET table functions, its limitation and how the new EXEC AT command overcomes them.
Facts and Fallacies about First Normal Form
When discussing the normalisation process, it is always the First Normal Form that causes the most grief and confusion. Anith Sen takes up the challenge to explain, in simple terms, exactly what the First Normal Form really is, and why it is so important for Database Design. Along the way, he dispels some of the myths that have grown up around 1NF.
Mining for Quitters
Google is trying to figure out who might quit the company, using their own custom application. Steve Jones thinks this is a great idea and wishes more companies would do it.
Mining for Quitters
Google is trying to figure out who might quit the company, using their own custom application. Steve Jones thinks this is a great idea and wishes more companies would do it.
Mining for Quitters
Google is trying to figure out who might quit the company, using their own custom application. Steve Jones thinks this is a great idea and wishes more companies would do it.
SQL Server Encryption - Hashing Collisions
A hash is a computation that transforms one set of data into another (hopefully smaller) set of data. So a hash on your 2,000 character blog post should generate a smaller, 10-20 byte value. In doing that, obviously there are many more possible 2,000...
Best of SQLServerCentral, Volume 5
Best of SQLServerCentral vol 5 pulls together some of the best contributions to SQLServerCentral.com in 2007.
CLR Triggers in SQL Servers
Do CLR triggers really represent the most popular usage of CLR in enterprise SQL Servers? Phil Factor wants to know if this is the case, and if so, what on earth are they doing?
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Call Center Batik Air Yogyakarta
Call Center Batik Air Yogyakarta dapat di lakukan menghubungi CS resmi Batik Air di...
Call Center Batik Air Medan
Call Center Batik Air medan dapat di lakukan menghubungi Layanan resmi Batik Air di...
Call Center Batik Air Tangerang
Call Center Batik Air Tangerang dapat di lakukan menghubungi Layanan resmi Batik Air di...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers