Ramblings of a DBA

Tara Kizer
posts - 166, comments - 835, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

April 2004 Blog Posts

MSDN Webcast: Protecting Your System From SQL Injection Attacks - Level 200

MSDN Webcast: Protecting Your System From SQL Injection Attacks - Level 200    4/27/2004 5:00 PM - 4/27/2004 6:30 PM Language: English-American Live Meeting Webcast - (GMT -08:00) Pacific Time Online Event United States General Event Information Products: SQL Server. Recommended Audience: Developer and IT Professional. Date: Tuesday, April 27, 2004Time: 5:00PM-6:30PM Pacific Time (GMT-8, US & Canada) Description: SQL injection is one of the most serious threats a database can encounter. When an application is designed without regard for a comprehensive defense, it can provide an attack surface highly vulnerable to hackers skilled in SQL syntax. Once a hacker injects...

posted @ Thursday, April 15, 2004 5:12 PM | Feedback (0) | Filed Under [ MS Webcasts ]

MSDN Webcast: Securing Applications with SQL Server 2000 - Level 300

MSDN Webcast: Securing Applications with SQL Server 2000 - Level 300    4/22/2004 1:00 PM - 4/22/2004 2:30 PM Language: English-American Live Meeting Webcast - (GMT -08:00) Pacific Time Online Event United States General Event Information Products: SQL Server. Recommended Audience: Developer. Date: Thursday, April 22, 2004Time: 1:00PM-2:30PM Pacific Time (GMT-8, US & Canada) Description: This session shows how to use the security features of the SQL Server 2000 platform to control data and functional entitlements for software applications. The presentation emphasizes security options in terms of performance, administrative overhead and ease of programmability. Gain a pragmatic understanding of how to...

posted @ Thursday, April 15, 2004 5:10 PM | Feedback (0) | Filed Under [ MS Webcasts ]

Microsoft SQL Server 2000 System Table Map

Ever wanted to see the ERD for the system tables in MS SQL Server 2000?   If you can't get your hands on the poster, then you can download a soft copy here. I got my poster from our MS representative.  I don't have room in my office to hang it, so I'll probably use the online version now as pulling out that poster each time is a pain. 

posted @ Friday, April 02, 2004 4:41 PM | Feedback (20) | Filed Under [ SQL Server - Database Administration ]

T-SQL script to copy the last full backups of the user databases to a remote server

A question came up on SQLTeam that asked if anyone has a script to copy new backups to a remote server. Of course, you could do this in VBScript, but how would you know about backups that were put into a different directory than what your code is expecting? Backup history information is stored in system tables in the msdb database. I posted code in the comment section of Mark's blog that displays the last backup (full or transaction log) of the user databases. Using that code, you can copy the files to a remote server using xcopy and xp_cmdshell....

posted @ Friday, April 02, 2004 2:41 PM | Feedback (5) | Filed Under [ SQL Server - Database Administration ]

TechNet Webcast: The Guru's Guide to SQL Server 2000 Memory Management Intervals – Level 300

TechNet Webcast: The Guru's Guide to SQL Server 2000 Memory Management Intervals – Level 300 April 6, 2004 8:00 AM - 9:30 AM Pacific Time Ken Henderson, Microsoft SQL Staff Member and Addison Wesley Author, Microsoft Coropration   This presentation reveals the secrets of how SQL Server manages memory resources internally. We will discus the SQL Server memory management architecture and then look at its implementation in detail. This webcast discusses the various types of Windows memory resources and how SQL Server makes use of them. See the SQL Server lazywriter in action and learn how various undocumented memory utility...

posted @ Thursday, April 01, 2004 3:53 PM | Feedback (1) | Filed Under [ MS Webcasts ]

Powered by:
Powered By Subtext Powered By ASP.NET