No Travel, No Rubber Chicken Meals…
Just awesome technical sessions from some of the best and most well-known technical presenters out there. We have a spot saved for you at the SSWUG.ORG Virtual Conference – are you confirmed yet? Check out the sessions, speakers and schedules here on the site, then be sure to register ASAP for the best rates going.
> Register Now
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
Things I’d Like To See in SSMS
I mentioned last week that SSMS had the ability to be expanded with an Add In. Following are some of the ideas our members have shared regarding enhancements that would make their jobs easier.
If you have ideas you’d like to add send them to btaylor@sswug.org.
Cheers,
Ben
Bob writes:
The ability to open a query window that does not prompt me to save its contents to a file when closing it. Little of the work I do all day involves scripts saved in files. I store almost all of my pre-canned T-SQL scripts using Red Gate SQL Prompt’s Snippets feature.
The ability to modify the caption for a query window, so that I can find the one I want from among the 20 or more that I might have open with a quick scan through the list generated by the Window menu.
The ability to turn on some sort of visual cue to indicate when a query or command has finished. Like most DBAs, I am usually juggling multiple tasks at once, and many of them involve long-running operations such as backups or restores. I will often initiate one of these processes and move on to something else (or a half dozen something-elses), and not notice that it has finished for quite some time, needlessly delaying the developer who requested it from starting the work that had been waiting for it. It would be extremely helpful if the window’s title bar flashed, or a notification balloon was inflated. I know there’s a setting that generates a sound when a command completes, but that presupposes that I am actually at my desk when it does.
Michael:
I would like to have a buttons which will allow me to commit or rollback sql query results.
Mark:
I would love to be able to make SSMS customize background & font colors.
Editors Note: You can already do that in the text editor…
Goto Tools->Options->Environment->Fonts and Colors
The Settings I chose here result in a SSMS session that looks like the following image…
.jpg)
You can change the color of your results as well.
Ben
Featured Article(s)
Elemental MDX: Additional “Family” Members Functions, Part 3
Part 3: BI Architect Bill Pearson continues his Elemental MDX Series with an introduction to more member “family” functions. In this lesson, we will continue our exploration with the .FirstChild, .LastChild, .FirstSibling and .LastSibling functions, and then conclude the “family” functions group of articles with an examination of the Cousin () function.
Featured White Paper(s)
Why and How You Should Find and Fix Index Fragmentation
In a high-volume database you need frequent critical maintenance. If you skip this important task, index fragmentation may ca… (read more)
Featured Script
dba3_fn_TestFlowControl_AFlowControlFunction_Demo
Description: A simple flow control function demo…. (read more)