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)!
You may have seen a new super sleuth around Quest.com and Toad World – The Data Detective!
Everyone wants good data, but not everyone wants to work hard to get it
The team at Quest Software has created a new comic series where users can learn how Toad for Data Analysts will help you find, understand and report on data. Plus, you can take part in a contest to win a free one-year license of TDA!
The first in the comic book series is posted here. And there’s one each month. If you contact me directly, I can help you get to the front of the line for the contest!
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/.
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.
Please join me for SQL Saturday #21 coming up on Saturday, October 17th. There are over 50 sessions on tap with great speakers from the area and across the nation. Some of the notable speakers include:
Not only do we have SQL Saturday coming up, but Andy & company put together five world class seminars the week leading up to it! Use code “KKLINE” to get a 20% discount if you register for two or more seminars!
Seminars will be held at the Embassy Suites in Altamonte Springs, FL. Each seminar is $149 and includes a full lunch. Seating is limited, register today!
Attendees of my seminar will get a free copy of my book, Database Benchmarking: A Practical Approach for Oracle and SQL Server, plus other free goodies from my employer, Quest Software. As an added note of explanation, Buck’s excellent seminar centers around detecting and troubleshooting performance problems, while my seminar focuses on writing high-performance and highly scalable SQL and Transact-SQL code. Why not sign up for both of them to get comprehensive education on the entire process of writing great code, deploying it, and monitoring it for continued excellent performance?
Finally, I’ll be speaking at user groups in the area leading up to SQL Saturday. If you can join me at my seminar or at SQL Saturday, maybe one of these other events better fits your schedule:
Tuesday, Oct 13, Tampa SQL Server User Group (http://www.tampasql.com)
Wednesday, Oct 14, Orlando SQL Server User Group (http://www.opass.org)
Friday, Oct 15, Jacksonville SQL Server User Group (http://jacksonville.sqlpass.org)
Any IT pro with more than a year or two of experience will have faced the challenges of version control for an application, but what if you have to implement version control for data?
The most common way to tackle this problem is implementing something called “bitemporal data”. Under this method, each row in a table includes the current valid time and the transaction time. Since two distinct time values are stored, we get the term bitemporal.
A great place to start is Adam Machanic‘s excellent article at http://www.simple-talk.com/sql/t-sql-programming/a-primer-on-managing-data-bitemporally/. In addition, I encourage you to check out Adam’s book “Expert SQL Server 2005 Development” at http://www.apress.com/book/view/9781590597293.
In addition, Dejan Sarka pointed out that you can get a very comprehensive information on supporting temporal data from a book entitled “Developing Time-Oriented Database Applications in SQL” by Richard T. Snodgrass. Mr. Snodgrass was so kind to publish the book in PDF format and make it available for free download at http://www.cs.arizona.edu/~rts/publications.html. (Note that the book is quite old now (year 1999), so the T-SQL code does not include any SQL Server 2005 or 2008 enhancements. But the basic SQL is still solid.
