Avoiding Microsoft SQL Server 2005 deployment pitfalls
This tutorial shows you how to properly install Microsoft's SQL Server 2005, avoiding the pitfalls of an unsuccessful deployment.
2007-08-15
2,433 reads
Additional Articles
What’s new in SQL 2008 Part 1
SQL Server 20008 will be released approximately February of 2008, along with a new version of Visual Studio and Windows. This article will highlight some of the new features and benefits found in SQL Server 2008.
2007-08-15
7,510 reads
Introduction to Parameterization in SQL Server
In a previous article I showed how to look at what query plans are in SQL Server's memory. In this article I'll look at how they got there and how and when they get reused. This is commonly called compiling a query plan. More specifically I'll look at how and when SQL Server can parameterize dynamic SQL
2007-08-14
4,567 reads
Service-Component Architectures
Service-Component Architectures (SCA) provide a programming model for implementing Service-Oriented Architectures (SOA)
2007-08-14
2,344 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
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
.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
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers