Video: MVPs talk about SQL Server 2008

Video chat with Brent Ozar and SQL Server MVPs Kevin Kline, Hilary Cotter and Geoff Hiten to talk about how SQL Server 2008 addresses DBA challenges and pain points. In this webcast, we cover features like Transparent Data Encryption, spatial data, and other new things that really differentiate SQL Server 2008 from 2005. Posted December 24, 2008. … [Read more...]

DBTA: The Future of Coding for SQL Server

In a two-part article over the next two months, I'm going to address an important issue for the SQL Server community: the future direction of coding for SQL Server, as directed by Microsoft. I'll start by telling you a bit about the current situation with writing code on and for SQL Server, and, in the next installment, talk more about the ramifications brought on by the current coding environment. I'm curious if you agree with my assertions.  You also have the added advantage of hindsight, since I wrote these a while ago. [READ MORE] … [Read more...]

Political Calculus – PASS Nominations

Pardon me, sir. Do I have a dog in this fight? After my term of service on the PASS board of directors ended in December of 2009, I fully intended to stay far, far out of the way.  It's an intention that I've largely been able to fulfill,excluding the odd conversation with an occasional board member or committee chair looking for a little impartial advice when weighing some consideration or other. If you keep up with going's on within PASS, then you'll know that there's been some hullabaloo lately.  Please reference paragraph 1 again at this point to understand that I don't really … [Read more...]

Plays Well With Others – Strong Leadership During Weak Budgets

   Many pundits are predicting that as the US emerges from its worst economic contraction since the Great Depression, business will bounce back with minimal new hires.  One of the primary ways that businesses grow their productivity without hiring more employees is to use information technology to automate processes that used to be done by real people.  But if the economy is still weak and the organization isn’t growing, that means life actually gets harder for those of us in IT because we’re being asked to deliver great returns to the company without allowing us to hire more people to get … [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...]

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

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

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

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

Google Wave is Dead. Long Live the Wave!

While enduring an endless series of flight delays and disgruntled passengers in the Baltimore airport that was my own personal travel hell on the evening of Thursday, August 5th, I came across this interesting and important article: http://bits.blogs.nytimes.com/2010/08/04/google-kills-wave-its-collaboration-tool/?ref=technology Even if you don't read the article, you can see from the URL that Google has decided to put an end to the collaboration experiment known as Wave.  Wave will be available through the end of the year and most of its major components are now available as open … [Read more...]