<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://sqlblog.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Search results matching tags 'tools' and 'Administration'</title><link>http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&amp;tag=tools,Administration&amp;orTags=0</link><description>Search results matching tags 'tools' and 'Administration'</description><dc:language>en-US</dc:language><generator>CommunityServer 2.1 SP2 (Build: 61129.1)</generator><item><title>SQLintersection!</title><link>http://sqlblog.com/blogs/kevin_kline/archive/2013/03/27/sqlintersection.aspx</link><pubDate>Wed, 27 Mar 2013 13:47:00 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:48432</guid><dc:creator>KKline</dc:creator><description>&lt;p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;"&gt;The best emotion to describe how I'm feeling is 'astounded'. &amp;nbsp;I'm astounded that I'm in such august company to be speaking the&amp;nbsp;&lt;a href="http://www.sqlintersection.com/"&gt;SQLIntersection&lt;/a&gt;&amp;nbsp;(&lt;a href="http://twitter.com/iSQL"&gt;#iSQL&lt;/a&gt;)&amp;nbsp;conference. &amp;nbsp;&lt;a href="http://www.sqlskills.com/blogs/kimberly/sqlintersection-new-conference/"&gt;Read the blog post from my first SQL Server mentor, Kimberly Tripp, which tells you all about SQLintersection&lt;/a&gt;.&lt;/p&gt;&lt;p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;"&gt;Check out this list of speakers:&lt;/p&gt;&lt;ul style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;"&gt;&lt;li&gt;Aaron Bertrand, Sr. Consultant, SQL Sentry, Inc. [&lt;a href="http://sqlblog.com/blogs/aaron_bertrand/default.aspx"&gt;blog&lt;/a&gt;&amp;nbsp;|&amp;nbsp;&lt;a href="http://twitter.com/AaronBertrand"&gt;twitter&lt;/a&gt;]&lt;/li&gt;&lt;li&gt;Andrew J. Kelly, Mentor, SolidQ [&lt;a href="http://sqlblog.com/blogs/andrew_kelly/default.aspx"&gt;blog&lt;/a&gt;&amp;nbsp;|&amp;nbsp;&lt;a href="http://twitter.com/gunneyk"&gt;twitter&lt;/a&gt;]&lt;/li&gt;&lt;li&gt;Bob Ward, Principal Architect Escalation Engineer, Microsoft [&lt;a href="http://blogs.msdn.com/b/psssql/"&gt;blog&lt;/a&gt;&amp;nbsp;|&amp;nbsp;&lt;a href="http://www.twitter.com/bobwardms"&gt;twitter&lt;/a&gt;]&lt;/li&gt;&lt;li&gt;Brent Ozar, Brent Ozar Unlimited [&lt;a href="http://www.brentozar.com/"&gt;blog&lt;/a&gt;&amp;nbsp;|&amp;nbsp;&lt;a href="http://twitter.com/BrentO"&gt;twitter&lt;/a&gt;]&lt;/li&gt;&lt;li&gt;Conor Cunningham, Principal Architect, SQL Server, Microsoft [&lt;a href="http://blogs.msdn.com/b/conor_cunningham_msft/"&gt;blog&lt;/a&gt;]&lt;/li&gt;&lt;li&gt;Grant Fritchey, Product Evangelist, Red Gate Software [&lt;a href="http://www.scarydba.com/"&gt;blog&lt;/a&gt;&amp;nbsp;|&amp;nbsp;&lt;a href="https://twitter.com/GFritchey"&gt;twitter&lt;/a&gt;]&lt;/li&gt;&lt;li&gt;Jeremiah Peschka, Brent Ozar Unlimited [&lt;a href="http://www.brentozar.com/"&gt;blog&lt;/a&gt;&amp;nbsp;|&amp;nbsp;&lt;a href="http://twitter.com/PeschkaJ"&gt;twitter&lt;/a&gt;]&lt;/li&gt;&lt;li&gt;Joseph Sack, Principal Consultant, SQLskills.com [&lt;a href="http://www.sqlskills.com/blogs/Joe"&gt;blog&lt;/a&gt;&amp;nbsp;|&amp;nbsp;&lt;a href="http://twitter.com/JosephSack"&gt;twitter&lt;/a&gt;]&lt;/li&gt;&lt;li&gt;Kendra Little, Managing Director, Brent Ozar Unlimited [&lt;a href="http://www.brentozar.com/"&gt;blog&lt;/a&gt;&amp;nbsp;|&amp;nbsp;&lt;a href="http://twitter.com/KendraLittle"&gt;twitter&lt;/a&gt;]&lt;/li&gt;&lt;li&gt;Kevin Kline, Director of Engineering Services, SQL Sentry, Inc. [&lt;a target="_blank" href="http://sqlblog.com/blogs/kevin_kline/default.aspx"&gt;blog&lt;/a&gt;&amp;nbsp;|&amp;nbsp;&lt;a target="_blank" href="http://twitter.com/KeKline"&gt;twitter&lt;/a&gt;]&lt;/li&gt;&lt;li&gt;Kimberly L. Tripp, President/Founder, SQLskills.com [&lt;a href="http://www.sqlskills.com/blogs/Kimberly"&gt;blog&lt;/a&gt;&amp;nbsp;|&amp;nbsp;&lt;a href="http://twitter.com/KimberlyLTripp"&gt;twitter&lt;/a&gt;]&lt;/li&gt;&lt;li&gt;Mat Young, Senior Director of Products, Fusion-io [&lt;a target="_blank" href="http://www.fusionio.com/blog"&gt;blog&amp;nbsp;&lt;/a&gt;|&amp;nbsp;&lt;a target="_blank" href="https://twitter.com/iSpider"&gt;twitter&lt;/a&gt;]&lt;/li&gt;&lt;li&gt;Paul S. Randal, CEO / Owner, SQLskills.com [&lt;a href="http://www.sqlskills.com/blogs/Paul"&gt;blog&lt;/a&gt;&amp;nbsp;|&amp;nbsp;&lt;a href="http://twitter.com/PaulRandal"&gt;twitter&lt;/a&gt;]&lt;/li&gt;&lt;li&gt;Paul White, SQL Kiwi Limited [&lt;a href="http://sqlblog.com/blogs/paul_white/default.aspx"&gt;blog&lt;/a&gt;&amp;nbsp;|&amp;nbsp;&lt;a href="http://www.twitter.com/SQL_Kiwi"&gt;twitter&lt;/a&gt;]&lt;/li&gt;&lt;li&gt;Steve Jones, Editor, SQLServerCentral.com [&lt;a href="http://www.sqlservercentral.com/blogs/Steve_Jones/"&gt;blog&lt;/a&gt;&amp;nbsp;|&amp;nbsp;&lt;a href="https://twitter.com/WayOutwest"&gt;twitter&lt;/a&gt;]&lt;/li&gt;&lt;li&gt;Sumeet Bansal, Principal Solutions Architect, Fusion-io [&lt;a target="_blank" href="http://www.fusionio.com/blog"&gt;blog&amp;nbsp;&lt;/a&gt;|&amp;nbsp;&lt;a target="_blank" href="https://twitter.com/SumeetBansal_"&gt;twitter&lt;/a&gt;]&lt;/li&gt;&lt;/ul&gt;&lt;p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;"&gt;&amp;nbsp;Read the list of&amp;nbsp;&lt;a href="http://www.sqlintersection.com/shows/april13/sessions.aspx?s=2"&gt;SQL Server sessions&lt;/a&gt;&amp;nbsp;here. &amp;nbsp;On top of the list of outstanding sessions to attend, I'll be giving a keynote on Tuesday afternoon. Witness:&lt;/p&gt;&lt;p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;text-align:center;"&gt;&lt;a href="http://kevinekline.com/wp-content/uploads/2013/03/iSQL-Keynote.jpg"&gt;&lt;/a&gt;&lt;a href="http://www.sqlintersection.com/shows/images/schedulepdfs/Sp2013_SQL%20Sched_v2.pdf"&gt;&lt;img class="aligncenter  wp-image-5597" alt="iSQL Keynote" width="757" height="621" style="border:0px;cursor:default;display:block;margin-left:auto;margin-right:auto;" src="http://kevinekline.com/wp-content/uploads/2013/03/iSQL-Keynote.jpg"&gt;&lt;/a&gt;&lt;/p&gt;&lt;p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;"&gt;So the only thing between the attendees and the booze in the reception hall is our keynote address?!? &amp;nbsp;Oh yeah, that's going to go down real smooth, isn't it? &amp;nbsp;I'll last about as long as a puny henchman between James Bond and the villain of the movie. &amp;nbsp;Sumeet Bansal, from Fusion-IO, will have to survive until the credits roll. &amp;nbsp;We'll be talking about high performance computing on SQL Server 2012 with an eye towards high availability, AlwaysOn, and Availability Groups.&lt;/p&gt;&lt;p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;"&gt;If you're in Las Vegas, I hope to see you there! &amp;nbsp;If not, you should consider coming to this excellent conference.&lt;/p&gt;&lt;p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;"&gt;-Kevin&lt;/p&gt;&lt;p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;"&gt;&lt;a href="http://twitter.com/kekline"&gt;-Follow me on Twitter!&lt;/a&gt;&lt;/p&gt;</description></item><item><title>New White Paper: SQL Server Extended Events and Notifications</title><link>http://sqlblog.com/blogs/kevin_kline/archive/2012/04/25/new-white-paper-sql-server-extended-events-and-notifications.aspx</link><pubDate>Wed, 25 Apr 2012 13:13:00 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:42932</guid><dc:creator>KKline</dc:creator><description>&lt;p&gt;SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to react to events that have already occurred. &amp;nbsp;There's PerfMon, and Profiler, and loads of Dynamic Management Views to check. &amp;nbsp;But where to look?&lt;/p&gt;&lt;p&gt;As database administrators (DBA), we need to monitor our environments proactively and create solutions as issues arise. In this white paper, we will look at a couple technologies – event notifications and extended events – that can help you achieve these goals. With these two features, we’ll look at the error log and deadlocks, and demonstrate how you can get relevant information delivered as it occurs. We’ll also look at ways that run-time errors can be captured and used to help reduce the amount of time required to investigate issues.&lt;/p&gt;&lt;p&gt;This white paper, written by SQL Server MVP Jason Strate (&lt;a title="Jason Strate's SQL Server Blog" href="http://www.jasonstrate.com/"&gt;blog&lt;/a&gt;&amp;nbsp;|&amp;nbsp;&lt;a title="Jason Strate's Twitter Feed" href="http://twitter.com/stratesql"&gt;twitter&lt;/a&gt;), is a free download &lt;em&gt;but requires a registration&lt;/em&gt;.&amp;nbsp; &lt;a title="Microsoft SQL Server Extended Events White Paper" href="http://www.quest.com/whitepaper/how-to-use-sql-servers-extended-events-and-notifications816315.aspx"&gt;Download the Extended Events white paper here&lt;/a&gt;.&lt;/p&gt;&lt;p&gt;And, as always, I enjoy your feedback. &amp;nbsp;Thanks!&lt;/p&gt;&lt;p&gt;-Kev&lt;/p&gt;&lt;p&gt;&amp;nbsp;Follow me on&amp;nbsp;&lt;a title="Kevin Kline's Twitter Feed" href="http://twitter.com/kekline"&gt;Twitter&lt;/a&gt;!&lt;/p&gt;</description></item><item><title>ETL Demo With Data from Data.Gov</title><link>http://sqlblog.com/blogs/kevin_kline/archive/2011/08/05/etl-demo-with-data-from-data-gov.aspx</link><pubDate>Fri, 05 Aug 2011 21:45:00 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:37542</guid><dc:creator>KKline</dc:creator><description>&lt;p&gt;A little over a month ago, I wrote an article (&lt;a href="http://kevinekline.com/2011/06/30/is-there-such-a-thing-as-easy-etl/" title="ETL, Expressor, and Data.Gov" target="_blank"&gt;&lt;em&gt;Is There Such a Thing as Easy ETL&lt;/em&gt;&lt;/a&gt;) about expressor software and their desktop ETL application, expressor Studio.  I wrote about how it seemed much easier than the native ETL tools in SQL Server when I was reading up on the tool, but that the "proof would be in the pudding" so to speak when I actually tried it out loading some free (and incredibly useful) data from the US federal data clearinghouse, &lt;a href="http://data.gov" title="The US Federal Data Clearinghouse" target="_blank"&gt;Data.Gov&lt;/a&gt;.
&lt;/p&gt;&lt;p&gt;
If you'd rather not read my entire previous article - quick recap, expressor Studio uses “semantic types” to manage and abstract mappings between sources and targets. In essence, these types are used for describing data in terms that humans can understand—instead of describing data in terms that computers can understand. The idea of semantic abstraction is quite intriguing and it gave me an excuse to use data from data.gov to build a quick demo. You can download the complete data set I used from the following location: &lt;a href="http://explore.data.gov/International-Statistics/International-Data-Base/qm22-4smj" title="Data.Gov International Statistics" target="_blank"&gt;International Statistics&lt;/a&gt;.  (Note: I have this dream that I'm going to someday download all of this free statistical data sets, build a bunch of amazing and high-value analytics, and make a mint.  If, instead, YOU do all of those things, then please pay to send at least one of my seven kids to college in repayment for the inspiration.  I'm not kidding.  I have SEVEN kids. God help me).

&lt;/p&gt;&lt;p&gt;The federal government, to their credit, has made great progress in making data available.  However, there is a big difference between accessing data and understanding data. When I first looked at one of the data files I downloaded, I figured it was going to take me years to decrypt the field names. Luckily, I did notice an Excel file with field names and descriptions. Seriously, there are single letter field names in these files where the field name “G” has a description of “Age group indicator” (Oh Wow).  See the figure below.

&lt;/p&gt;&lt;p&gt;&lt;a href="http://kevinekline.com/?attachment_id=1763" rel="attachment wp-att-1763"&gt;&lt;img src="http://kevinekline.com/wp-content/uploads/2011/08/expressor-2-01.png" class="aligncenter size-full wp-image-1763" title="expressor, 2, 01" alt="" width="623" height="334"&gt;&lt;/a&gt;
&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;
It's stuff like this that reminds me why we have data quality and &lt;a href="http://en.wikipedia.org/wiki/Master_data_management" title="Wikipedia::Master Data Management" target="_blank"&gt;master data management tools&lt;/a&gt;.  Ok, back to expressor Studio. I quickly mapped a couple of files into expressor Studio using their “Read File” operator. It was fairly simple and easy to use. My data included files with country area information, population, and gender information by year. Once I mapped these files I quickly wanted to shed the default cryptic, nay, nonsensical names. I could have just renamed the fields when I initially mapped them into the system but that would mean I would have to manage the names in three separate locations. Bah! It made more sense to create a common semantic type and reuse it across all three files.&lt;/p&gt;&lt;p&gt;

