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,611 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,154 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,319 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
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Forums
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I