Video: The Growing SQL Server World- Surviving the Data Avalanche

An expert roundtable discussion hosted by SQL Server Expert Kevin Kline and featuring speakers from Microsoft, EMC, Avanade, HP and Quest Software. With the release of SQL Server 2005 and its focus on Business Intelligence, SQL Server professionals are faced with unprecedented amounts of data to manage. How are you dealing with the flood of data? At the PASS Community Summit 2006, experts from Quest Software joined forces with a variety of other SQL Server industry experts for a panel discussion around the implications of managing large volumes of business critical data on SQL Server and … [Read more...]

DBTA: The Trouble with Third-Party Applications

Third-party applications are a very important part of the IT landscape. Many of us have faced the common dilemma of trying to decide whether to build or buy that next important application our organizations need. (By the way, I'm talking about smaller, specialized applications like an inventory management system for the company warehouse, or a practice management system for a doctor's office. I'm not talking about the huge and incredibly sophisticated ERP systems like SAP and Oracle Financials.) [READ MORE] … [Read more...]

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...]

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...]

Toad for Cloud Databases Community is now live!

Quest Software is proud to announce the launch of the Toad for Cloud Databases community site.  You can also get the free Toad for Cloud product here.  It's in beta, but definitely worth a try. If you've wondered what's over the horizon, I encourage you to take a look at this interview with Billy Bosworth, the head of Quest's database tools group.  (Yes, he's the guy who signs my checks).  We are now experiencing more disruptive technologies in the world of data than we have seen in nearly two decades. Perhaps your database is better suited for the cloud or maybe you want to investigate … [Read more...]

Presentation: SQL Server for Oracle DBAs

Back in late May, my pal Buck Woody (blog | twitter) and I presented SQL Server for the Oracle DBA.  Buck played Jerry Lewis' role, while I played the straight man a la Dean Martin.  You can see the recording and slide deck here.  Since both Buck and I spent a considerable number of years working on Oracle, we felt like we had pretty good legs to stand on doing this presentation.  Here's the abstract: 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 … [Read more...]

In-Memory Databases (IMDBs)

Moore's Law tells us that CPU's get a LOT faster over time.  Unfortunately for the database professional, all of the secondary elements of our databases DO NOT get a lot faster over time.  Overall, the main methods of storing data since the 1960's, magnetic tape and hard disks, have improved only in the single percentiles year over year.  Even those of us who were never good at math can tell that the CPU is outpacing the other system components. Two recent developments are helping to change that equation.  First, solid state drives (SSDs) are having a dramatic impact many IT scenarios. … [Read more...]

Live! TechNet Radio: Microsoft Cloud Services – SQL Azure

Just wanted to let you know that a TechNet Radio episode and interview I did about cloud computing is now live on TechNet Edge. It was the featured spot on Thursday, June 3rd and is also featured on the TechNet homepage. I've been trying to wear more of an analyst's hat these days, so this webcast has a lot of my "deep thinking" on issues related to cloud computing - hopefully at a higher level of quality that Jack Handy. A salient point that I think many analysts are overlooking is the changing nature of data as it exists in the cloud.  For decades, data has primarily been about people … [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...]