Data Breaches
Security is hard, but are we doing a good job? Steve Jones shares a few thoughts on our security development practices
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.
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Alamat BCA KCU Rawamangun Telp:0821-815-4374
Telp/WA +62 821-815-4374 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur,...
Alamat BCA KCP Permata Ujung Menteng Tlp:0817-825-533
Telp/WA +62 817-825-533 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil,...
Alamat BCA KCP Matraman Telp:0821-755-5651
Telp/WA +62 821-755-5651 Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers