Fast Features for Quest Tools. Someday soon, I promise.
I’ve been trying hard to get more videos out the door about the SQL Server tools from Quest Software (my employer). I’d sent a new one over to the program marketing team a while back, but it’s not showing up in the Coffee Break Bytes section like it should. These little videos show a single feature in detail, usually taking no more than 5 minutes to watch in their entirety.
In the meanwhile, check out the excellent video series here. And the blogs are really good too, available on the interwebs here.
Thinking about cloud computing?
Well, there aren’t many tools out there that will make your life easier than Toad for Cloud Databases. As is most cloud technology, this particular tool is still in beta. But there’s no better time to help set the direction and features of a tool with as outstanding a record as Toad. Get the details and download the beta here.
And if you like providing feedback to the development team, don’t overlook the IdeaPond where you can provide your own ideas and vote on others that are already posted. (Currently targeted towards Oracle users, but I say let’s crash that party)!
Toad for SQL Server Wins Best of TechEd 2010 in the Database Development Category
Toad and I go way back. I first started with Toad as a user on the Oracle DBMS back in the early 1990′s. When I started at Quest Software back on January 2nd of 2002, one of the first products I tackled as a SQL Server product architect was Toad. How do we make this very popular Oracle product one that users in the SQL Server world will love too? And this challenge was made that much harder by the fact that Microsoft SQL Server ships with fantastic tools right there in the box. I haven’t worked directly on Toad for many years now, but the tool marches on with new features and capabilities that push the envelop with each new release.
L to R: Jason Hall, Qsft head of SC's; David Gugick, director of Architecture; and me
Want to try Toad for SQL Server for free?
The 5.0 version of Toad for SQL Server that we showed at TechEd is the latest beta, available at ToadWorld.com (build 387 at the time of this writing). It can coexist with Toad for SQL Server version 4.6, if you’re already using it. The beta is quite stable and has a bevy of new features, including:
SQL Azure support for most modules including data compare and schema compare, including comparing regular SQL Servers to SQL Azure and back, also with Firewall management (under Server Security properties panel).
Much improved code completion that’s faster and allows for column selection, multi-table selection, with tooltips for parameters. Don’t forget, all of these features work on SQL Server 2000, 2005, 2008, and 2008 R2.
Updated Schema Compare with better exposed snapshots.
Group Execute enhancements that include database-level selection so you can execute across databases, an option to only show selected servers/databases, option to merge results (or not), improved merging, etc.
New Idle Connection Timeout – to close connections after a period of inactivity.
Result Set Pinning.
Improved Trace support with features like Import Trace File to Table and Open in Profiler capabilities.
New Debug Trace – traces all activity occurring inside of Toad, including storing all variable info in a replayable file.
Twitter Integration (under the View – Collaboration panel) with Yammer integration coming in a future beta release.
You can also see a lot more details about the tool here. And my long-standing offer still stands. If you want to try Toad for SQL Server or its brethren (such as Toad for Data Analysts, Toad Data Modeler, or Benchmark Factory), drop me an email and I’ll get a long-term license key straight over to you.
But wait, there’s more!
There are so many great resources for you to tap into. And best of all, they’re all free! Check these out:
In this white paper, renowned Oracle PL/SQL expert and fellow O’Reilly author Steven Feuerstein provides dev managers with guidance on how to help developers write the best software possible.
Live Product Demo:Toad® Data Modeler
Date: Wednesday, June 16, 2010
Time: 11:00 a.m. PT / 2:00 p.m. ET
We’ve got two sessions that you (the “we” meaning the fine folks at Quest Software) need to sign up for right away. The upcoming webcast for Oracle-oriented folks has huge registration numbers. And I’m sure you’ll learn more than you expected thanks to my fine co-presenters. Get in while you still can before we hit the limit of what LiveMeeting can handle!
Webcast:SQL Server for the Oracle DBA Date:Thursday, May 27, 2010(Just a couple days hence!) Time: 8 a.m. Pacific / 11 a.m. Eastern / 4 p.m. United Kingdom / 5 p.m. Central Europe Duration: 45-60 minutes Cost:FREE
In enterprise IT, database professionals face a mixed-bag of platforms within their environments — and the overlapping duties that go along with them. Whether you like it or not, you get asked to support Microsoft SQL Server operations even though you’re an Oracle DBA.
In this instructive webcast, experts from Microsoft and Quest with years of experience in both platforms will discuss the biggest issues and areas of interest for Oracle DBAs who need to work on Microsoft SQL Server. You’ll learn their tips and tricks for efficiency and gain a deeper understanding of SQL Server to help you add more value than ever to your organization.
Presenters: Kevin Kline, SQL Server MVP, Quest Software Buck Woody, Senior Technology Specialist, SQL Server, Microsoft
Webcast:Easy Ways to Fix Hard SQL Server Problems – Without a Guru Date: Thursday, June 17, 2010 Time: 8 a.m. Pacific / 11 a.m. Eastern / 4 p.m. United Kingdom / 5 p.m. Central Europe Duration: 45-60 minutes Cost:FREE
In this instructive webcast, you’ll learn straightforward methods for troubleshooting and resolving common poorly performing stored procedures and queries in SQL Server 2008. The presenters will show you how to easily:
Read query execution plans and identify bottlenecks in performance
Record system performance metrics for trend analysis
Design databases and write Transact–SQL code to avoid common problems
Understand what an index is, what it does, and how to build one
Use industry-accepted best practices and develop your own to arrive at optimal database performance
Don’t miss this chance to get practical advice from working experts instead of just theories from academics! Presenters: Kevin Kline, SQL Server MVP, Quest Software Grant Fritchey, “Scary” DBA from FM Global
Let me be direct with you. I love SQL Saturday. If it were a woman, I’d marry it. (Avoiding all extraneous thoughts of what my real wife would say, etc etc).
Check out this fun Flickr Feed from the recent SQL Saturday in Chicago or these picks by Jorge Segara (blog | twitter) to see the sort of fun that’s in store. But who can argue with a day of free SQL Server training and a chance to network with great presenters and a wide swath of your peers?
Keynotes are more fun when the put-downs fly!
I’ve tried to support SQL Saturday as much as I can since Andy Warren (blog | twitter) launched the program a couple years back and have spoken at several. You might say to yourself, “Self, Kevin works for a vendor. Don’t they want him to speak at as many SQL Saturdays as is humanly possible?” Well, Mr. Self, you’d be mistaken. You see there’s a keyword in the name that might reveal why my employer doesn’t provide unlimited enthusiasm for me to speak … it’s the SATURDAY part of the whole thing. Yes, of course, my employer wants me there. But they also recognize that Saturdays are my own and that, if I spend a day or two there on the weekend (including the travel time), then that’s a sacrifice of my own choice. I would still need to be at work and on task bright and early on Monday morning. Not that they’d make me, it’s just that my job is the sort that work is never simply skipped, it is only ever deferred. So if I took a comp day, which they’d gladly provide, I’d still have to finish the work somehow, someway. All of this goes to say that I really, really love SQL Saturday, the community vibe that it creates, the volunteers who drive it, the folks who attend. So I’m happy to give up a few days throughout the year to support it.
Come to Nashville in August!
Guitar, Cowboy Boots, Cowboy Hat, and Tight Denim NOT Required
My good friends Joe Webb (blog | twitter) and Louis Davidson (blog | twitter) have been angling to host a SQL Saturday here in Nashville for quite a while. As co-leaders of the local PASS chapter in middle Tennessee, it made a lot of sense to host an event like this. I wasn’t at all resistant to the idea, I just didn’t want to do the work myself. However, they did a great job of getting the ball rolling and even took on the majority of work themselves. Together with other volunteers in our local chapter – Shelton Dickson, Roberto Lopez, and Christina Leo – we’ve all set to work to host SQL Saturday #51.
The event will be hosted on Saturday, August 21st at the shiny new facility of Nashville State Community College located at 120 White Bridge Rd. Nashville, TN 37209:
If you’d like to attend, check out all the details here. Joe Webb and Christina Leo get all the credit for logistics.
If you’d like to speak, read the details in our call for speakers here. Louis Davidson is running the program selection process.
If you’d like to sponsor, sign up on-line here. This one is my responsibility.
It’s free to register, there is a $10 fee if you want us to provide lunch. And remember, seats always fill up fast!
If you’re going to attend and you have a twitter account, be sure to tweet using #sqlsat51!
PASS is looking forward to having you join us all for this exceptional event. Please contact us at 24hrs@sqlpass.org with any questions. You can also find lots of general details at http://www.sqlpass.org/24hours/2010/.
Join me tomorrow for the PASS DBA Virtual Chapter meeting SQL Server Internals & Architecture. It’s the most fun you’ll ever have learning about the inner workings of a relational database – I promise!
You don’t have to register to attend. But if you register today, you’ll be entered into the drawing to win one two copies of my bestselling reference SQL in a Nutshell, covering the ANSI standard plus Oracle 11, SQL Server 2008, MySQL 5.2, and PostgreSQL 8.3.
This is NOT the Chameleon in the Bud-Wise-ER commercials. At least I think it's not.
I’ve put the slide deck up in my Slides area of the website. However, because it contains a lot of big images, I had to publish it as a PDF file to meet my size limits. That means that all of the animations in the slide deck are shot – and this presentation relies heavily on animation.
The Modern Language Association hasn’t made up all the new rules yet to govern how one blogger should reverence, er, reference another in their blog posts. But they should! Let’s get that ball rolling for them.
I’m not exactly sure who started this format, but it’s my favorite. When writing a blog post in which you mention another person’s blog, let’s do it like this:
“blogger name (blog_hyperlink | twitter_hyperlink)”
So, we might read a blog post by my friend Kimberly Tripp (blog | twitter) that might look something like this:
“…the Scottish Terrier was so well known in early American society that as recently as the 1910′s, Manhattanite nannies instructed their young charges to be good else the “Scottish Terrier” would eat them, after a lengthy session of slobbery nuzzling and years of canine devotion. It is for this very reason that I’ve given my Scots/English husband, Paul Randal (blog |twitter), several variations of the nickname “Scottish terrier”, “scotty”, “snotty”, and “scotsnots” until such a time as needed for me to roll up the newspaper, give him a good spanking, and stick his nose in …”
Well, you get the point. And didja notice that I worked in not just one, but TWO entire examples of the blog-reference syntax?!? I can hardly believe my own craftiness. I went to university for four years to learn that y’know – and to learn how to funnel beer – but I digress.
The Call To Action
One thing I love about the SQL Server community is our very community-ness. (I also like the fact that you’ll let me invent stupid words on the fly without too much criticism.) So, let’s make the glob, {ah! damned dyslexia!} , blog reference business even easier by having you (yes, YOU) post your own blog & twitter links as a comment here.
I repeat – post a comment here containing your name, blog (with embedded hyperlink to your blog), and twitter (with embedded hyperlink to my twitter, er, YOUR twitter account).
I’ll then repost a brand new shiny article with a full compendium to everyone’s blog & twitter hyperlinks (except Brent Ozar’s (blog | twitter) ) which you can save to some obscure cranny of Outlook or WordPerfect to call up at a moments notice when the urge to both blog and reference other bloggers strikes you.
Thanks and looking forward to seeing your blog reference soon!
Everybody enjoys a little free training now and then. I’ve got mountains of free training in the works. Some of it is in-person and local while some are in webcast format. Please join me as you’re able!
There are a short list of mistakes that, if you know of them in advance and prepare for them, will make your life much easier. This presentation shows you these mistakes, the “low hanging fruit” of database administration. Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before. Quest is sponsoring this and raffling off a copy of my book, SQL in a Nutshell, and O-M-G a KINDLE!!! (Free, but registration required.) And if you haven’t already done it, join PASS!
SQL Injection attacks is the most common hacker trick used on the Web and yet, one of the easiest to prevent. Learn what they are and why you need to be concerned about them. In this webcast, I and SQL Server MVP K. Brian Kelley (blog | twitter) will demonstrate different types of SQL injection attacks. You’ll learn how to find and block them to keep your databases safe, preventing disruptions to your organization. Quest is sponsoring this as well and raffling off more goodies. (Free, but registration required.)
Stereotypes abound for different types of people in the IT world. Developers think DBAs are control freaks. DBAs think developers are unruly cowboys. How do we overcome these differences? If you’re a developer, your best strategy is to manage your DBAs’ anxieties and demonstrate your competence and credibility. Attend this session to learn about 10 techniques that developers can apply to their code which will calm your DBAs’ fears and earn their admiration. Techniques include how to analyze a query plan and how to make sure your query is taking advantage of the best available indexes. Attendance is free although registration is encouraged so we can get a good count for the food, plus there’s free pizza and a raffle at the end. Drinks afterwards at Chilis.
Join SQL Server MVPs, Kevin Kline and Brent Ozar (blog | twitter), along with Quest Product Manager Ari Weil —all from Quest Software—as they interactively present tips and tricks to help you monitor your SQL Server environment with ease. You’ll learn how to use Dynamic Management Views (DMVs) to simplify troubleshooting and significantly enhance SQL Server performance. The day consists of eight sessions with live Q&A – a great way to get answers to your questions straight from the source. Chat live with Quest experts. Plus, you can visit the Quest booth to download helpful resources like white papers, watch demos and more. This virtual training day is free and you can attend the sessions that fit your needs – perfect for tight budgets and busy schedules.
The SQL Server Community will experience an event like no other in the Southeast region. Renowned speakers from around the world will gather in Charlotte, NC to share their knowledge on Microsoft SQL Server. This is your opportunity to meet, network with and learn from the SQL Community leading experts such as Andrew Kelly, Rick Heiges, John Welch, Brian Knight, Geoff Hiten, Andy Warren, Jessica M. Moss, Rafael Salas, Sergey Pustovit and Tim Ford. Also scheduled to present are current SQL PASS President Rushabh Mehta and former SQL PASS Presidents Wayne Snyder and Kevin Kline.