&lt;a href="http://kevinekline.com/?attachment_id=1764" rel="attachment wp-att-1764"&gt;&lt;img src="http://kevinekline.com/wp-content/uploads/2011/08/expressor-2-02.png" class="aligncenter size-full wp-image-1764" title="expressor, 2, 02" alt="" width="624" height="389"&gt;&lt;/a&gt;

&lt;/p&gt;&lt;p&gt;There are two flavors of semantic types within expressor Studio to handle your mappings, atomic types or composite types. An atomic type is simply a single field name whereas a composite type is a combination of one more atomic types. Since the data files had many common fields, I decided to create a core set of atomic types that I could then roll up into composite types based on the files I was mapping. This kept the mappings simple and easy to understand and most importantly the whole exercise took about 5 minutes. Once the types were created I simply mapped the cryptic names from the files to the business friendly names in my semantic type.  (I can't even begin to imagine how long this would've taken using native tools, but certainly not 5 minutes).&lt;/p&gt;&lt;p&gt;

&lt;a href="http://kevinekline.com/?attachment_id=1765" rel="attachment wp-att-1765"&gt;&lt;img src="http://kevinekline.com/wp-content/uploads/2011/08/expressor-2-03.png" class="aligncenter size-full wp-image-1765" title="expressor, 2, 03" alt="" width="624" height="389"&gt;&lt;/a&gt;

&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Now I was ready to move my data. I took the data from three files and combined them into one master dataset. From there, my international statistics from Data.Gov were pumped right into my waiting SQL Server database.  Note that I could've used Excel or just about any other database as my target instead of SQL Server.

&lt;/p&gt;&lt;p&gt;Now, you might be saying to yourself "That looks easy because you read all the help files first."  Actually, no.  In fact, some of my buddies like to lovingly tell me to "RTFM" from time to time.  It's not that it offends my masculinity to read a manual.  I just usually like to have a go first and then, if needed, go back to the manual.  In fact, all I really used was &lt;a href="http://community.expressor-software.com/blogs/hsheng/14-new-5-minute-demo-expressor-studio.html" title="5-minute video of expressor Studio" target="_blank"&gt;this 5-minute demo video&lt;/a&gt; that in noticed when I was downloading the tool.
&lt;/p&gt;&lt;p&gt;
If you're tackling ETL and you want it fast and easy, then you might want to check out their website, &lt;a href="http://www.expressor-software.com/"&gt;www.expressor-software.com&lt;/a&gt;, to learn more about the expressor company and products.

&lt;/p&gt;&lt;p&gt;Enjoy!
&lt;/p&gt;&lt;p&gt;
-Kev

&lt;/p&gt;&lt;p&gt;P.S. &lt;a href="http://twitter.com/kekline" title="C'mon. You know you want to!" target="_blank"&gt;Follow me on Twitter!&lt;/a&gt;

&amp;nbsp;

&amp;nbsp;&lt;/p&gt;</description></item><item><title>Is There Such a Thing as Easy ETL?</title><link>http://sqlblog.com/blogs/kevin_kline/archive/2011/06/30/is-there-such-a-thing-as-easy-etl.aspx</link><pubDate>Thu, 30 Jun 2011 04:57:00 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:36552</guid><dc:creator>KKline</dc:creator><description>&lt;br&gt;
E.T.L. That's &lt;em&gt;Extract - Transform - Load&lt;/em&gt;.  That doesn't sound like a lot of work when all you need to get loaded is a simple Access database or an Excel spreadsheet.  In a situation like that, the process is so simple, all you really need to focus on is the L in ETL.  There's not a whole lot of E.T. to process, despite how wonderful that movie is. [pun intended]  But as soon as your data loading process involves some difficult or sophisticated cleansing or transformations, it gets really, really hard.
The other cross-thread that had really caught my interest lately is the &lt;a href="http://www.whitehouse.gov/open" title="The Open Data Initiative" target="_blank"&gt;USA federal governments Open Data Initiative&lt;/a&gt;.  I think it's remarkable that President Obama is the first president to appoint a federal CIO.  (Shouldn't that have happened in the past?)  In addition, President Obama instructed the entire executive branch to open up their data (where security isn't at risk) and make it readily available to the public.  And the US government collects mountains of interesting and valuable data for its own uses, but figuring out how or who to share it with was always an afterthought.  While I was a contractor for NASA, for example, I worked on some incredibly interesting projects which yielded amazing and commercially valuable information.  It was all public domain.  But unless you knew it was there, you couldn't get to it. Making use of all of that data always intrigued me.
Now, with ODI, it's all being put on the internet at an ever-increasing rate at &lt;a href="http://data.gov" title="Data from the US Federal Government" target="_blank"&gt;Data.gov&lt;/a&gt;.  However, all of this data, while open and available, is not standardized.  Some data sets might be a CSV file, while others might be something like a spreadsheet.  That means you'll need to extract, transform, and load that data if you want to synthesize more valuable data sets.
&lt;strong&gt; &lt;/strong&gt;
&lt;strong&gt; &lt;/strong&gt;
For those reasons, I've been researching tools to help make this process easier.  (I also wanted to research SSIS and ETL tools for my &lt;a href="http://www.sqlmag.com/blogcontent/tool-time-blog-16" title="free SQL Server tools every month" target="_blank"&gt;Tool Time column&lt;/a&gt; in &lt;a href="http://www.sqlmag.com" title="SQL Server Magazine" target="_blank"&gt;SQL Server Magazine&lt;/a&gt;.)  Now, I've been following &lt;a href="http://www.expressor-software.com/" title="Expressor Software" target="_blank"&gt;expressor software&lt;/a&gt; for quite some time and really like their unique approach.  (I actually ran into the expressor software team at a &lt;a href="http://www.sqlpass.org/summit/2011/" title="PASS Summitt 2011" target="_blank"&gt;PASS Summit&lt;/a&gt; one or two years ago and asked for a demo of their software.  And I really liked what I saw.)  Rather than the workflow approach used by SSIS, expressor software uses a data mapping approach combined with reusable business rules.  Their mapping approach is fundamentally different from the traditional point-to-point, source-to-target mappings paradigm.  Basically, you can define a semantic type representative of your business data, create a business rule(s) to apply to the data, and then implement a "canonical" mapping which connects data sources and targets to that same semantic type.  And it's free!
&amp;nbsp;
&lt;h2&gt;&lt;strong&gt;Abstraction is Awesome&lt;/strong&gt;&lt;/h2&gt;&lt;p&gt;
What's cool about that?  Don't forget that "semantic" means "meaning".  So a semantic type is an abstraction of the meaning of the data.  The net result is that expressor shields your data integration application, with its associated business and transformation rules, from changes that might occur to underlying target or source files with different field names and data type representations have to be processed.  &lt;em&gt; &lt;/em&gt;
For example, let’s assume that you need to process invoices from different vendors in slightly different formats.  If you use a traditional ETL tool like SSIS, any changes in the source and/or target formats will require you to modify your data mappings and transformation rules, because the mappings are tied directly to the metadata structure of the invoice file format(s). expressor, on the other hand, lets you define a common “invoice” semantic type, build all your downstream data processing off that type and map one or multiple invoice file schemas to the type.
This approach greatly simplifies the mapping process and provides for more flexible data integration applications that can be more easily adapted to changes in the source and target data sources.&lt;/p&gt;&lt;p&gt;
&lt;a href="http://go.expressor-software.com/studio-download.html?campaignID=70140000000MgQm" target="_blank"&gt;&lt;img src="http://kevinekline.com/wp-content/uploads/2011/06/Expressor-Offer1.png" class="size-full wp-image-1704" title="Expressor Offer" alt="Expressor Offer" align="middle" height="250" width="300"&gt;&lt;/a&gt;
&amp;nbsp;
&amp;nbsp;
&lt;/p&gt;&lt;h2&gt;Benefits Abound&lt;/h2&gt;
Since the semantic types in expressor are captured as reusable artifacts, you can also reuse them again in new data flows within your project(s).  You can even share them across your entire organization.  As I tinkered with the expressor Studio tool, I hit on a few other benefits with this approach:
&lt;ul&gt;
	
&lt;li&gt;Handles data type conversions automatically without having to write data transformation rules for these conversions&lt;/li&gt;
	
&lt;li&gt;Builds new semantic types from existing types and reuses types in existing and new applications&lt;/li&gt;
	
&lt;li&gt;Creates multiple, reusable business rules against a single type and applies them repeatedly as needed&lt;/li&gt;
	
&lt;li&gt;Easily implements data quality rules and constraints&lt;/li&gt;
&lt;/ul&gt;
&lt;h2&gt;&lt;/h2&gt;
&lt;h2&gt;In an Ideal World...&lt;/h2&gt;
In an ideal world, I'd figure out some brilliant way to make money from bringing together all kinds of that government data that I used to work with.  Other folks are doing it at the &lt;a href="https://datamarket.azure.com/" title="The Windows Azure Data Market" target="_blank"&gt;Windows Azure Data Market&lt;/a&gt;.  But in the meanwhile, I'm also looking forward to tinkering with this data to build better demos.  Along the way, I'm going to use the &lt;a href="http://www.expressorstudio.com/" title="Expressor Software" target="_blank"&gt;expressor Studio&lt;/a&gt; desktop ETL tool (Did I mention that it's free!) as well as tell you about my experiences as I try to build out some Data.gov data sets.
Those of you who know me, know that I look a good discussion and cooperative, constructive team work.  So I encourage your feedback and suggestions, as I work through these data integration challenges and share my experiences.  I'm looking forward to sharing with you my insights on what the expressor data integration software can do with this challenge and what some of its features and capabilities are.  In upcoming releases, I'll let you know what I find intriguing and worth mentioning.
Check out their website, &lt;a href="http://www.expressor-software.com/"&gt;www.expressor-software.com&lt;/a&gt;, to learn more about their company and products.
Enjoy,
-Kev
Follow me on &lt;a href="http://twitter.com/kekline" title="Tweet Tweet" target="_blank"&gt;Twitter&lt;/a&gt;
More content on &lt;a href="http://kevinekline.com" title="My blog" target="_blank"&gt;KevinEKline.com&lt;/a&gt;</description></item><item><title>From SQLMag Tool Time Column: SSMS Plug-in News</title><link>http://sqlblog.com/blogs/kevin_kline/archive/2011/05/12/from-sqlmag-tool-time-column-ssms-plug-in-news.aspx</link><pubDate>Thu, 12 May 2011 19:00:00 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:35585</guid><dc:creator>KKline</dc:creator><description>&lt;p&gt;I first wrote about Mladen Prajdic's excellent tool in my Tool Time column at SQL Server Magazine &lt;a href="http://www.sqlmag.com/article/sql-server-2005/ssms-tools-pack-6-tools-that-help-you-do-more-with-ssms" title="SQLMAG Tool Time Blog" target="_blank"&gt;HERE&lt;/a&gt;.    The tool is a nice plug-in to SSMS and definitely worth having.  &lt;/p&gt;&lt;p&gt;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:
&lt;a href="http://weblogs.sqlteam.com/mladenp/archive/2010/12/28/ssms-tools-pack-1-9-4-is-out-now-with.aspx"&gt;SSMS Tools Pack 1.9.4 is out! Now with SQL Server 2011 (Denali) CTP1 support.
&lt;/a&gt;&lt;/p&gt;&lt;p&gt;&lt;a href="http://weblogs.sqlteam.com/mladenp/archive/2010/12/28/ssms-tools-pack-1-9-4-is-out-now-with.aspx"&gt;&lt;/a&gt;

As Mladen says:

&lt;em&gt;&lt;/em&gt;&lt;/p&gt;&lt;blockquote&gt;&lt;p&gt;&lt;em&gt;...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 Pack 1.9.4 doesn't have regions and debug sections functionality for now. The fixed bugs are: A bug that prevented to create insert statements for a database A bug that didn't script commas as decimal points correctly for non US settings.... &lt;/em&gt;&lt;/p&gt;&lt;/blockquote&gt;&lt;p&gt;&lt;em&gt;&lt;/em&gt;

Enjoy!

-Kev
&lt;/p&gt;&lt;div&gt;&lt;a href="http://twitter.com/kekline" title="C'mon. You know you want to!" target="_blank"&gt;Twitter at kekline&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;More content at &lt;a href="http://sqlblog.com/ControlPanel//"&gt;http://KevinEKline.com&lt;/a&gt;&lt;/div&gt;</description></item><item><title>Database Maintenance Scripting Done Right</title><link>http://sqlblog.com/blogs/kevin_kline/archive/2011/02/18/database-maintenance-scripting-done-right.aspx</link><pubDate>Fri, 18 Feb 2011 13:16:00 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:33607</guid><dc:creator>KKline</dc:creator><description>&lt;br&gt;I first wrote about useful database maintenance scripts on my&lt;a href="http://sqlblog.com/blogs/kevin_kline/archive/2008/03/26/more-sql-server-automation-scripts.aspx" title="Mad skillz in Mad scriptz" target="_blank"&gt; SQLBlog account&lt;/a&gt; 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...

&lt;a href="http://KevinEKline.com"&gt;&lt;img src="http://www.binbin.net/photos/everythingplay/mov/movie-script-note-book.jpg" title="Script" alt="" height="247" width="247"&gt;&lt;/a&gt;

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 database management team.  But, alas, they haven't published any updates in quite a while.  On the other hand, the other set of scripts came from Ola Hallengren, who has done a great job keeping his scripts up to date.

Recently, Ola added support for updating column statistics, both in a generalized update and also updates for only those columns whose statistics have been modified.  He's added some other goodies to the latest release, which you can read about here, &lt;a href="http://ola.hallengren.com/Versions.html"&gt;http://ola.hallengren.com/Versions.html&lt;/a&gt; for all details.

In addition, I'd like to remind you of the white paper I wrote a while back called &lt;a href="http://www.quest.com/documents/landing.aspx?id=10931" title="Free, but registration is required" target="_blank"&gt;&lt;em&gt;Automating DBA Processes&lt;/em&gt;&lt;/a&gt;, which covers many aspects of database automation and cherry picks some of the best practices from many different thought leaders, such as Ola, Michelle Ufford &lt;a href="http://sqlfool.com/" target="_blank"&gt;(&lt;/a&gt;&lt;a href="http://sqlfool.com/"&gt;blog&lt;/a&gt; | @&lt;a href="http://twitter.com/sqlfool"&gt;sqlfool&lt;/a&gt;) who will be speaking at the &lt;a href="http://www.sqlpass.org/24hours/Spring2011/default.aspx" title="Celebrating Women in Technology with an all-female speaker line up!" target="_blank"&gt;24HOP &lt;/a&gt;soon, and Allen White (&lt;a href="http://sqlblog.com/blogs/allen_white/archive/tags/PowerShell/default.aspx" target="_blank"&gt;blog&lt;/a&gt; | &lt;a href="http://twitter.com/sqlrunr"&gt;twitter&lt;/a&gt;).</description></item><item><title>Azure, a Beautiful Color, and So Much More...</title><link>http://sqlblog.com/blogs/kevin_kline/archive/2011/01/27/azure-a-beautiful-color-and-so-much-more.aspx</link><pubDate>Thu, 27 Jan 2011 22:04:00 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:32971</guid><dc:creator>KKline</dc:creator><description>&lt;h1&gt;Windows and SQL Azure Resources&lt;/h1&gt;&lt;p&gt;
&lt;a href="http://kevinekline.com/?attachment_id=1505" rel="attachment wp-att-1505"&gt;&lt;img src="http://kevinekline.com/wp-content/uploads/2011/01/image-300x169.png" class="size-medium wp-image-1505" title="image" alt="image" align="right" border="1" height="169" hspace="3" width="300"&gt;&lt;/a&gt;&lt;/p&gt;&lt;p&gt;Cloud computing is more than just the latest buzz word in the IT trade papers.  It is a remarkable paradigm shift with as much potential to "turn over the apple cart" of IT computing as client-server had for the world of mainframe and minicomputers.  If you're not spending time to learn about cloud computing, in general, and SQL Azure, in particular, then you're missing the boat in a big way.  (Ha! Two big metaphors in one afternoon. My high-school English teacher would be proud.)

There are mountains, literally &lt;em&gt;MOUNTAINS&lt;/em&gt;, of free and high-quality content to be had.  For example:
&lt;/p&gt;&lt;ul&gt;
	&lt;li&gt;SQL Azure in Windows Azure Platform: &lt;a href="http://www.microsoft.com/windowsazure/sqlazure/" target="_blank"&gt;http://www.microsoft.com/windowsazure/sqlazure/&lt;/a&gt;&lt;/li&gt;
	&lt;li&gt;Microsoft 2010 PDC presentation on SQL Azure Databases: Present &amp;amp; Future: &lt;a href="http://microsoftpdc.com/Sessions/SVC52" target="_blank"&gt;http://microsoftpdc.com/Sessions/SVC52&lt;/a&gt; &lt;strong&gt; &lt;/strong&gt;&lt;/li&gt;
&lt;/ul&gt;
Late last year, Microsoft released a whole training pack of sessions lead by David Aiken from Microsoft, including:
&lt;ul&gt;
	&lt;li&gt;the Azure Training Kit: &lt;a href="http://bit.ly/AzureTrainingKit" target="_blank"&gt;http://bit.ly/AzureTrainingKit&lt;/a&gt;&lt;/li&gt;
	&lt;li&gt;the Windows Azure developer account application site:&lt;a href="http://www.microsoft.com/windowsazure" target="_blank"&gt;http://www.microsoft.com/windowsazure&lt;/a&gt;&lt;/li&gt;
	&lt;li&gt;PDC on-demand sessions (look for Azure): &lt;a href="http://www.microsoftpdc.com" target="_blank"&gt;http://www.microsoftpdc.com&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
~~~
&lt;h1&gt;&lt;strong&gt;Fireside Chat Webcasts
&lt;/strong&gt;&lt;/h1&gt;
Fire Side Chats are invitation only Live Meetings. They are an hour in length, repeated at different times of day so you don’t need to attend at 3:00am because of time zone issues. Each Fire Side Chat has a key Microsoft individual talking about their area of expertise and answering questions from the audience. The Fireside Chats are aimed at technical experts, MVPs, user group leaders and the like.  But they have content of interest for everyone.  When looking at the archives, I noticed that there didn't seem to be many recent chats.  But some of the older ones still looked interested.  You can register to see one at &lt;a href="http://ug.gitca.org/sites/FireSideChats" target="_blank"&gt;http://ug.gitca.org/sites/FireSideChats&lt;/a&gt;.

~~~
&lt;h1&gt;&lt;strong&gt;Microsoft Team Blogs of Interest
&lt;/strong&gt;&lt;/h1&gt;
Do you ever wish that Microsoft consolidated all of their blogs in one easy to find central clearinghouse?  Well, your wish was answered, actually quite a long time ago.  &lt;a href="http://blogs.technet.com/b/blogms/" title="So much goodness in such a small hyperlink" target="_blank"&gt;BlogMS&lt;/a&gt; consolidates almost 250 Microsoft team blogs across a variety of Microsoft product and online services portfolio, with usually about 70 - 80 blog posts per week.  Yes, children, that's two to three HUNDRED blog posts per month.

You'll find important announcements and details of Microsoft news, product releases, service packs and important support issues.  On top of that, I really like all of the great links to Microsoft web resources on the right hand side of the website.  If you're like me (and let's be honest, most rational or just sane people would not want anything of the sort), you'll probably bookmark quite a few of those links.

The following BlogMS Resource Guides may also be of use:
&lt;ul&gt;
	&lt;li&gt;&lt;a href="http://blogs.technet.com/blogms/pages/directory-of-microsoft-team-blogs.aspx" title="All of 'em! In one place even!" target="_blank"&gt;Directory of Microsoft Team Blogs&lt;/a&gt;&lt;/li&gt;
	&lt;li&gt;&lt;a href="http://blogs.technet.com/blogms/pages/microsoft-free-software.aspx" title="Free, as in beer, not as in lunch" target="_blank"&gt;Free Microsoft Software and Online Services&lt;/a&gt;&lt;/li&gt;
	&lt;li&gt;&lt;a href="http://blogs.technet.com/blogms/pages/microsoft-support-resources.aspx" title="Where to go to find the bug fixes" target="_blank"&gt;Microsoft Support Resources&lt;/a&gt;&lt;/li&gt;
	&lt;li&gt;&lt;a href="http://blogs.technet.com/blogms/pages/microsoft-newsletters.aspx" title="Informative newsletters" target="_blank"&gt;Essential Microsoft Newsletters&lt;/a&gt;&lt;/li&gt;
	&lt;li&gt;&lt;a href="http://blogs.technet.com/blogms/pages/microsoft-connect-get-involved-early.aspx" title="Connet, Where you can vote on Microsoft's priorities" target="_blank"&gt;Microsoft Connect – get involved early&lt;/a&gt;&lt;/li&gt;
	&lt;li&gt;&lt;a title="I don't mind these clouds" target="_blank"&gt;Microsoft Software + Services and Cloud Computing&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;a href="http://kevinekline.com/wp-content/uploads/2011/01/MVP_FullColor_ForScreen.png"&gt;&lt;img src="http://kevinekline.com/wp-content/uploads/2011/01/MVP_FullColor_ForScreen-191x300.png" class="size-medium wp-image-1506" title="MVP_FullColor_ForScreen" alt="MVP_FullColor_ForScreen" align="left" border="1" height="160" hspace="3" width="101"&gt;&lt;/a&gt;&lt;br&gt;~~~&lt;a href="http://kevinekline.com/wp-content/uploads/2011/01/MVP_FullColor_ForScreen.png"&gt;&lt;/a&gt;&lt;h1&gt;MVPs are More Than Athletes&lt;/h1&gt;
You might be familiar with the term "Most Valuable Player", but haven't heard that MVPs exist in the professional world too.  Microsoft has nearly 3,000 designated "Most Valuable Professionals".  These folks are designated experts who know their subject matter at an expert level and, as an added bonus, they don't smell like a basketball locker room (SQLRockstar, &lt;a href="http://thomaslarock.com/" title="Not only does he use basketball analogies in his blogposts, he sometimes smells like it too!" target="_blank"&gt;Thomas LaRock&lt;/a&gt;, being a notable exception to this rule).

You can find out more about Microsoft's MVPs at the &lt;a href="http://mvp.support.microsoft.com/communities/mvp.aspx" title="I'm still trying to get in as an XBox MVP" target="_blank"&gt;MVP directory&lt;/a&gt;. And be sure to check out the &lt;a href="http://blogs.msdn.com/mvpawardprogram/" title="The Latest News about MVP'ness" target="_blank"&gt;MVP program blog.&lt;/a&gt;

~~~
&lt;h1&gt;Launching the Microsoft Desktop Player&lt;/h1&gt;&lt;p&gt;
Late last year a cool new tool was launched called Microsoft Desktop Player. The player aggregates contextual technical content (webcasts, podcasts, white papers) from across all sorts of Microsoft websites having an IT Pro adoption lifecycle. In addition, it also provides links to  local resources and news for the Developers and IT Pros based on their local settings, helping to drive the local engagement/relationship.  You'll need Microsoft Silverlight to run the website, but it's oh-so-cool looking.  Check out the details here: &lt;a href="http://www.microsoft.com/click/desktopplayer" title="Cool consolidation of resources for the IT Pro" target="_blank"&gt;http://www.microsoft.com/click/desktopplayer&lt;/a&gt;.

&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;~~~&lt;/p&gt;&lt;p&gt;Enjoy!&lt;/p&gt;&lt;p&gt;-Kevin, Twitter at &lt;a href="http://twitter.com/kekline" title="Tweet Tweeeeet" target="_blank"&gt;kekline&lt;/a&gt; &lt;/p&gt;&lt;p&gt;&amp;nbsp;More content at &lt;a href="http://KevinEKline.com" title="C'mon. You know you want to!" target="_blank"&gt;http://KevinEKline.com&lt;/a&gt; &lt;br&gt;&lt;/p&gt;</description></item><item><title>My Last &amp;quot;Catch-Up&amp;quot; Post for 2010 Content</title><link>http://sqlblog.com/blogs/kevin_kline/archive/2010/12/31/my-last-catch-up-post-for-2010-content.aspx</link><pubDate>Fri, 31 Dec 2010 20:57:00 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:32326</guid><dc:creator>KKline</dc:creator><description>I did a lot of writing in 2010.  Unfortunately, I didn't do a good job of keeping all of that writing equally distributed throughout all of the channels where I'm active.

&lt;p&gt;So here are a few more posts from my blog, put on-line during the months of November and December 2010, that I didn't get posted here on SQLBlog.com: &lt;br&gt;&lt;/p&gt;

&lt;h2&gt;1. It's Time to Upgrade!&lt;/h2&gt;

&lt;object&gt;




&lt;embed src="http://www.youtube.com/v/MPqdiq6elyM&amp;amp;hl=en_US&amp;amp;fs=1" allowfullscreen="true"&gt; &lt;/object&gt;

&lt;p&gt;So many of my customers and many of you, dear readers, are still on SQL Server 2005.&amp;nbsp; Join &lt;a href="http://KevinEKline.com" title="Simple the Best (We just don't know in what way it's the best)" target="_blank"&gt;Kevin Kline&lt;/a&gt;, SQL Server MVP and SQL Server Technology Strategist for Quest Software and &lt;a href="http://brentozar.com" title="He's not heavy. He's my brother." target="_blank"&gt;Brent Ozar&lt;/a&gt;, 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.
&lt;/p&gt;

&lt;h2&gt;2. Dealing with the Micromanaging Boss&lt;/h2&gt;

&lt;p&gt;&lt;img src="http://kevinekline.com/wp-content/uploads/2010/11/mad_boss-03.jpg" title="Bad bosses are the suck" alt="Bad bosses are the suck" align="left" border="1" height="268" hspace="5" width="250"&gt;This is probably my favorite professional development article of the year.&amp;nbsp; Micromanagers make us feel untrusted and stymied by their constant need 
for tediously detailed and frequent updates, constant changes to minor 
details of our work, and overly developed attention to administrative 
details that really don’t matter in our daily job.&amp;nbsp; But there’s hope!&amp;nbsp; Get all of my career advice on dealing with micromanaging bosses &lt;a href="http://kevinekline.com/?p=635" title="Microcomputers = good, Micromanagers = bad" target="_blank"&gt;here&lt;/a&gt;.&lt;br&gt;&lt;/p&gt;

&lt;h2&gt;3. [Video] Troubleshooting Memory Pressure on SQL Server&lt;/h2&gt;

&lt;p&gt;This is a little bit of an older video.  But it's still useful info if you're working with SQL Server 2005 or 2000.  Check it out &lt;a href="http://kevinekline.com/?p=732" title="Video! Trouble!! Shooting!!!" target="_blank"&gt;here&lt;/a&gt;.
&lt;/p&gt;

&lt;h2&gt;4. [DBTA] What the Heck is Microsoft's Database Product Trajectory?&lt;/h2&gt;

&lt;p&gt;I was once asked what I thought Microsoft's overall product trajectory for SQL Server was, in light of Oracle's rather obvious trajectory of acquiring multiple application vendors who will, in turn, deploy more and more of their applications to the Oracle database platform. You can read all about my thoughts in my monthly column at &lt;i&gt;Database Trends &amp;amp; Application&lt;/i&gt; magazine - &lt;a href="http://www.dbta.com/Articles/Columns/SQL-Server-Drill-Down/Microsofte28099s-Trajectory-for-SQL-Server-Becomes-Clear-with-PowerPivot-60468.aspx"&gt; [READ MORE]&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;5. Eight Characteristics of Excellent Leaders [Plays Well With Others]&lt;/h2&gt;

&lt;p&gt;In this installment of my professional development column called &lt;i&gt;Plays Well With Others&lt;/i&gt;, I talk about what distinguishes truly great leaders.  There's a lively discussion on the topic and I encourage you to take part.  Read it &lt;a href="http://kevinekline.com/?p=636" title="Be a leader!" target="_blank"&gt;here&lt;/a&gt;.
&lt;/p&gt;

&lt;h2&gt;6. The Shape of Database Licensing Costs to Come [DBTA]&lt;br&gt;&lt;/h2&gt;

&lt;p&gt;&lt;img src="http://kevinekline.com/wp-content/uploads/2010/11/Statshot-Americas-Most-Popular-Charts.jpg" title="Graphs Do Not Always Help Explain the Situation" alt="Graphs Do Not Always Help Explain the Situation" align="right" border="1" height="289" hspace="5" width="455"&gt;One fall semester many years ago, I was a university freshman.&amp;nbsp; Actually, I was anything but "fresh." I was dumb enough to think that 8 a.m. was a wonderful time to attend Economics 101. After staying up until the wee hours most every night, the "dismal science" took on more than one meaning as I set my clock just early enough to get to class on time.&amp;nbsp; Along with 30 other very naïve classmates, I staggered into class and did my bleary-eyed best to focus on the lessons at hand.&amp;nbsp; There were lots of Greek compound words and lots of graphs.&lt;br&gt;&lt;br&gt;I learned, for example, that the word economics derives from the Greek "oikonomikos," which means, approximately, "death by slidedecks" and, specifically, "house" (oikos) and "management" (mikos).&amp;nbsp; I barely survived the experience and never took an 8 a.m. class again.&amp;nbsp; Imagine my surprise, then, when a lesson I'd learned (and promptly forgotten) all those years ago jumped back into my consciousness late last year. - &lt;a href="http://www.dbta.com/Articles/Columns/SQL-Server-Drill-Down/The-Shape-of-Licensing-Costs-to-Come-60921.aspx"&gt;[READ MORE]&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;7. So You're the Boss Now... [Plays Well with Others]&lt;/h2&gt;

&lt;p&gt;If you have any ambition at all, you have probably wanted (and possibly gotten) a promotion over your current colleagues.  If you've been there before, you know that once friendly relationships can get, well, weird.  Read my tips and tricks for how to make the most of &lt;a href="http://www.impawards.com/2008/posters/promotion.jpg" title="Bad bosses are the suck. Don't be one." target="_blank"&gt;this situation in this professional development article&lt;/a&gt;. &lt;/p&gt;

&lt;h2&gt;8. The NoSQL Movement - Hype or Hope?&lt;/h2&gt;

&lt;p&gt;NoSQL is no fad.  And you need to be in the "know", not necessarily in the "No". Gno? Pneu? Too many phonetically similar pronunciations! Read my thoughts on the NoSQL movement on one of &lt;i&gt;Database Trends &amp;amp; Applications&lt;/i&gt; magazine's most popular articles of the year. - &lt;a href="http://www.dbta.com/Articles/Columns/SQL-Server-Drill-Down/The-NoSQL-Movement-Hype-or-Hope3f-66376.aspx"&gt;[READ MORE]&lt;/a&gt;
&lt;/p&gt;
&lt;h2&gt;9. Effectiveness and Efficiency at Work [Video]&lt;/h2&gt;

&lt;p&gt;In this golden oldie (yes, two years constitutes "old"), I present my thoughts on how to be both effective and efficient on the job and in life in general. And if you didn't know that these are different concepts, then you need &lt;a href="http://kevinekline.com/?p=748" title="It's one of my first videos, but one of the best." target="_blank"&gt;this video&lt;/a&gt; most muchly.  &lt;/p&gt;

&lt;h2&gt;10. What's Your Data Management and Retention Policy? [DBTA]&lt;/h2&gt;

&lt;p&gt;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. &lt;a href="http://www.dbta.com/Articles/Columns/SQL-Server-Drill-Down/What%27s-Your-Data-Management-and-Retention-Policy3f-67601.aspx"&gt;[READ MORE]&lt;/a&gt; &lt;/p&gt;

&lt;p&gt;&lt;a href="http://twitter.com/kekline" title="You know you want to" target="_blank"&gt;Follow me on Twitter!&lt;/a&gt;&lt;/p&gt;

&lt;p style="font-style:italic;"&gt;Originally Posted on YoutTube November 12, 2008.&amp;nbsp;&lt;/p&gt;</description></item><item><title>New on SQLMag - Automating the Startup and Shutdown of Windows Services</title><link>http://sqlblog.com/blogs/kevin_kline/archive/2010/04/27/new-on-sqlmag-automating-the-startup-and-shutdown-of-windows-services.aspx</link><pubDate>Tue, 27 Apr 2010 22:21:00 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:24616</guid><dc:creator>KKline</dc:creator><description>I just posted a new blog entry on how I automate the shutdown and startup of Windows services. &lt;br&gt;&lt;br&gt;Check it out at &lt;a href="http://www.sqlmag.com/blogs/tool-time.aspx" title="Otto-ma-shun" target="_blank"&gt;http://www.sqlmag.com/blogs/tool-time.aspx&lt;/a&gt;.&amp;nbsp; Be sure to let me know what you think and if you have your own unique methods for automating the control of Windows services!&lt;br&gt;&lt;br&gt;Many thanks,&lt;br&gt;&lt;br&gt;-Kevin&lt;br&gt;-Twitter &lt;a href="http://twitter.com/kekline" target="_blank" title="Tweet! Tweet tweet!"&gt;@kekline&lt;/a&gt;&lt;br&gt;-More content at &lt;a href="http://KevinEKline.com%20" title="My home page" target="_blank"&gt;http://KevinEKline.com&amp;nbsp;&lt;/a&gt; &lt;br&gt;</description></item><item><title>Free Training for You, Punishing Workload for Me. Thank You for Enjoying My Misery.</title><link>http://sqlblog.com/blogs/kevin_kline/archive/2010/02/09/free-training-for-you-punishing-workload-for-me-thank-you-for-enjoying-my-misery.aspx</link><pubDate>Tue, 09 Feb 2010 19:12:00 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:22068</guid><dc:creator>KKline</dc:creator><description>&lt;p&gt;&lt;a href="http://kevinekline.com/wp-content/uploads/2010/02/stupid-road-construction-workers-copy.gif"&gt;&lt;img src="http://kevinekline.com/wp-content/uploads/2010/02/stupid-road-construction-workers-copy-300x222.gif" class="size-medium wp-image-423" title="Everybody Needs a Little Training" alt="Everybody Needs a Little Training" width="300" align="texttop" height="222"&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;&lt;br&gt;&lt;/p&gt;&lt;p&gt;Everybody enjoys a little free training now and then.  I've got mountains of free training in the works.  Some of it is in-person and local while some are in webcast format.  Please join me as you're able!
&lt;/p&gt;
&lt;h3&gt;Tomorrow - Wednesday!&lt;/h3&gt;
Wed, Feb 10, 2010 &lt;i&gt;&lt;b&gt;12 pm (noon) MST&lt;/b&gt;&lt;/i&gt; - &lt;a href="http://www.sqlpass.org/Events/ctl/ViewEvent/mid/521.aspx?ID=291" title="I made these mistakes so you don't have to." target="_blank"&gt;PASS DBA Virtual Chapter; Top 10 Administration Mistakes on SQL Server&lt;/a&gt;
&lt;p style="padding-left:30px;"&gt;There are a short list of mistakes that, if you know of them in advance and prepare for them, will make your life much easier.  This presentation shows you these mistakes, the "low hanging fruit" of database administration.  Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before.  &lt;a href="http://sqlserver.quest.com" title="Great MSSQL Products from a Great Company" target="_blank"&gt;Quest&lt;/a&gt; is sponsoring this and raffling off a copy of my book, &lt;i&gt;SQL in a Nutshell&lt;/i&gt;, and O-M-G a KINDLE!!!  (Free, but registration required.)  And if you haven't already done it, join &lt;a href="http://www.sqlpass.org" title="The Professional Association for SQL Server" target="_blank"&gt;PASS&lt;/a&gt;!&lt;/p&gt;

&lt;p style="padding-left:30px;"&gt;&lt;/p&gt;

&lt;h3&gt;Day After Tomorrow - Thursday!&lt;/h3&gt;
Thu, Feb 11, 2010 at 11 am EST - &lt;a href="http://www.quest.com/events/listdetails.aspx?contentid=10915&amp;amp;technology=34&amp;amp;prod=&amp;amp;prodfamily=&amp;amp;loc=" title="SQL Injection - All Too Common" target="_blank"&gt;Quest Software Pain of the Week; Understanding &amp;amp; Preventing SQL Injection Attacks&lt;/a&gt; - with Kevin Kline and K. Brian Kelley
&lt;p style="padding-left:30px;"&gt;SQL Injection attacks is the most common hacker trick used on the Web and yet, one of the easiest to prevent. Learn what they are and why you need to be concerned about them. In this webcast, I and SQL Server MVP K. Brian Kelley (&lt;a href="http://sqlblog.com/controlpanel/blogs/www.sqlservercentral.com/blogs/brian_kelley/default.aspx" title="K.B.K. at SQLServerCentral" target="_blank"&gt;blog &lt;/a&gt;| &lt;a href="http://twitter.com/kbriankelley" title="He's also a youth minister" target="_blank"&gt;twitter&lt;/a&gt;) will demonstrate different types of SQL injection attacks. You’ll learn how to find and block them to keep your databases safe, preventing disruptions to your organization. &lt;a href="http://sqlserver.quest.com/" title="Great MSSQL Products from a Great Company" target="_blank"&gt;Quest&lt;/a&gt; is sponsoring this as well and raffling off more goodies.  (Free, but registration required.)&lt;/p&gt;

Thu, Feb 11, 2010 at 6 pm CST - &lt;a href="http://www.nashdotnet.org/Home/tabid/76/ModuleID/408/ItemID/38/mctl/EventDetails/Default.aspx" title="Presenting in my home town, Nashvegas" target="_blank"&gt;Nashville .NET User Group; Ten Things DBAs Want .NET Developers to Know&lt;/a&gt;
&lt;p style="padding-left:30px;"&gt;Stereotypes abound for different types of people in the IT world. Developers think DBAs are control freaks. DBAs think developers are unruly cowboys. How do we overcome these differences? If you’re a developer, your best strategy is to manage your DBAs’ anxieties and demonstrate your competence and credibility. Attend this session to learn about 10 techniques that developers can apply to their code which will calm your DBAs’ fears and earn their admiration. Techniques include how to analyze a query plan and how to make sure your query is taking advantage of the best available indexes.  Attendance is free although registration is encouraged so we can get a good count for the food, plus there's free pizza and a raffle at the end.  Drinks afterwards at Chilis.&lt;/p&gt;

&lt;h3&gt;Coming Soon&lt;/h3&gt;
Mar 03, 2010 &amp;gt;&amp;gt;&amp;gt;&lt;i&gt;&lt;b&gt;FULL DAY OF FREE TRAINING&lt;/b&gt;&lt;/i&gt;!&amp;lt;&amp;lt;&amp;lt; - &lt;a href="http://www.vconferenceonline.com/shows/spring10/quest/register/multireg.asp?newmem=1" title="Live from Sunny Tucson, AZ" target="_blank"&gt;Quest Software SQL Server vConference; Troubleshooting and Performance Tuning&lt;/a&gt; with Kevin Kline, Brent Ozar, and Ariel Weil
&lt;p style="padding-left:30px;"&gt;Join SQL Server MVPs, Kevin Kline and Brent Ozar (&lt;a href="http://www.brentozar.com" title="His blog's original name was &amp;quot;King of SQL Server&amp;quot; but felt it might be a tad haughty." target="_blank"&gt;blog &lt;/a&gt;| &lt;a href="http://twitter.com/brento" title="Many followers think it's about &amp;quot;B&amp;quot; Rentals." target="_blank"&gt;twitter&lt;/a&gt;), along with Quest Product Manager &lt;a href="http://www.vconferenceonline.com/shows/spring10/quest/register/bio.asp?id=3" title="He doesn't blog or tweet, but he's a fricken genius!" target="_blank"&gt;Ari                             Weil&lt;/a&gt; —all from &lt;a href="http://sqlserver.quest.com" title="Trading under Qsft - buy our stock!" target="_blank"&gt;Quest Software&lt;/a&gt;—as they interactively present tips and tricks to help you monitor                             your SQL Server environment with ease. You’ll learn how to use Dynamic Management                             Views (DMVs) to simplify troubleshooting and significantly enhance SQL Server performance.                             The day consists of &lt;span style="text-decoration:underline;"&gt;&lt;i&gt;eight sessions with live Q&amp;amp;A&lt;/i&gt;&lt;/span&gt; - a great way to get answers to your questions straight from the source. Chat live with Quest experts. Plus, you can visit the Quest booth to download helpful resources like white papers, watch demos and more.  This virtual training day is free and you can attend the sessions that fit your needs - perfect for tight budgets and busy schedules.&lt;/p&gt;

Mar 06, 2010 - &lt;a href="http://www.sqlsaturday.com/33/eventhome.aspx" title="Home of Bank of America - &amp;quot;May we wedgie your mortgage?&amp;quot;" target="_blank"&gt;PASS SQL Saturday, Charlotte, SC&lt;/a&gt;
&lt;p style="padding-left:30px;"&gt;The SQL Server Community will experience an event like no other in the Southeast region. Renowned speakers from around the world will gather in Charlotte, NC to share their knowledge on Microsoft SQL Server. This is your opportunity to meet, network with and learn from the SQL Community leading experts such as Andrew Kelly, Rick Heiges, John Welch, Brian Knight, Geoff Hiten, Andy Warren, Jessica M. Moss, Rafael Salas, Sergey Pustovit and Tim Ford. Also scheduled to present are current SQL PASS President Rushabh Mehta and former SQL PASS Presidents Wayne Snyder and Kevin Kline.&lt;/p&gt;

Mar 24, 2010 - &lt;a href="http://dba.sqlpass.org/" title="Details to come...eventually." target="_blank"&gt;PASS DBA Virtual Chapter&lt;/a&gt;; SQL Internals &amp;amp; Architecture
Apr 08, 2010 - &lt;a href="http://www.quest.com/backstage/pow.aspx" title="Details will be announced soon. Bring a friend." target="_blank"&gt;Quest Software Pain of the Week&lt;/a&gt;; The Admin's Guide to SQL Server w/ Buck Woody
Apr 12, 2010 - &lt;a href="http://houston.sqlpass.org/" title="The TN Titans &amp;gt; The Houston Texans. Nyah Nyah Nyah!" target="_blank"&gt;PASS Chapter, Houston&lt;/a&gt;; topic TBD
Apr 17, 2010 - &lt;a href="http://www.sqlsaturday.com/31/eventhome.aspx" title="In Which BrentO and I Will Shock, Amuse, and Entertain You. We might even talk about SQL Server." target="_blank"&gt;PASS SQL Saturday, Chicago&lt;/a&gt;; Keynoting w/ Brent Ozar
May 13, 2010 - &lt;a href="http://www.quest.com/backstage/pow.aspx" title="Buck Still Has to Write This Slide Deck" target="_blank"&gt;Quest Software Pain of the Week&lt;/a&gt;; SQL Server for the Oracle DBA w/ Buck Woody
May 13, 2010 - &lt;a href="http://louisville.sqlpass.org/" title="I'll miss the KY Derby by one week.  Dern!" target="_blank"&gt;PASS Chapter, Louisville&lt;/a&gt;; topic TBD
May 15, 2010 - &lt;a href="http://www.sqlsaturday.com" title="I hope it's on Saturday." target="_blank"&gt;PASS SQL Saturday, Louisville&lt;/a&gt;; topic TBD
May 22, 2010 - &lt;a href="http://www.indytechfest.com/Home.aspx" title="Website to host content soon... I think..." target="_blank"&gt;Indy Tech Fest&lt;/a&gt;; SQL Internals &amp;amp; Architecture

&lt;br&gt;&lt;div id="refHTML"&gt;&lt;/div&gt;&lt;div id="refHTML"&gt;&lt;/div&gt;&lt;div id="refHTML"&gt;&lt;/div&gt;</description></item></channel></rss>