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

Toad for Sybase Beta and Webcast Now Available

The Toad for Sybase webcast is now available on-demand.  Don't have Toad for Sybase?  Get it HERE while it's a free beta. There are two ways to access the webcast: 1. Quest.com - requires a username/password and gets tracked 2. ToadWorld - for quick viewing Go with option two if you don't wanna be tracked.  Lot's more Toad for Sybase goodies HERE. Enjoy! -Kev Twitter at kekline More content at http://KevinEKline.com … [Read more...]

Pulling real-time data from Twitter using StreamInsi​ght and Other Scandinavian Treasures

On my recent trip to SQLBits with subsequent visits to Dublin, Cologne, and Malmo (southern Sweden), I enjoyed a chance to meet several SQL Server MVPs, including Peter Larsson and Thomas Ivarsson. Among them, I enjoyed Johan Ahlen's article on Pulling real-time data from Twitter using StreamInsi​ght.  You can Find Johan's blog here.  I also enjoyed several other conversations, such as the one I had with Feodor Georgiev (blog).  I particularly enjoyed Feodor's guest post on SQLAuthority.com about waits in the round-trip loop from client to server back to client available HERE. There's a … [Read more...]

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

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

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

Toad for SQL Gets 5 Diamonds from SQL Server Magazine

The Toad for SQL Server review that was recently conducted for SQL Server Magazine was published online – and we got 5 out of 5 diamonds! This is an improvement from the 4.5/5 stars Michael Campbell gave the product in a 2009 review. The review is very positive, with Michael citing the product’s highly customizable management and development solution, and writes that it “one-ups SSMS by including server, schema, and data comparison tools, a log reader, and a wide assortment of other options, capabilities, and utilities.” See the full review below or by clicking the link here: Toad for … [Read more...]

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

How Do You SKU?

I’d like your opinion here. Follow my logic here for a moment as I walk through a couple rhetorical questions.  Have you ever had a friend developed an application entirely on SQL Server Developer Edition?  (Not that YOU would ever do such a thing, but maybe you know someone who has. Right?) And has your friend’s IT department actually deployed said application only to discover that they’re only licensed for Standard Edition in their production environment?  And then was your friend’s IT management team is horrified to learn that they’ve either got to go through the very expensive process … [Read more...]

How Much Data is a Lot of Data?

It's always interesting to see the guestimations of the big brains about figures and facts that are hard to verify.  Here's an example - how much data is computerized today?  I'm not talking about ancient stuff, like the Codex Synaticus (which, incidentally IS on-line at www.codexsinaiticus.org).  I’m talking about the new and really important stuff, like the fourteen pictures that my step-daughter posted on her FaceBook account from our recent trip to Rock City. Well, IDC figured that overall digital data was up to 1.2Zb (Zetabytes!)  at the end of 2010.  My mind is boggling.  Ok, so that's … [Read more...]