Video: SQL Server Memory Troubleshooting

Need to troubleshoot SQL Server 2005 memory settings? Not sure where to look to measure SQL 2000 memory pressure? Kevin lays out your options in today's podcast. You can view this video in higher quality or your favorite portable formats at: http://sqlserverpedia.com/blog/sql-se... Video published December 24, 2008. … [Read more...]

Video: Worth the Wait Why SQL Server 2008 is Great

Join Kevin Kline, SQL Server MVP and SQL Server Technology Strategist for Quest Software and Brent Ozar, SQL Server Domain Expert for Quest Software as they introduce the top ten features and capabilities in SQL Server 2008 that they find to be the most exciting and valuable. Originally Posted on YoutTube November 12, 2008. Follow me on Twitter! … [Read more...]

DBTA: What’s the Fuss about Data Deduplication?

Listen to a group of database professionals talk for awhile and someone will eventually bring up the topic of data deduplication. Data deduplication is a means  to eliminate redundant data, either through hardware or software technologies.  To illustrate, imagine you've drafted a new project plan and sent it to five teammates asking for input.  That single file has now been reproduced, in identical bits and bytes, on a total of six computers. If everyone's email inbox is backed up every night, that's another six copies backed up on the email backup server.  Through data deduplication … [Read more...]

My Biotronics pacemaker keeps my heart rhythm healthy, so I set it to Bassa Nova. … [Read more...]

https://kevinekline.com/15222-2/

...And what the heck is a "low-friction API"? I haven't heard too many developers complain about chafing. sqlpass … [Read more...]

https://kevinekline.com/15223-2/

DBTA: Security as an Afterthought

If you've read the IT press at all these days, you know that SQL Injection (SI) attacks are very common and can be devastatingly effective. In fact, SI attacks-equally easy to execute against Oracle, MySQL, IBM DB2, or Microsoft SQL Server-are among the most common hacks on the Internet today. If a web application runs a relational database on the backend, it can be subject to an SI attack, which ironically, is among the easiest web hacks to prevent. [READ MORE] … [Read more...]

Pirates of PASS: Curse of the Elections Process

Cross posted from Jorge Segarra's blog The last few weeks we’ve watched the drama unfold in regards to the PASS BOD elections. We’ve seen people attack criticize the NomCom, the board, PASS itself, the process and the decision of feeding of Gremlins after midnight. Thankfully the fireworks have died down and we can take a look at everything that has happened and make strides to move forward in a positive (and more importantly) constructive manner. Given that, I’ve been asked by my good friend Kevin Kline (Blog | Twitter) to respond to the following: Many in the community seem to think … [Read more...]

Carol McGury Speaks Out on Not-For-Profit Governance

I'd asked my friend and a form ED of PASS to add her thoughts about the governance process for not-for-profit organizations.  Carol is one of the industry's top professionals, serving as the chief operating officer for many years at some of the largest IT and non-IT professional associations.  I always look forward to her insight.  She writes... As an Executive Director for another user group community, I can offer up a few thoughts as it relates to Nominating Committee best practices. I’ve been working with technology and various vendors for over 20 years, and I’ve seen the community … [Read more...]

Cool Green Technology

Every little bit helps when it comes to alternative energy.  Experts are telling us that most alternative energy sources can, by themselves, replace only around 10% of our current carbon-based energy sources.  That means we need to do several different things, each providing 8% to 10% of our power needs, which will produce a sizable replacement of fossil fuels in aggregate.  This is a cool technology for apartment dwellers in big cities.  I could see this going down well in Vancouver, BC where every high-rise seems to be bristling with balconies.The details on the technology are located at … [Read more...]

Video: SQL Performance Optimization

Gain insight into best practices for SQL Server optimization and ways to alleviate many root causes that can impact performance of your SQL Server database. Kevin also will discuss how to manage for planned and unplanned changes, speed time to implementation of your applications and ensure that your databases are running as they should. You will learn how to: * Identify the root cause of bottlenecks that hinder performance of your SQL Server environment * Diagnose and fix T-SQL errors in development before code goes into production * Learn new best practices for project planning and … [Read more...]