Interested in my various performance tuning and troubleshooting videos about SQL Server? These videos feature my good buddies (and uber-SQL Server experts) Brent Ozar (blog | twitter) and Buck Woody (blog | twitter). View these insight-packed training videos from our SQL Server training events originally presented on March 3 and July 21 of 2010:HERE. You can watch the videos now at the URL above or order a DVD, shipped free of charge in the USA and Canada, HERE. Enjoy! -Kev ~~~ Twitter at kekline More content on my Blog … [Read more...]
Available Online – SQL Server Training Videos
Filed Under: Administration, Challenges, Databases, IO, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Best Practices, DBA, DMV, Internals, Monitoring, Performance, Quest Software, SQL Server 2008 R2, Video
From SQLMag Tool Time Column: SSMS Plug-in News
I first wrote about Mladen Prajdic's excellent tool in my Tool Time column at SQL Server Magazine HERE. The tool is a nice plug-in to SSMS and definitely worth having. If you’ve never installed it or have only installed an older version, but sure to pick up the newest release. Here’s Mladen’s press release complete with hyperlink for the tool: SSMS Tools Pack 1.9.4 is out! Now with SQL Server 2011 (Denali) CTP1 support. As Mladen says: ...this release adds support for SQL Server 2011 (Denali) CTP1 and fixes a few bugs. Because of the new SSMS shell in SQL 2011 CTP1 the SSMS Tools … [Read more...]
Filed Under: Databases, SQL Server, SQLMag, SQLServerPedia Syndication, Tool Time Tagged With: DBA, Denali, Developer, SQL Server 2008 R2, SQLMag
SQL Server Migration Roll-Up
There are so many great tools out there for data professionals using Microsoft SQL Server. I really like to see all of these great tools made free to the public. On the other hand, I'm bummed that the tools are cast about in a very decentralized fashion. If you haven't done migrations before, you might want to start with these good white papers first. Here are a hand full of cool migration tools worth mentioning: Microsoft SQL Server Migration Assistant (SSMA) for MySQL: Migrate from MySQL to SQL Azure or SQL Server with ease. Plus, here are a few related Knowledge Base (KB) … [Read more...]
Filed Under: Administration, Challenges, Databases, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, Tips & Tricks, Tool Time, Transact-SQL Programming, Virtualization Tagged With: cloud computing, DBA, Developer, MS-Access, MySQL, Oracle, PHP, SQL Azure, SQL Server 2008 R2, Sybase, Tools, Tools & Scripts, Transact-SQL Programming
Business Intelligence Careers SearchSQLServer.com Interview
I had a very interesting conversation recently with a good friend of mine. She's at the top of her game as a first class enterprise DBA in a major medical institution. She was interested in my career advice because she'd recently received an unsolicited invitation for a higher paying job in the business intelligence (BI) field. While I won't talk much more about the specifics of that conversation, it's not a unique conversation. In fact, I gave an interview to SearchSQLServer.com a while back about how DBA career paths are more and more leading into an even better paying career in business … [Read more...]
Filed Under: Administration, Databases, Opinion, Professional Development, SQLMag, SQLServerPedia Syndication Tagged With: Business Intelligence, Career, DBA, Developer, SQL Server 2008 R2, SSAS
SQL People Interview
Many thanks to Microsoft SQL Server MVP Andy Leonard (blog | twitter) for conducting a series of interviews of prominent SQL Server types, including me. The interview found here. ~~~ Enjoy! -Kev Twitter at kekline More content at http://KevinEKline.com … [Read more...]
Filed Under: Databases, Interviews, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Career, DBA, Developer, MVP, Professional Development, Writing
Free Webcast Series: Patterns and Practices in Database Administration
SSWUG.ORG’s virtual webcasts will prepare the “Accidental DBA” for patterns and practices they will experience in their role as a database administrator. I will provide easy-to-understand insights and realistic examples for professionals who have not had any formal DBA training. By the end of our four-part series, you should have the information needed to get up to speed on database planning, administration and performance tuning basics. Session Descriptions In the first session, you will see what is needed to fulfill the role of a (Database Administrator) DBA by learning more about what … [Read more...]
Filed Under: Administration, Challenges, Databases, Presentations, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Career, DBA, Management, Performance, Professional Development, SQL Server 2008 R2, Training
Leadership, Management, and SQLRally
Transparency - A Great Leadership Quality I've always appreciated how Andy Warren (blog| twitter) operates in the most transparent manner, especially as it relates to his role as a director for the Professional Association for SQL Server. For example, Andy's latest blog post about prepping for the SQLRally, to kick off in less than 30 days, is insightful and gives you a good idea of the sort of work a strong director for PASS needs to put in. I also enjoy how Andy more or less thinks out loud and offers you the chance to provide your input. In that latest blog post, he was mulling different … [Read more...]
Filed Under: Conferences, Governance, Interviews, PASS, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication, Strategies, Video Tagged With: Career, Goals, Plays Well With Others, Professional Development, SQLPASS, Training
New on SQLMag.Com: Update to SP_WHOISACTIVE
I profiled Adam Machanic's (blog | twitter) excellent stored procedure, SP_WHOISACTIVE, back in August of 2010 in my monthly SQLMag column, Tool Time. Adam has been diligent about maintaining the tool and adding new features. Read the details on my SQLMag Tool Time column. Enjoy! -Kev Twitter at kekline … [Read more...]
Filed Under: SQL Server, SQLServerPedia Syndication, Tool Time Tagged With: DBA, Internals, Monitoring, SQL Server 2008 R2, SQLMag, Tools, Tools & Scripts
Funny Things You’ll Hear at the “Leadership for IT Professionals” at the 2011 SQLRally
The 2011 PASS SQLRally is just about one month away and it's high time I highlighted some of the important things you'll be hearing about in my precon seminar Leadership and Team Management Skills for the IT Professional. Just to set the context, many of us IT people got to our lofty career positions because of our keen use of technology. It takes a lot of smarts to get where we've gotten, but they are a very specific set of smarts that can't always be used in every business setting. And, since so many of us have topped out in our potential salary as long as we stay in the trenches and the … [Read more...]
Filed Under: Conferences, PASS, Presentations, Professional Development, SQLMag, SQLServerPedia Syndication Tagged With: Best Practices, Humor, Management, Plays Well With Others, Professional Development, SQLPASS, Training
And the winner of the SQLBits8 Pub Quiz is… [drumroll please]
Wow - what a great trip through Europe! SQLBits8 was in beautiful and sunny Brighton, which everyone local to the area assures me that it's not usually either. The crowd was large and enthusiastic. We did two rollickin' fun lunch time vendor sessions, one being the SQL Pub Quiz. (I'll tell you about the other one tomorrow in a separate blog post). We used a bingo pub quiz approach and, I have to say, a form of bingo I'd never before seen in my life. We managed to extract quite a bit of fun out of it any way, presentation hiccups and all. Our giveaway winners were Mark Dodd (at top) … [Read more...]
Filed Under: Conferences, Databases, Presentations, SQLMag, SQLServerPedia Syndication Tagged With: DBA, Developer, SQL Server 2008 R2
