Last day to register – Virtual Workshop Tomorrow!
Are you an Accidental DBA?
If so, we have an excellent workshop for you THIS WEDNESDAY! Don’t miss it – Stephen Wynkoop will be teaching this virtual workshop – it’s 4 hours of learning about things you want to know in working with SQL server. You can take a look at the outline of the workshop, and even check out the different segments presented, all here.
But get registered – Last day to register!
[Get more information, or register, here]
Webcast: SQL Server and SharePoint Data Integration
SharePoint’s Data View web part can do much more than just view data. It can serve as a complete front-end to your SQL Server (and other data store) information allowing you to create robust applications without writing code. In this session, you will see just how to create such an application including conditional graphics. You’ll even learn how to pass data from SQL Server into a SharePoint Designer workflow for business process automation.
Presented by: Ricky Spears
> Register Now
> Live date: 10/6/2010 at 12:00 Pacific
Idera SQL doctor BETA
“Within seconds, I was analyzing our production reporting server. Within a few minutes, I was reviewing the results!”
Idera’s new SQL doctor BETA is the first SQL Server performance tuning solution that provides an instant list of recommendations to improve performance based on real-time analysis of SQL Server performance data. And response for this product has already been overwhelmingly positive. When you download SQL doctor BETA (for free) and leave your feedback by October 31st, you will be entered to win an iPad!
Try SQL doctor in BETA now.
Featured Article(s)
Import/Export Options (Part 1 of 3)
We’re going to spend a little bit of time in this session talking about import/export options, and the things that are available to you in the SQL Server Native Tools about how to get data quickly in and out of SQL Server. This is something that perplexes database developers quite a bit, in terms of “Well, how do I get sample data into my system?” Or, “How do I get data from another source into the database that I’m working with; how can I load that?We’ll spend a little bit of time just talking about a couple of tools that are available to you in terms of the Import/Export Wizard, and how we can go about generating files that are necessary to use for importing and exporting data.
Featured White Paper(s)
Evaluating Deduplication Solutions: What You Should Really Consider
Understand deduplication, and how it can be implemented – single instance storage (SIS) vs deduplication, fixed vs. variable … (read more)
Featured Script
Trigger: checkForJobFail
We do not use SQL mail on our SQL servers. So, we developed this trigger on sysjobhistory to notify us of job failures. We… (read more)
SQL Server Management Basics Workshop
I thought I would take a moment to raise awareness the the workshop SSWUG is presenting tomorrow (Wednesday). Why, you ask? I think this 4 hour workshop will provide value to many of our readers.
SQL Server does not just run…performance degrades with time, and hardware never lasts forever. As more and more small businesses use SQL Server they require disaster recovery and tuning tasks be performed consistently on a scheduled basis. Sometimes developers or lucky individuals become the keeper of the database. Often Small Business Owners perform those tasks themselves.
Due to the value of SQL Server, it is growing in popularity as the data engine behind many commercial software products to the point you may not even be aware that you have an SQL Server database supporting your application.
The course provides you the essential information you need in order to effectively manage your databases. It covers the basic topics like,
- – What should you be monitoring?
- – What do you need to know about security?
- – What is important for essential recovery options for your systems?
- – How do you set up procedures to make sure you’re covered?
- – What do you need to know about jobs, tasks and scheduling?
- – …and a lot more.
[Get more information, or register, here] (you can check out the course outline too)
What about those of you who have been managing SQL Server for a long time. Are there some tips and techniques that are new since you put together your processes? Have you updated your optimization scripts to take advantage of the new systems views and functions? I know I always learn something new because many of "the old ways" become obsolete with each release of SQL Server. For example, I wrote an article posted here on SSWUG about automating the defragmentation and updating of statistics in your database. Recently I had to re-write the whole source taking advantage of the systems views and functions released in SQL Server 2005.
If you are like me, I take gold anywhere I can find it. This may be the opportunity for you. Hope to see you Online.
Cheers,
Ben