Articles

SQLServerCentral Article

Test Your SQL Server Security Skills and Compete with your Friends!

Test to see how much you know about SQL Server security. If you're one of the members to pass the test (72% score or higher), you're entered into a contest to win a copy of AppDetective and one year's worth of support (over $1500 value)! You can only take the test question test once and it is not timed. After the test, you'll be given the answers and why one answer is more correct than another. Questions are randomly chosen from a pool.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-05-22

348 reads

SQLServerCentral Article

Is the Schema Still Needed?

Do you know what the schema is? In Relational databases, there is the concept of a database and a table, but the schema sits between them. In SQL Server, this is known as the owner. But do we really need this additional layer? Has it ever caused you problems? Has it outlived its usefulness?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-05-21

5,224 reads

Technical Article

SQL Stripes 0.50 Build 180 Released

SQL Stripes is an application that helps you - the SQL Server DBA, to have complete control over your servers. From the high-level of monitoring essential components to the low-level of analyzing your various databases. SQL Stripes is an intuitive and easy to use application and is intended for SQL Server DBA who want to have an easier life. SQL Stripes is completely free! (Announcement, not reviewed)

2003-05-20

461 reads

SQLServerCentral Article

SQL Server Security: The db_executor Role

Brian will be writing a monthly column for us on SQL Security, definitely a hot topic these days! He starts off by discussing the need for a built in db_executor role and how to grant permissions manually to achieve the same effect. Terrific concept, as granting table access can lead to bad things! If there is a security topic you'd like to see more info on, post a note to the article or email us at articles@sqlservercentral.com.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(7)

You rated this post out of 5. Change rating

2003-05-16

41,378 reads

SQLServerCentral Article

Webcast: 0 to Cluster in 60 Minutes-Clustering Windows and SQL Server

In this session we’ll rapidly discuss the MSCS clustering architecture and deploying the system into your environment. We’ll then jump into a demo where we actually cluster a Windows and SQL Server system in under 60 minutes. We’ll discuss the administration tools and best practices on clustering and walk you through completing a cluster and fixing problems along the way. After this session, you should have just enough information to build you own SQL Server that is highly available.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-05-13

903 reads

Blogs

Narrow Task Decomposition in AI Pipeline Agents

By

A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...

Car Update: August 2026

By

It’s been some time since I provided a car update, so I decided to...

Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To

By

An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...

Read the latest Blogs

Forums

Managing Incidents and Fighting Fires

By Pat Wright

Comments posted to this topic are about the item Managing Incidents and Fighting Fires

Backing Up a DMK

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Backing Up a DMK

The Quiet Part

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Quiet Part

Visit the forum

Question of the Day

Backing Up a DMK

In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?

See possible answers