Webcast: Operational Excellence for DBAs, Part 1: Setup and Configuration
This session covers key setup and configuration questions faced when setting up a new SQL Server, from the bare metal configuration on up. *What difference does the CPU make? *How important is 32-bit versus 64-bit? *Should I virtualize? *What kind of disk subsystem do I need? *What edition of SQL Server is best for this application and how should it be licensed? *What’s a good "starter" configuration compared to a "high-end" configuration? *What difference do important SP_CONFIGURE settings make to system performance?
> Register Now
> Live date: 11/10/2010 at 12:00 Pacific
SSWUG TSQL Workshop: Coming this Friday, 11/12 "TSQL for the Rest of Us"
Our own Stephen Wynkoop will be presenting a workshop this Friday providing a foundation for those working with SQL Server databases. His focus is the key concepts of TSQL used to create, manage and retrieve data from a SQL Server database. Click here to visit the workshop page. You can read or get more info from the online video, and sign up to attend.
Featured White Paper(s)
Developing Something for Nothing with SQL Server: A Closer Look at SQL Server Express and How it Can Work for You
In this new Quest Software technical brief, learn about SQL Server Express – Microsoft’s free version of SQL Server – and how… (read more)
The Votes are In – SSMS Add In Requests
A while back I wrote about creating your own Add-In to SQL Server Managment Studio to extend or enhance the user experience when using it. I had a large number of responses I’d like to share today.
Mark:
I would love to be able to make SSMS customize background & font colors.
Editor (There is already a lot of color customization built in that you can take advantage).
Michael:
I would like to have a buttons which will allow me to commit or rollback sql query results.
When You in the testig or Development mode, you do not want to execute query that will modify you data all time
Wrapping statement in the transaction and executing commit or rollback statement separately is tedious job.
I always setting my Query executing mode to the IMPLICIT_TRANSACTION, but I still have to type and execute Commit or Rollback command separately.
Having this options as part of toolbar images or/and menu command will be very helpful.
Bob:
- 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.
Currently I get a meaningless file name, followed by not quite enough of the name of the connected server. Our primary development server has a number of instances installed on it, so seeing 1 SQLQuery17.sql – DEV-SQL01… as an item in that list doesn’t tell me what I was working on in that window at all.
- 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.
I didn’t have room for everybody today. I’ll post some more tomorrow. If you have ideas about the SQL Experience drop me a note at btaylor@sswug.org.
Cheers,
Ben