SSWUG Free Expo Event: Real-World SharePoint Administration
Friday, February 11, 2011, 9 a.m. – 1 p.m. PST
Build your skills for deploying and supporting SharePoint by attending this virtual expo. Experts will teach you techniques for managing access control, implementation strategies and tips you can use immediately. With registration you also receive a free complimentary membership to SSWUG for one month. After the expo, the content will be available for further review and study.
Register today to reserve your place!
DBTechCon – Spring 2011
The SSWUG Spring 2011 virtual conference is quickly coming together. Without a doubt, this will be the largest virtual conference in the information technology industry. Access more than 70 sessions from well seasoned professionals with in-depth instruction on technologies such as SQL Server, SharePoint, .Net, Business Intelligence and much more. Register any time from now to April 19th. There are early registration discounts for those who register early. Go to the Registration page for more details and to get signed up right away.
$$SWYNK$$
Featured Article(s)
Using SQL Server Profiler (Part 3 of 3)
This will be a demo filled session with just a few slides to explain the basics. We will go over all facets of SQL Profiler used in daily production support and development. The first section with cover many of the common tasks. The second section with cover the different event classes to help you understand when to use them and how to better filter. The final section will cover more advanced techniques and external tools like starting a trace from TSQL, SQLDiag, and SQL Nexus among others.
Featured White Paper(s)
Essential Performance Tools for SQL Server DBAS
Optimizing SQL Server performance can be a daunting task. Especially so for an increasing number of reluctant DBAs faced with… (read more)
Production Controls
The Editorial for last Friday was prompted by an article I read regarding the confusion of database failover with a database disaster recovery plan. At the heart of the issue was the fact that when data becomes corrupted in your production system, database failover processes assure that that bad data is propagated to all failover devices as well. Therefore, it is essential to have point in time backups for recovery of data corruption.
Two of the main causes, cited by the article, of data corruption are external attacks and human error. Human error was described as a DBA performing operations in a production database.
OK, I get external attacks. There is no perfect software…ther will always be bugs and the need to fix data caused by bugs. There are even those developers who figure out how to make malicious attacks on data for one reason or another.
From my experience, these kinds of threats may be countered with production controls. Do we still live in the days when a DBA is writing raw SQL Queries in a production database to fix something? Are there controls we can use to help reduce this risk?
Send me your comments, insights and experiences to btaylor@sswug.org. I think this is a conversation we really need to have.
Cheers,
Ben