Articles

Technical Article

Indexing Guide: The art and science of SQL Server indexing

You can improve your SQL performance by using indexes. But you have to choose the proper indexes and make sure the ones you do choose fit into your business situation. In this indexing guide, you will find answers to common indexing questions, indexing dos and don'ts, and tricks for working with the Index Tuning Wizard to improve overall system performance for SQL Server 2000 servers. This is particularly useful for servers that need a boost before they are upgraded to SQL Server 2005.

2006-02-28

5,279 reads

Technical Article

Stored procedure: Generate code for ad hoc data operations

A SQL Server DBA often needs to perform ad hoc operations on data in their databases. The tasks can typically be handled with simple T-SQL statements, but other times a more complex operation is called for – and having to manually enter all the T-SQL code necessary for such an operation is not appealing! It can be difficult to perfect the syntax, and tedious to list column names once, twice or even three times. Fortunately, useful template code can be easily generated instead of being entered by hand.

2006-02-27

3,601 reads

Technical Article

Applying the Principle of Least Privilege to User Accounts on Windows

A defense-in-depth strategy, with overlapping layers of security, is the best way to counter these threats, and the least-privileged user account (LUA) approach is an important part of that defensive strategy. The LUA approach ensures that users follow the principle of least privilege and always log on with limited user accounts. This strategy also aims to limit the use of administrative credentials to administrators, and then only for administrative tasks.

2006-02-24

2,597 reads

SQLServerCentral Article

SQL Server Redundancy for SMBs

Building a highly fault tolerant and available SQL Server is expensive and difficult. This brings about unique challenges for small businesses who often lack the resources of large enterprises. Bilal Ahmed and Shivan Bindal discuss the various ways of building redundancy and the challenges of each.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2006-02-21

5,996 reads

Blogs

Restore SQL Server Database to an OrbStack Container

By

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

Day of Data Baton Rouge Slides and Code

By

Thanks to everyone for attending my talk today at Day of data Baton Rouge...

Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server

By

Here’s the scenario: one of my SQL Server instances migrated to the DR array....

Read the latest Blogs

Forums

PowerBI Question - Data Sources

By Brandie Tarvin

I don't see a PowerBI forum, so I'm posting here. I have a need...

SQL Server Certificates

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Certificates

Connect an Azure Function to Azure SQL database Using a Managed Identity

By Kunal Rathi

Comments posted to this topic are about the item Connect an Azure Function to...

Visit the forum

Question of the Day

SQL Server Certificates

Which of these is not true for certificates used for SQL Server connections?

See possible answers