Service-Component Architectures
Service-Component Architectures (SCA) provide a programming model for implementing Service-Oriented Architectures (SOA)
2007-08-14
2,344 reads
Articles
Multi-Select Parameters for Reporting Services
Reporting Services is a very handy way to get your SQL Server 2005 data out to end users quickly. It is included with your license and provides a great development environment for reports. New author Adriaan Davel brings us a quick technique for ensuring that multi-select parameters are handled correctly.
2007-08-13
11,621 reads
2007-08-13
2,337 reads
The Reporting Services Cribsheet
If you are forced to nod wisely and keep silent when Reporting Services is mentioned, now is the time to turn ignorance into wisdom, with the help of yet another Simple Talk Cribsheet!
2007-08-13
3,540 reads
Removing the Builtin Administrators - Some Pitfalls to Avoid
The SQL Server 2000 security model is not the best one of all the RDBMS platforms and requires some work to secure properly. One of the practices that is recommended is removing the builtin/administrators group from accessing the SQL Server. New author Kathi Kellenberger shows us some of the pitfalls she encountered when removing this group from her servers.
2007-08-10 (first published: 2005-01-12)
30,166 reads
Scale-Out Querying with Analysis Services
This white paper describes how to set up a load-balanced scalable querying environment for Microsoft SQL Server 2005 Analysis Services so that you can handle a large number of concurrent queries to your Analysis Services servers.
2007-08-10
1,700 reads
What Query Plans are in SQL Server's Memory?
SQL Server memory is primarily used to store data (buffer) and query plans (procedure cache). In this article I'll show how much memory is allocated to the procedure cache (RAM). I'll explain how to determine what plans are in the cache and how often they're used.
2007-08-10
3,461 reads
Table Partitioning
One of the techniques that you can use for increasing performance, especially in large SQL Server tables, is partitioning. Andy Warren brings us an overview of what this is and how you can use it in your SQL Server 2005 applications.
2007-08-09
20,333 reads
.NET 3.5 Language Enhancements
LINQ may be getting the most attention in the forthcoming .NET 3.5, but there are also several new language features that add functionality and make life easier for the programmer.
2007-08-09
3,298 reads
Data Security: Stop SQL Injection Attacks Before They Stop You
This article discusses: How SQL injection attacks work, Testing for vulnerabilities, Validating user input, Using .NET features to prevent attacks, Importance of handling exceptions
2007-08-09
2,954 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers