Editorials

SQL Server server and Databases Health check process

Featured Article(s)
SQL Server server and Databases Health check process
The following stored procedure is really a collection of several TSQL system procedures designed to monitor server and databases configuration values and keep the DBA Informed about databases health

Want to manage multiple implementations of the same database?
Want to build stored procedures in seconds? Auto generate SQL Delete, Update and Insert scripts from a Select statement? – View parent-child relationships and auto build multi-table join in a few clicks – Another mouse click to view the first 100 rows – Another click saves the output to an Excel spreadsheet? You CAN with this great new software, dbOrchestra. No kidding…Take a look here and give it a try.

Great Feedback
Our survey that’s running has shown us a LOT of information. (See next item to take a look) – I wanted to pass along a few of the items that people have mentioned, some of them are really quite good. 🙂 There is a question at the end – "What should we have asked that we didn’t, and what’s your answer?" Here are a few of the items:

Suggestion: Split conference into 1/2 day sessions, over more days, rather than fewer full-days of content.

Question: Is SQL Server Your life?
Answer: No. 🙂

Q: What is the average flight speed of a unladen African swallow?
A: I don’t know. ARGGGGH!!!
SW: FYI, it’s roughly 11 meters per second, or 24 miles an hour.

Several people mentioned pairing the video sessions with Second-Life meet-ups.

In the list of features I see many features I am not familiar with. Maybe one of the check boxes for the use of features should be, "Didn’t know it existed" or "Have not checked it out" – SW: Great idea!

Thanks for all the feedback – I can’t wait to start sharing some of the results – but we need more to answer so we are sure we have a representative sample of the SSWUG world.

I Need Your Help!
Please – if you have a minute or two – we have a new concept we’d like to first explain to you, then get your feedback on. I need to know what you think of it, what you’d like to see, what type of experiences you’ve had, etc. I’ve created a short video explaining the idea, then we have a survey. Now, I know, I know. Surveys are not everyone’s favorite thing, but I really need to get your feedback and know what you think about this.

We’ve added some incentive too for the survey – by filling out the survey, you’re automagically entered in the drawing for a prize! The prizes are sure to be of interest, it’s cold hard cash. We’ll have one (1) $200 grand prize, one (1) $100 second prize and three (3) prizes at $50. So, you have *5* chances to win.

This all hinges on feedback we receive, so we’ll be running this for a few weeks here to get as much feedback as possible.

Click here to see the video and take the survey – and please do let others know about this. I’m not trying to generate traffic (no login or membership is required) – but I do need to hear from as many people as possible.

*Thanks* for your help! (If you have any trouble with the page or the survey, please email me and let me know).

> See video, take survey

Featured White Paper(s)
SQL Server Data Recovery Made Easy with Idera SQLsafe
When a database goes down due to hardware or software failure, data corruption, or any number of other causes, every minute … (read more)

Powerful Report Design Made Easy
Learn how to design a report with Crystal Reports XI. See how easy it is with this simple to follow whitepaper. From decidi… (read more)

Data modelers – 7 Steps to Success – Building a Collaborative Team Environment
Your data models are brilliant… but only if the DBAs and developers are on the same page. Often, there is a significant dis… (read more)

Transforming Enterprise Backups: How Using a Third-Party Tool Can Improve Backup Strategies
The backup and restore facilities in native SQL Server are robust, and once a backup routine is established, the DBA needs to… (read more)