Articles

SQLServerCentral Article

Building a Distributed Service Broker Application

Service Broker is one of the more interesting and useful new enhancements in SQL Server 2005, however many DBAs are not familiar with this subsystem. New author Santhi Indukuri brings us a practical example of how you can build a distributed application using Service Broker.

(18)

You rated this post out of 5. Change rating

2007-01-25

18,999 reads

SQLServerCentral Article

SQL Server Security: Fixed Database Roles

Brian is back with a new security article, this time working through the details of the fixed database roles. There are some important concepts here. In particular if you're not totally clear on the difference between dbo and db_owner, read this article.

(9)

You rated this post out of 5. Change rating

2007-01-19 (first published: )

64,319 reads

SQLServerCentral Article

Monitoring Servers Using SQLCentric

Every DBA should know what is going on with their database servers, but this is a chore that requires some type of tool to help. SQLCentric from Pearl Knowledge Solutions is a tool that can help you and SQL Server MVP Satya Shyam brings us a look how to setup and use this tool in your environment.

(2)

You rated this post out of 5. Change rating

2007-01-18

4,490 reads

Blogs

AI Experiments: Claude Solved a DAB Issue

By

I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...

Audit – Security Compliance Frameworks (Part 1)

By

This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...

Restore SQL Server Database to an OrbStack Container

By

In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...

Read the latest Blogs

Forums

Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened

By Pablo Echeverria

Comments posted to this topic are about the item Can You Really Downgrade from...

What is CPU Usage?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What is CPU Usage?

Limiting Checkpoints

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Limiting Checkpoints

Visit the forum

Question of the Day

Limiting Checkpoints

If I use the -k parameter with a number after it, what does this change in SQL Server?

See possible answers