Video: Interview – Part 2 SQL Server Evolution

Heather Eichman interviews Kevin Kline, the former President of PASS and strategy manager for the SQL Server Business Unit at Quest Software. It's not brand new - originally posted January 28, 2008. … [Read more...]

What’s Your Data Management and Retention Policy? [DBTA]

If managing your corporate data for the long term isn't currently on your mind, it should be, and in several different ways: cost, performance, business continuity, and compliance. [READ MORE] Originally posted on Jun 7, 2010 … [Read more...]

DBTA: Growing Like Weeds – Explosive SQL Server Grassroots Growth

One thing I really enjoy about the SQL Server community is its vibrancy.  I'll give you details on the SQL Server community's explosive growth in a moment, but let's start by comparing Microsoft SQL Server's user community with those of other significant database platforms. [READ MORE] Posted May 10, 2010 … [Read more...]

Video: Ensure Optimal Performance When Deploying SQL Server 2005

Kevin Kline will offer insight into best practices for SQL Server 2005 set up, configuration and queries. He will also discuss tuning for both the server and hardware to help an application perform better after it is deployed. This presentation will offer a better understanding of several SQL Server performance related areas including: * Hardware design * SQL Server configuration settings * Database configuration settings * Application design * SQL Tuning Posted December 20, 2006. … [Read more...]

DBTA: The NoSQL Movement- Hype or Hope?

If you spend any time at all reading IT trade journals and websites, you've no doubt heard about the NoSQL movement.  In a nutshell, NoSQL databases (also called post-relational databases) are a variety of loosely grouped means of storing data without requiring the SQL language.  Of course, we've had non-relational databases far longer than we've had actual relational databases.  Anyone who's used products like IBM's Lotus Notes can point to a popular non-relational database.  However, part and parcel of the NoSQL movement is the idea that the data repositories can horizontally scale with … [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...]

DBTA: Forecasting SQL Server in 2010

After the misery  that was 2009, most of the SQL Server users I talk to are happy that 2010 started in languid fashion. Not that there isn't a lot of work to do; on the contrary, there's more work than ever. However, the long hours and multiple projects of 2009, compounded by freezes in all levels of spending, raised the general stress level to unhealthy heights. With the new year, stress levels dropped significantly, and many IT leaders see signs of improving prospects. What does that bode for 2010? I have a couple of predictions, though I doubt they'll surprise many people. [READ … [Read more...]

Paying It Forward With Project Phoenix

It seems like I've known Arnie Rowland (blog | twitter) since the dawn of time.  But it's really more like the last several years, or at least since Arnie achieved Microsoft MVP status, that I really got to know him.  Arnie has also been trying to get me to speak to the user group he leads in Portland, but coordinating it has been fiendishly difficult.  I hope to get out to Portland in 2011 (no promises, Arnie!!!). One of the activities that Arnie is leading that has deeply impressed me is Project Phoenix.  Described here: ...we are inviting unemployed or underemployed developers to … [Read more...]

Video: Microsoft Master Certification Program

On this vblog entry on www.sqlserverpedia.com I describe and discuss the Microsfot MCP (Master Certification Program). I hope this helps anyone that is interested in this program. Enjoy and I look forward to your feedback! Posted September 09, 2008. … [Read more...]

Microsoft SQL Server High-Availability Videos and Q&A Log

You Want Videos? We Got Videos! I always enjoy getting the chance to catch up with author, consultant, and Microsoft Clustering MVP Allan Hirt.  Allan and I recently presented two sessions covering an overview of high availability in Microsoft SQL Server and, the following week, a demo of how to implement several different kinds of high availability techniques including database mirroring, transactional replication, and Windows clustering services. You can see videos of these presentations at the Quest Software Pain of the Week webcast site. Archives of other videos are here. We're … [Read more...]