Trigger Trivia
From SQL Server trainer and guru Andy Warren, he are a few short nuggets that you might not realize about triggers.
SQL Server Management Objects: Lessons from the Wild
Harness the power of SQL Server Management Objects to create, document, and manage your SQL Server databases.
SqlCredit – Part 10: MAC Performance and Updating SqlCredit
This month's installment of "Developing a Complete SQL Server OLTP Database Project" covers MAC performance results, a summary of encryption findings, and comments on updating the SqlCredit code based on those findings.
Cleaning Address Data with SSIS Using a Web Service
This article describes how to call a web service to clean up address data from within a data flow.
Quick Hits on the News for Nov 12, 2007
A few comment on the database news for the week ending 11/10/07
Sponsored Content
SQLServerCentral.com is always looking for ways that we can provide you with better, more useful content to help you learn about SQL Server. We've got a new idea and we're looking for feedback.
The Pace of Information
Is the rapid pace of information being fed to us a problem? Steve Jones has a few thoughts.
Index related DMVs and DMFs - sys.dm_db_index_usage_stats
Examining statistics of indexes is useful for optimizing the performance of queries. Statistics help us determine the usage and worth of indexes - one simple method is using the index-related dynamic management view; sys.dm_db_index_usage_stats
Passing table valued parameters in SQL Server 2008
I have always wanted to be able to pass table variables to stored procedures. If a variable is able to be declared, it should have the functionality to be passed as necessary. I was thrilled to learn that SQL Server 2008 offers this functionality. Here are instructions on how to pass table variables (and the data in them) into stored procedures and functions.
Working With SqlParameter in .NET
Interacting with SQL Server from .NET is a radical change from the old OLEDB/ODBC method. Raj Vasant brings us some easy ways to work with parameters passed in with the ADO SQLCommand.
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
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers