Security

SQLServerCentral Article

Auditing Your SQL Server Environment Part I

  • Article

Ever been placed into a new environment and couldn't
find an ounce of documentation? This article is the first in a series that will help you make an audit of your new environment
and determine if any SQL Server login does not have a password, has a password the same as the login name or a password that is only one character long.

(1)

You rated this post out of 5. Change rating

2002-04-02

10,445 reads

SQLServerCentral Article

Dynamic SQL vs. Static SQL Part 1 - Security

  • Article

Sooner or later everyone who works with SQL Server hears that it is better to avoid dynamic SQL at all cost. Dynamic SQL will force you to give out more permissions than static SQL. This article by Robert Marda shows you some of the security issues with dynamic SQL.

(2)

You rated this post out of 5. Change rating

2002-02-27

13,002 reads

External Article

Microsoft SQL Server 2000 Security

  • Article

This document introduces the new security features of Microsoft SQL Server 2000. New features are outlined, and a detailed discussion is provided about how to best implement security in a Microsoft Windows 2000 domain environment. Source code examples are included for developers who want to implement the security model immediately.

2001-12-06

1,547 reads

SQLServerCentral Article

Worst Practices - Depending on the GUI

  • Article

One of the strengths of SQL Server is its ease of management and administration over other systems. Oracle, DB2, even early versions of SQL Server required command line mastery to make many types of changes. But should you really be using the GUI for most of your tasks?

(1)

You rated this post out of 5. Change rating

2001-12-04

6,240 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