One of the things that I enjoy about working for Quest Software is that we give back copiously to the community. From activities and offerings like SQLServerPedia, to our free posters mailed anywhere in North America (and don't forget the free hi-res PDFs for the rest of the world), Don't forget that free DVDs of our virtual conferences featuring me, along with Buck Woody (blog | twitter) and Brent Ozar (blog | twitter) will be mailed anywhere in North America free of charge, now available at this link. Enjoy! -Kevin Twitter at kekline More content at http://KevinEKline.com … [Read more...]
Totally Awesome and Totally Free Training SQL Server Training
Filed Under: Administration, Challenges, On-Line Resources, Presentations, Professional Development, Tips & Tricks, Video Tagged With: Best Practices, DBA, Developer, Professional Development, Training
Database Maintenance Scripting Done Right
I first wrote about useful database maintenance scripts on my SQLBlog account way back in 2008. Hmmm - now that I think about it, I first wrote about my own useful database maintenance scripts in a journal called SQL Server Professional back in the mid-1990's on SQL Server v6.5 or some such. But I digress... Anyway, I pointed out a couple useful sites where you could get some good scripts that would take care of preventative maintenance on your SQL Server, such as index defragmentation, updating statistics, and so forth. One of the script kits came directly from Microsoft's internal … [Read more...]
Filed Under: Administration, Challenges, Databases, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, Tool Time Tagged With: Best Practices, DBA, Performance, SQL Server 2008 R2, Tools & Scripts
Education and Career Resources from Microsoft and the Community
Sometimes I'm timely in getting the news out on useful resources. And, other times, I'm a bit slower on the draw. As I told friends back at New Year's Day, "As an official member of the Procrastinators Club, welcome to 2008!" On the other hand, it's always good to remind folks of great resources that are still available and on the shelf. Why? Well, the Internet hits us with such a deluge of constantly new material, that we often forget about the old(ish) stuff that's still really useful. Quest vConference for SQL Server One of the most popular teaching sessions I ever engaged … [Read more...]
Filed Under: Administration, Databases, On-Line Resources, PASS, Presentations, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Tips & Tricks, Video Tagged With: Career, DBA, Developer, Professional Development, Quest Software, Training, Women in Technology
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...]
Filed Under: Administration, Databases, Presentations, SQL Server, SQLServerPedia Syndication, Video Tagged With: DBA, Developer, Quest Software, SQL Server 2008
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...]
Filed Under: Administration, BigData, Challenges, DBTA, Hardware, IO, Opinion, SQLServerPedia Syndication, Trends Tagged With: DBA, DBTA, High Availability, Internals, Performance, SQL Server 2008 R2
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...]
Filed Under: Administration, DBTA, Opinion, SQL Server, SQLServerPedia Syndication, Trends Tagged With: DBA, DBTA, Security
Videos: Strategies for Addressing Common SQL Server Challenges
As a busy SQL Server DBA you face an increasing number of daily challenges: Managing fast growing data volumes and database environments Diagnosing and resolving performance issues Effective backup and recovery Monitoring and tracking database changes Balancing current resources against future capacity needs Inefficiencies in any of these areas can lead to performance degradation, unauthorized database changes, and unplanned, extended downtime. Webcast originally presented by renowned SQL Server expert Kevin Kline and learn valuable strategies for addressing these challenges … [Read more...]
Filed Under: Administration, Challenges, Databases, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Strategies, Tips & Tricks, Video Tagged With: Best Practices, DBA, Developer, DMV, Internals, Monitoring, Performance, Quest Software, SQL Server 2005, Tools, Tools & Scripts, Video
Video: SQL Server Disk Optimization
Since the release of SQL Server 2005, companies have been investing heavily in SQL Server for their business-critical applications. DBAs are now challenged with supporting ever-growing datasets and making efficient use of allocated disk space in both production and enterprise storage environments. Yet DBAs seldom have a clear picture of their data storage and therefore cannot determine whether they are getting a worthwhile return on their storage investment or if an out-of-disk situation is looming. In this presentation, Kevin will address these challenges and explore methodologies to help … [Read more...]
Filed Under: Administration, Challenges, Hardware, IO, Opinion, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Tool Time, Video Tagged With: Best Practices, DBA, Developer, DMV, Internals, Monitoring, Performance, SQL Server 2005, Tools & Scripts, Video
DBTA: The Ebb and Flow of SQL Server Instrumentation
Microsoft SQL Server's relational engine has offered new instrumentation that improves by light years with each new release. The introduction of Dynamic Management Views (DMVs) in SQL Server 2005 provided a much-needed equivalent to Oracle's long-standing and capable V$ and X$ system views. SQL Server 2008 has provided another dramatic improvement to its instrumentation with Extended Events (also known as XEvents) that promises to offer even greater opportunities to tune, trace and troubleshoot the inner workings of a SQL Server application. All of this stands in stark contrast with the … [Read more...]
Filed Under: Administration, DBTA, Opinion, SQL Server, SQLServerPedia Syndication, Trends Tagged With: DBA, DBTA, Developer, DMV, SQL Server 2008 R2
DBTA:A Look at Upcoming Enhancements in SQL Server 2008 R2
At a rather muted Microsoft TechEd in Los Angeles in May, the crowds were diminished and the educational content was slimmed down. In the past, SQL Server sessions were so abundant that you'd have trouble choosing which of several you might want to attend. This year, the state of the economy was reflected in many ways, including the one, or, in just a few cases, two sessions per time slot allotted SQL Server professionals. Despite the low ebb, the Microsoft SQL Server team made an exciting announcement about the upcoming availability of the SQL Server 2008 R2 CTP (Community Technology … [Read more...]
Filed Under: Administration, Databases, DBTA, Opinion, SQL Server, SQLServerPedia Syndication Tagged With: DBA, DBTA, Developer, news analysis, SQL Server 2008 R2
