Featured Article(s)
Tips for using SQL Server 2005 configuration options (Part 1)
Here you can find some useful tips to use SQL Server 2005 configuration options.
Web Application Security — How to Minimize Prevalent Risk of Attacks
Stories about exploits that compromise sensitive data frequently mention culprits such as "cross-site scripting," "SQL injection," and "buffer overflow." Vulnerabilities like these fall often outside the traditional expertise of network security managers. Click here for your copy.
Webcast Today:
Convert Your Script to a Custom Task in Five Easy Steps
This session will show you how to can turn your script into a custom task, allowing you to easily reuse it between packages, and share it with the world. Presented by: Matt Masson
> Register Now
> 9/2/2009 at 12:00pm Noon Pacific
Working with SQL Server on a Mobile Device
Well, the feedback has been all over the board on this one. I think that some people may actually consider remote, small device access to be the plague, while others live and breath by it without a second thought. There are some clear trends though on the people that ARE using remote access to SQL Server – here’s what Scott had to say on what he is interested in doing, vs. uninterested in doing with his device:
Do:
Manage Jobs (Start, Stop, Check Status)
Run AD-HOC SELECT SQL Queries
Kick Users
Backup Databases / Manage Logs
Not Do:
Restart Services and/or Servers
Provision Users
Run AD-HOC NON-SELECT SQL Queries
Restore Backups
Most people seem to be saying that they do draw the line at restarting servers, but would in a pinch. Job management seems to be a huge benefit, I’m assuming this comes from the fact that a lot of jobs run after hours and being able to manage them remotely saves sleep time.
Please keep sending in your feedback – I’ll be including more tomorrow. Is there something you WISH you could do remotely? What would that be?
Upcoming Webcasts:
Managing a Crisis
Do you have a plan for your next Crisis? What should you look for? Presented by: Chris Shaw Sponsored by: SSWUG.org
> Register Now
> 9/9/2009 at 12:00pm Noon Pacific
Quick Dynamic Data Customizations
In this demo learn how to kick off a new project, setup the data model and make a few customizations to the out of the box Dynamic Data site structure. Presented by: Rachel Appel Sponsored by: SSWUG.org
> Register Now
> 9/16/2009 at 12:00pm Noon Pacific