Archives for August 2010

DBTA:Reaching for Highly Scalable Systems with SQL Server 2008

SQL Server has supported VLDBs (very large databases) for some time now. Back in the SQL Server 2000 days, I recall hearing multi-terabyte databases were unusual but doable. Now, they are commonplace, while databases in the hundreds of terabytes inhabit the part of the map that says "there be dragons." While VLDBs are quite common on SQL Server today, highly scalable systems that can be flexibly extended in the same fashion as Oracle/RAC are less so. So, how do you design a highly available architecture for SQL Server if it's not like Oracle/RAC. [READ MORE] … [Read more...]

Free Poster – SQL Server Dynamic Management Views

I enjoy working at Quest Software partly because we do a lot to give back to the community. Here's one example, a free poster describing all of the SQL Server 2005 and 2008 dynamic management views.  Get it here.  It's the perfect compliment to the free system map poster available from Microsoft here. … [Read more...]

Plays Well With Others – Inaugural

Professional Development for the SQL Server Technologist This series of posts is dedicated to enhancing your soft skills.  For many technologists, the day-to-day grind of work tends to keep us focused on the SQL Server part of work and causes us to overlook the Professional.  While we, as technologists, spend the majority of our time honing hard, technology skills, but it’s important to remember that we are first and foremost employed to add value to the business processes of the organizations we work for.  In this series I will cover a wide variety of topics, including soft skills like … [Read more...]

Free Software for Unemployed Developers

Each month, for six months, Arnie Rowland will  be giving away a package of software, books, training, and development tools, valued at over $15,000, to an unemployed or underemployed developer that takes on a software project of his/her choice with a non-profit. "The idea is to provide the recipient access to all of the tools needed to improve his/her skills, an opportunity to gain practical experience, the potential to earn a recommendation and/or referral –and to positively contribute to society as a form of 'give-back'. No free lunch, just sweat equity –the kind that makes us all feel … [Read more...]

Video: Quest Software Set to Be SQL Server “Rock Star” at PASS 2007

Watch a full interview with Kevin Kline, president of PASS and technical strategy manager, SQL Server, Quest Software as he discusses the evolution of SQL Server. Posted September 17, 2007. … [Read more...]

DBTA: Long-Term Changes Resulting from Policy-Based Management

It doesn’t seem like it was that long ago that my company’s IT department was bracing for a major new line of work. Back in the mid 1990s, we were going full steam into client-server technology. At the same time, we were significantly expanding our workforce. The IT department that had spent years as an old-style mainframe shop, was suddenly inundated with requests for new workstations, network user IDs, new network domains, permission requests, and requests for application access privileges. Our lone mainframe permissions person quickly felt overwhelmed and a little baffled by all of these … [Read more...]

Video: Interview – Part 4 SQL Server Community

My Vlog- Heather Eichman interviews Kevin Kline, the former President of PASS and systems specialist for the SQL Server Business Unit at Quest Software. Posted February 04, 2008. … [Read more...]

DBTA: The New Master’s Certification from Microsoft

In July, Microsoft announced its new advanced training and certification program known as the Master’s Certification. (Read more about it at http://www.microsoft.com/learning/mcp/master/default.mspx). I’m really excited about this new certification because it fully lives up to the standard of “the appropriate certification for the appropriate audience.” For one thing, if you’ve ever gone to a martial arts school, you may find many talented martial artists and even several black belts there, but you’ll rarely find more than one “master.” Expect this new SQL Server certification to be equally … [Read more...]

Join O’Reilly on Facebook

O'Reilly Media on Facebook is a place for for anyone who is a fan of O'Reilly, whether you've been following their books, conferences, webcasts, and more since the very beginning or you recently jumped onto the bandwagon. I really enjoy the newsletters and blogs from O'Reilly's various channels, especially Tim O'Reilly's commentary. And, of course, there's my book - SQL in a Nutshell - published by O'Reilly for your consideration.  This book provides a complete reference of the latest release of the ANSI SQL standard, as well as full coverage of support for the ANSI standard from the … [Read more...]

Video: Worth Upgrading to SQL Server 2005

Why companies should upgrade their databases to SQL Server 2005. Please forgive posting this old video.  Many of the tips are still worth paying attention to since SQL Server 2005 features and technologies are the foundation of subsequent releases.  Posted December 19, 2006. … [Read more...]