Un-Wired
This Friday's poll looks at vacation and how you prepare to be unwired. Steve Jones talks about some of the things you can do.
Using SET NULL and SET DEFAULT with Foreign Key Constraints
Cascading Updates and Deletes, introduced with SQL Server 2000, were such an important, crucial feature that it is hard to imagine providing referential integrity without them. One of the new features in SQL Server 2005 that hasn't gotten a lot of press from what I've read is the new options for the ON DELETE and ON UPDATE clauses: SET NULL and SET DEFAULT. Let's take a look!
Creating Databases
SQL Server makes it very easy for anyone to create a database. However it's worth spending a few minutes thinking about how you plan a database and SQL Server trainer Andy Warren brings us some thoughts on the subject.
The Million Message System
Sun Microsystems built a database application that processes a million messages a second. Steve Jones talks about the achievement.
Discover SQL Server TCP Port
Learn how to discover the TCP port for a SQL Server instance from the registry using Windows Powershell.
The August 2008 Energy Update
This bi-monthly update on energy news covers quite a bit of wind-related power generation happening around the world.
The August 2008 Energy Update
This bi-monthly update on energy news covers quite a bit of wind-related power generation happening around the world.
The August 2008 Energy Update
This bi-monthly update on energy news covers quite a bit of wind-related power generation happening around the world.
Using full-text search for symbols in SQL Server
Here's how to use full-text search in SQL Server when querying exact SQL expressions that include symbols. Use these steps to search symbols in SQL with these steps.
Scripting Table Management - SQL School Video
MVP Brian Knight walks through the scripting capabilities of Management Studio to show how the code for table creation and the various dependent objects. Brian looks at the options available with scripting and what the implication of choosing them will be.
Blogs
The Feedback Multiplier: How Leaders Can Turn Input into Innovation
By Chris Yates
In every organization there is a hidden currency more valuable than capital, more enduring...
SQL Saturday Boston Slides and Code
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
Scaling SQL Server 2025 Vector Search with Load-Balanced Ollama Embeddings
SQL Server 2025 introduces native support for vector data types and external AI models....
Forums
how to use a variable in a CASE statement?
hi everyone I am getting an error when I add a variable to a...
How to Use SQL Server Features to Cut Web App Latency in Half
Comments posted to this topic are about the item How to Use SQL Server...
Choosing an AI in Sept 2025
Comments posted to this topic are about the item Choosing an AI in Sept...
Question of the Day
The New SQL Server 2025 Data type
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers