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
SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
Google Moves Up Post-Quantum Cryptography Timeline
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Forums
Dancing Robot Goes Rogue
Comments posted to this topic are about the item Dancing Robot Goes Rogue
advice as i migrate my winscp based ssis pkg to our prod server
Hi , i installed winscp on my pc, added it to GAC thru vs...
Identities and Sequences II
Comments posted to this topic are about the item Identities and Sequences II
Question of the Day
Identities and Sequences II
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers