Scripting the Installation of SQL Server 2005
Having a consistent SQL Server environment is important. Gregory Larsen discusses one method of scripting your installation to ensure all of your SQL Server 2005 machines are set up the same.
Maintaining a Log of Database Changes - Part 1
This article looks at logging your database changes from a developer's perspective.
Microsoft SQL 2005 Maintenance Wizard Part 3
The Maintenance Plan Wizard is a graphical interface for creating a variety of database housekeeping tasks. This article focuses on using SQL Server 2005 Maintenance Plan Wizard for creating Database Backup operations.
Using Views to Enforce Business Rules
A view is most commonly thought of as a SELECT statement. Most developers will simply create a view to "group" complex SELECT statements for reuse within another view or stored procedures. It makes typing easier! But the really power of views is their ability to implement business rules.
SQL Server Profiler for Analysis Services
Use SQL Server Profiler to “look behind the scenes” within Analysis Services 2005. BI Architect Bill Pearson leads a hands-on introduction to determining resource utilization effectiveness for both processing and query performance with profiling.
SQL Server 2005 Maintenance Mayhem
Service Pack 2 for SQL Server 2005 has had a few issues and one of the big ones is maintenance plans. Longtime DBA and developer Robert Pearl, of Pearl Knowledge Solutions brings us a fix for your maintenance plans.
The Service Broker Alphabet Part 2
SQL Server MVP has been working extensively with SQL Server 2005 and one of the less well known features: Service Broker. In this short article, we continue definitions of the terminology you'll need to know to work with this subsystem.
The Service Broker Alphabet Part 1
SQL Server MVP has been working extensively with SQL Server 2005 and one of the less well known features: Service Broker. In this short article, we get an introduction to some of the terminology you'll need to know to work with this subsystem.
Dynamic Images and Databases
Should you store dynamically generated web-site graphics in a database or is the file system the better option? Dino illustrates how to make this decision in ASP.NET
Adventures With Service Broker
Service Broker is one of those new SQL Server 2005 features that doesn't get much press, but is extremely interesting from a software architect perspective. The much talked about service oriented architecture (SOA) can make use of Service Broker and new author Johan Bijnens brings us a look at this subsystem.
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
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...
Forums
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
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
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