New Weekly SQL Server Show Posted
SelectViews: Legacy application upgrade choices, T-SQL JOINs, upcoming events and more. Also looking at privacy expectations and business intelligence – a problematic match? This is show number 79, and you can also find out how to win $200 in the drawing, information about current SQL Server versions and service packs and all sorts of other information.
> Watch the show here
Featured Article(s)
Easy SQL Server Database Monitoring for the Oracle (and SQL Server) DBA – Part 1
Oracle (and SQL Server) DBA’s that are assigned responsibility for SQL Server databases are often overwhelmed by the sheer number of servers and databases that must be monitored. This article describes a free and easy to develop tool that will help you get control of the SQL Server environment.
Backup, Restore and Recovery – In One Click
Setting up dependable backup and recovery processes, even failover to warm standby systems, is a key feature of making sure your systems are protected and will provide service levels your users need. Sonasoft makes this a piece of cake, especially when it comes to executing on the backup, recovery and management processes. Just a click away – you can cut over to your standby servers, restore a database, check on databases that need attention in terms of backups, and much more. Find out more, here – and make sure your systems are covered when you need it most.
SQL Server 2005 Management Tools Overview
We’ll look into various management tools and capabilities for SQL Server 2005. Learn about everything from tracing to tuning and finding out how to better optimize and understand your systems. We’ll show what tools you have available and how they can be applied to managing your server.
> Register Now
> Webcast date: 9/12/2007 at 12:00pm Noon Pacific
Privacy and Business Intelligence…
…a problematic match? In today’s show on SSWUGtv, I talk about a recent CNet look at a specific privacy policy issue as it relates to data mining and selling of information from social networking sites (check out the show for specifics). I wanted to bring this up here to get your feedback on how big of an issue this could be for your own company.
If your company has information on file, information about sales, trends, usage issues, problem reports, whatever – this could impact how you can use that information. If the general public’s understanding how information is used is that they "own" information that is the result of their interaction with you – and that they should have some say in how that information is used, I can see where this would significantly impact many a Business Intelligence project.
I can also see where a misunderstood data mining project – misunderstood by the public at large – could go dreadfully wrong and cause all sorts of public relations headaches for a company as well.
Where is the line drawn in your eyes? When is data no longer "owned" or controlled by the customer (I’m not talking about HIPAA or other truly private/personal information) and when is it just "data" that can be mined and learned from without regard for its use? I’m not condoning the data that was released on searches, nor the data and methods that Rapleaf allegedly uses, but it does beg the question. Where is the line?
Drop me a note and let me know your thoughts on how this might impact your business…
> Watch the show here – select the "Privacy and BI" option on the right to go right to that segment.
Featured White Paper(s)
Profiling SQL Server Performance by Kevin Kline
Database changes impact database performance. The challenge is that DBAs lack the necessary expertise and cannot afford the o… (read more)
Developing Rich Internet Applications with NXJ Developer
Companies today have external and internal pressures that are placing ever increasing demands on IT and ISV/VAR organizations… (read more)
SQL Server 2005: Deployments and Tests in an iSCSI SAN
iSCSI SANs offer an alternative for building Storage Area Networks. Consolidating storage in a SAN offers storage management … (read more)