Azure, a Beautiful Color, and So Much More…

Windows and SQL Azure Resources Cloud computing is more than just the latest buzz word in the IT trade papers.  It is a remarkable paradigm shift with as much potential to "turn over the apple cart" of IT computing as client-server had for the world of mainframe and minicomputers.  If you're not spending time to learn about cloud computing, in general, and SQL Azure, in particular, then you're missing the boat in a big way.  (Ha! Two big metaphors in one afternoon. My high-school English teacher would be proud.) There are mountains, literally MOUNTAINS, of free and high-quality content … [Read more...]

Video: Data Modeling in the SQL Server Space

Join SQL Server MVP and President of PASS, Kevin Kline as he: * Identifies the issues that can arise from relying only on modeling tools * Discusses the 10 most common modeling issues you will face when transforming data models from logical (conceptual) to physical * Describes how to correctly identify and resolve serious problems * Provides best practices to resolve issues Posted June 14, 2007. … [Read more...]

Quest Software announces Cassandra support in Toad for Cloud Databases and a partnership with Riptano.

My employer, Quest Software, Inc.  (QSFT 26.15, +0.68, +2.65%) today added Apache Cassandra, an open-source NoSQL database, to its list of supported NoSQL platforms with the second beta release of Toad(R) for Cloud Databases. Toad now supports data access and management for Apache Cassandra, Amazon SimpleDB, Microsoft Azure Table Services, Apache HBase, and any Open Database Connectivity-enabled relational database. Read the entire article here. … [Read more...]

Video: SQL Server Disk Optimization

Since the release of SQL Server 2005, companies have been investing heavily in SQL Server for their business-critical applications. DBAs are now challenged with supporting ever-growing datasets and making efficient use of allocated disk space in both production and enterprise storage environments. Yet DBAs seldom have a clear picture of their data storage and therefore cannot determine whether they are getting a worthwhile return on their storage investment or if an out-of-disk situation is looming. In this presentation, Kevin will address these challenges and explore methodologies to help … [Read more...]

Video: Maximize SQL Server Performance with SQL Tuning

This presentation is a bit old, but largely still applicable.  It will help you understand Microsoft tuning techniques. It will teach tips and tricks for making queries perform better, and how to use tools to tune SQL. Posted March 27, 2007. … [Read more...]

The All New LiteSpeed

LiteSpeed for SQL Server version 6.0 was released in June 2010 and includes these key features: Fast Compression Backups – Fast Compression is Quest’s patent-pending backup technology which significantly reduces backup times, improves database recoverable, and automatically reduces a database’s backup footprint by up to 85 percent over and above the backup compression algorithms already in the product. Network Resiliency – Backups will still succeed after network interruptions. User can also customize the number of retries and wait period for a finer level of control. Easier Restores … [Read more...]

Toad Just Keeps Getting Better

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 … [Read more...]

New on SQLMag – Automating the Startup and Shutdown of Windows Services

I just posted a new blog entry on how I automate the shutdown and startup of Windows services. Check it out at http://www.sqlmag.com/blogs/tool-time.aspx.  Be sure to let me know what you think and if you have your own unique methods for automating the control of Windows services! Many thanks, -Kevin -Twitter @kekline … [Read more...]

New Interview and SQLMag ToolTime Blog Article on “SQLClue”

A neat new administration and configuration management tool for the SQL Server set.  I especially like the Run Book features, because Run Books are the way us "oldtimers" like to run our IT infrastructure.  My pal, Buck Woody, also likes Run Books (and really big explosions by the guys on MythBusters, but that's another discussion).  Find all the details about the new tool, created by Bill Wunder, here. In addition, I'm honored and amazed that the team at RunAsRadio invited me to participate in interview #143.  These are the same guys who also put together one of the best and longest … [Read more...]

The Awesomeness of ROBOCOPY Now at SQLMag

If you're like me, you've used Ctrl+C/Ctrl+V more than a time or two, but you've always felt a little dirty afterwards.  Yeah, you can use the command-line COPY or XCOPY utilities.  But they're decidedly 20th Century, much like some of the laundry still loitering under my office couch. So I spent a little time over the holidays cleaning up my file system by scripting a backup routine using the very cool and very free ROBOCOPY utility.  Now, I've got a regularly scheduled job that, after the first run which captured all my files, only backs up new or changed files (and directories) while … [Read more...]