Donny Mack

Discover how the next version of SQL Server, code-named "Yukon," will benefit you with the new and enhanced abilities and features described on this page. Read More

Brought to you by our fellow community website founder Brian Knight

Previously Live Event:
This event was previously held live on April 2, 2003 . The recording of this event is 95 mins/secs long and 16124 KB in size.

Event Description:
In this session, we will look at how to protect your system from internal and external security factors. We will look at the types of permissions in your database objects, implementing column and row-level security, and protecting yourself from SQL Injection attacks. We'll also cover best practices for basic and advanced protection for your SQL Server system.

Presented by:
Brian Knight , Author, Co-founder SQLServerCentral.com, Fidelity Information Systems

Brian Knight, MCSE, MCDBA, is one of the co-founders of SQLServerCentral.com. He was on the Board of Directors for the Professional Association for SQL Server (PASS) last year and runs the local SQL Server users group in Jacksonville, Florida. Brian is a contributing columnist for SQL Magazine and also maintains a weekly column for the database website SQLServerCentral.com. He is the author SQL Server for Experienced DBAs (Osborne/McGraw-Hill Publishing) and co-author of Professional SQL Server 2000 DTS (Wrox) among other books. Brian is a SQL Server database manager at Fidelity Information Systems in Jacksonville, FL.

More Information: http://www.microsoft.com/usa/webcasts/ondemand/1765.asp
Watch it Now: http://ems.interwise.com/msfm/live/ViewRecording.asp?id=1765

Originally Posted By Darrell Norton

Free SQL Server monitoring tool:  SQL Spy

Available on Windows 2003, XP, 2000, NT4, 98.  From the web site:

• Monitor your SQL Server in real-time.
• Graphically display Locks, CPU, Memory, and I/O action in a moving line graph.
• Watch who is coming and going, minutes connected, CPU, memory and locking usage per connection.
• Monitor SQL statements that are being sent to your SQL Server.
• Record SQL statements that are coming through the procedure cache. (SQL Server 2000 sp3 only)
• See when a transaction is blocked and by whom.
• View what's being cached, as well as cache statistics.
• Kill connections to your SQL Server and keep them out. Send the Kill command on a delayed timer to keep unwanted users from connecting to your SQL Server.
• Generate HTML reports of graphs, Save External Connections and Locking to either .XLS, HTML or .CSV file
• Plus a lot more...For Free!

This application is very nice.  A simple, uncluttered UI with lots of power with a few mouse clicks.  And free!  (There are some other SQL Server utilities on the site as well.)

Originally Posted: http://dotnetjunkies.com/weblog/donnymack/posts/2449.aspx and http://dotnetjunkies.com/weblog/donnymack/

Julien Cheyssial made a new skin for .TEXT. I'm running it right now. It's pretty sweet. You can download it for yourself here: http://dotnetjunkies.com/weblog/skins/lighty.zip

Hello All,

I'm trying to put together a list of DB Naming Conventions. I did find this DB Naming Conventions. Is there an actual standardization list out there? Anyone have any other tips or conventions they use?

We launched  a new build of .TEXT - for current bloggers you'll see some new admin features including some statistics so please look around to see new items Additionally, I posted a new skin: http://sqljunkies.com/weblog/donnymack/  I learned about http://scottwater.com/blog/posts/9982.aspx - I think its one of the better skins I think - we're having someone build a sqljunkies skin right now which should compete quite nicely.

Have fun. http://www.dotnetjunkies.com/weblog will be updated later today. Please submit any bugs directly to me dmack@atomicconsulting.com

Thanks