<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Articles with tags
Security
,
T-SQL
,
Programming
Refine your search with one of the following additional tags (with number of items):
Miscellaneous
(3)
Stored Procedures
(2)
Basic Querying
(1)
SQL Puzzles
(1)
SQL Server 7, 2000
(3)
Strategies
(2)
Configuring
(1)
SQL-DMO
(1)
Administering
(2)
.Net
(1)
Performance Tuning
(1)
Search for
any
content tagged
Security & T-SQL & Programming
Items 1 to 6 of 6
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 posted: 2003/02/19)
|
Source:
SQLServerCentral.com
|
Category:
Administering
Rating:
|
Discuss
|
Briefcase
|
32,324 reads
Dynamic SQL or Stored Procedure
We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't.
Read more...
By
Andy Warren
2005/08/26 (first posted: 2003/04/23)
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
42,102 reads
Stop SQL Injection Attacks Before They Stop You
A new article from MSDN magazine on stopping SQL Injection attacks by examining how the SQL can be exploited. It's a good basic article for developers as well as DBAs who might have to review code.
Read more...
By
Additional Articles
2004/08/20
|
Source:
MSDN Communities
|
Category:
Security
Rating:
Rate this
|
Briefcase
|
1,736 reads
Dynamic SQL or Stored Procedure
We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't.
Read more...
By
Andy Warren
2005/08/26 (first posted: 2003/04/23)
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
42,102 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 posted: 2003/02/19)
|
Source:
SQLServerCentral.com
|
Category:
Administering
Rating:
|
Discuss
|
Briefcase
|
32,324 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:
Administering
Rating:
|
Discuss
|
Briefcase
|
6,538 reads
Items 1 to 6 of 6
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
