Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Security, Administration, SQL Server 7 Rss

<< Newer    Items 21 to 40 of 44    Older >>
 

Dump SQL Permissions

We saw a note from Chad about a tool he wrote in the forums and asked him to write up some notes. Not only did we get notes, we got the source code! See what a DBA can do with some DMO.   Read more...
By Chad Miller 2004/03/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 17,647 reads

Review of Lumigent Entegra

We've been trying to catch up on reviews lately, Hai was kind enough to give Entegra a try and report back on it. The basic concept is that it lets you do extensive auditing without having to add triggers. If you're trying to find an auditing solution, this is worth considering.   Read more...
By Haidong Ji 2004/02/27 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,767 reads

SQL Server Security Part 2

In part one Chris Kempster covered a variety of security recommendations primarily for production systems. In Part two of this series he continues to explore security at a variety of levels where you may not realize you are vulnerable.   Read more...
By Chris Kempster 2005/11/04 (first published: 2004/01/30) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 35,072 reads

Using sp_addalias

SP_addalias isn't a well known stored procedure to most DBA's - do you know what it does? In what situations you might use it? This short article gives very quick and clean answers to both of those questions.   Read more...
By Andy Warren 2003/09/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,897 reads

Worst Practice - Bad Connection Strings and Bad Info in Sysprocesses

Andy returns to the Worst Practice series this week with a short article looking at how connection strings in applications affect what you see in sysprocesses. Perhaps less controversial (in our opinion) that some of the other worst practices, this is something easy to fix and definitely worth fixing! Read the article and post a comment - explore other points of view! Readers posting a comment will be entered in a drawing for a copy of the SQL Server 2000 Resource Kit.   Read more...
By Andy Warren 2003/08/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,035 reads

SQL Server 2000 SP 3: What's New in Security

Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes.   Read more...
By Brian Kelley 2005/12/09 (first published: 2003/06/05) | Source: SQLServerCentral.com | Category: service packs
Rating: |  Discuss |   Briefcase | 29,971 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,205 reads

Troubleshooting Cannot Generate SSPI Context Errors

As a DBA you do not need to know how to setup an Active Directory domain or a DNS server, but you still need to know how Kerberos, Service Principle Names, and hostnames are used to perform integrated authentication to a SQL Server. This article by new columnist Chad Miller shows you some of the more integral parts of troubleshooting running Windows Authentication security in a SQL Server environmnet.   Read more...
By Chad Miller 2005/08/19 (first published: 2003/02/27) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 65,313 reads

Logins, Users, and Roles - Getting Started

Do you know the difference between a login and a user? What's the best way to add them; Enterprise Manager, T-SQL, or SQL-DMO? In this beginner level article Andy demonstrates how to use all three methods to add logins and users and offers his view of which is the best technique.   Read more...
By Andy Warren 2005/09/30 (first published: 2003/02/19) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 35,266 reads

Free Utility : EnforcePass

These sets of scripts will add minimum password enforcement when a login is created or its password changes.  Read more...
By Additional Articles 2003/02/14 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 90 reads

Who's to Blame for the SQL Slammer Virus?

Last week the SQL Sapphire (or SQL Slammer) virus hit corporate networks throughout the Internet. Although damage has not been estimated yet, it is sure to be in the tens of millions of dollars. So who is to blame when a virus like this manhandles a corporate environment?   Read more...
By Brian Knight 2003/02/03 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,814 reads

Using SQL Trace to Audit Database Access

As a new DBA, you will probably walk into an environment that is poorly documented and nobody has any idea of how many SQL Servers are on the network. In the first series of articles, Haidong Ji talks about how to audit logins in your SQL Server.   Read more...
By Haidong Ji 2002/12/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 17,717 reads

Setting a Default Database for your Logins

Andy discusses reasons why he thinks setting the default database to anything other than master is a mistake. We think he does a good job of covering the pros and cons, read the article and join the discussion!   Read more...
By Andy Warren 2002/12/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,326 reads

Implementing Encrypting File System (EFS) with SQL Server

EFS provides a mechanism for encrypting files completely transparent to higher level applications such as SQL Server. In this article by Brian Kelley, he shows you how to implement this type of security in your environment.   Read more...
By Brian Kelley 2006/12/01 (first published: 2002/12/09) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 29,113 reads

The Case for SQL Logins - Part Two

In this follow up to one of our most popular articles, Andy responds to comments posted by readers and discusses how to manage SQL logins effectively in your applications.   Read more...
By Andy Warren 2002/08/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,770 reads

Fixing broken logins and transferring passwords

When transferring a database to a new server, you are bound to experience a user problem. In this article by Neil Boyle, he shows you how to transfer passwords and accounts seamlessly to a new server.   Read more...
By Neil Boyle 2004/07/05 (first published: 2002/08/14) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 23,932 reads

The Case for SQL Logins - Part 1

Andy says Windows Authentication "is bad". What? That's not what Microsoft says! Heck, that's not even what we say! Everyone knows NT authentication is the way to go. Then again, when was the last time Andy wrote an article that wasn't worth reading?! Read the article, rate it and add a comment - and automatically be entered in a drawing for a copy of SQL Server 2000 Performance Tuning donated by Microsoft Press.   Read more...
By Andy Warren 2002/06/25 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,594 reads

Review of SQL Server 2000 Programming (MSPress)

Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now!   Read more...
By Andy Warren 2002/06/04 | Source: SQLServerCentral.com | Category: installation
Rating: (not yet rated) |  Discuss |   Briefcase | 6,398 reads

SQL Server Security Part 3

In the final article in the series, Chris Kempster covers some of the more advanced methods to securing your SQL Server.   Read more...
By Chris Kempster 2002/02/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,608 reads

SQL Server Encryption Best and Worst Practices

In this article by Neil Weicher, he talks about encryption of data and files for SQL Server.   Read more...
By Neil Weicher 2002/01/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,577 reads
<< Newer    Items 21 to 40 of 44    Older >>
 
Tags
configuring (9)    
miscellaneous (6)    
programming (5)    
t-sql (5)    
installation (4)    
sql server 6.5 (4)    
strategies (4)    
dts (3)    
stored procedures (3)    
backup / restore (2)    
best and worst practices (2)    
indexing (2)    
logins (2)    
monitoring (2)    
replication (2)    
sql-dmo (2)    
triggers (2)    
user defined function (udf) (2)    
worst practices (2)    
ado (1)    
databases (1)    
disaster recovery (dr) (1)    
distributed queries (1)    
english query (1)    
grant (1)    
openxml (1)    
performance tuning (1)    
permissions (1)    
role (1)    
script (1)    
scripting (1)    
service packs (1)    
sql server 2005 (1)    
system databases (1)    
updategrams (1)    
user (1)    
visual basic 6 (1)    
xml (1)    
xsl (1)