Twitter

Follow SQLQuill on Twitter

Subscribe

MN Pass

SQLQuill – Link Round Up – July 2012 Edition

Here’s the links I’ve tweeted in the last month – hope it is useful/entertaining/etc.

SQL

Tools

News

Entertainment

Sports

Running/Workouts

Sports Humor

July PASSMN Meeting

Sponsored by Magenium Solutions

Magenium Logo High Res

Meeting Details

Please click here for meeting details and to RSVP

O, there’s my data: The Open Data Protocol (OData)

Steve Hughes, Magenic

Earlier this year, Mark Souza from the SQL Server product team spoke at our user group. During the Q&A I asked about interacting better with Oracle. Mark mentioned that OData would be the best way to handle this. I will be discussing what OData is and what tools are involved. I will also explore how to create an OData feed and how to interact with it using tools such as PowerPivot, SSIS, and SQL Azure. I will also examine the impact of OData for data professionals, both good, bad and ugly. In the end, you should understand how OData works and where it can help us expose our data appropriately to our users.

Optimizing Microsoft SQL Server Performance in a Virtual Environment

Denny Cherry, independent consultant

In this session we’ll look over some of the things which you should be looking at within your virtual environment to ensure that you are getting the performance out of it that you should be. This will include how to look for CPU performance issues at the host level. We will also be discussing the Memory Balloon drivers and what they actually do, and how you should be configuring them, and why. We’ll discuss some of the memory sharing technologies which are built into vSphere and Hyper-V and how they relate to SQL Server. Then we will finish up with some storage configuration options to look at.

SQLQuill – Link Round Up – June 2012 Edition

Here’s the links I’ve tweeted in the last month – hope it is useful/entertaining/etc.

SQL

Tools

News

Entertainment

Sports Humor

Running/Workouts

June PASSMN Meeting – Filegroups

Sponsored by Virteva

Meeting Details

Please click here for meeting details and to RSVP

The What, Why, and How of Filegroups

Jes Schultz Borland, Brent Ozar PLF

Every DBA must know how to create and maintain filegroups because they affect performance, maintenance, and security of your data. What are filegroups, and how do you use them? In this session, I’ll show you how to create filegroups, create objects in them, move objects to them, perform maintenance, and walk through piecemeal restores.

Jes Schultz Borland (B/T) is a Consultant with Brent Ozar PLF, and a Microsoft SQL Server MVP. She holds an AAS – Programmer/Analyst degree, and has worked with SQL Server since 2007, focusing on Reporting Services and day-to-day administration. She is an active member of PASS, Director of Communication for MADPASS, founder of Tech on Tap, and LessThanDot.com blogger. She’s a frequent presenter at user groups, SQL Saturdays, and other community events. She is also an avid runner and chef.

Managing Daylight Savings without CLR

Rick Krueger, Premier Applications Inc

Dealing with Daylight Savings is often an afterthought, but can cause major system issues if ignored. Learn how an SSIS package can keep a lookup table with TimeZone information up to date, allowing DateTime conversions as needed.

Rick Krueger, President, Premier Applications Inc (B/T)is a SQL Server indie based in the Twin Cities with 17 years of software and database development experience, working with SQL Server since 1998 (6.5). Don’t let his developer credentials (MCPD) and background fool you, he knows a thing or two about SQL, and is currently focusing on Development DBA work. Rick has recently started tweeting as @DataOgre to get more involved in the SQL Community.

SQLQuill – Link Round Up – May 2012 Edition

Here’s the links I’ve tweeted in the last month – hope it is useful/entertaining/etc.  (I’ve been trying out ifttt and sending all my tweeted links to instapaper.com, then exporting exporting it from there)

SQL

Tools

News

Entertainment

Humor

Sports

Sports Humor

Running/Workouts

Here’s all the Link Round Ups from 2012

May PASSMN Meeting – Introducing Microsoft’s Big Data Solution

Sponsor: Emergent Networks

Date: May 15th, 2012

Time: 4:00 PM – 6:00 PM

Location: 3601 West 76th Street, Suite 600 Edina, MN  55437  – Note new location!

Live Meeting:

Agenda:

  • 4:00-4:15 : Registration / hospitality / networking
  • 4:15-4:30 : Quick Start for Basic Presentations
  • 4:30-5:45 : Introducing Microsoft’s Big Data Solution
  • 5:45-6:00 : Closing comments/prize giveaways

Presentation:

Introducing Microsoft’s Big Data Solution

Lara Rubbelke, Microsoft

Welcome to the world of Big Data! Hive, Pig, Sqoop, HDFS, MapReduce… Discover how to gain new insight from your data by integrating Hadoop with SQL Server. Join this introduction to fundamental Big Data concepts and terms. Learn how others are leveraging Hadoop and how the Microsoft Big Data Solution fits within the data platform ecosystem.

Lara Rubbelke (B/T) brings her passion for data solutions to the community as a Principal Program Manager for Microsoft. Her expertise involves Big Data, OLTP and OLAP systems, data management, performance tuning, encryption, ETL, and the Business Intelligence lifecycle. She regularly delivers technical presentations at local, regional and national conferences, user groups and webcasts. Notably, Lara has regularly presented at TechEd, PASS Summit, numerous SQL Server Launches, and delivered MSDN and TechNet webcasts.

SQLQuill – Link Round Up – April 2012 Edition

Here’s the links I’ve tweeted in the last month:

SQL

Tools

News

Entertainment

Humor

Sports

Sports Humor

Running/Workouts

Here’s all the Link Round Ups from 2012

April PASSMN Meeting–SQL 2012 and Apply T-SQL Magic

Sponsor: Techfuse 2012 – May 16th & 17th

TechFuse

Date: April 17, 2012

Time: 4:00 PM – 7:00 PM

Location: 3601 West 76th Street, Suite 600 Edina, MN  55437 

Live Meeting:

Agenda:

  • 4:00-4:30 : Registration / hospitality / networking
  • 4:30-4:45 : Intro / Greetings
  • 4:45-5:45 : Ted Kummert and Mark Souza – SQL 2012 Discussion and Q+A
  • 5:45-6:00 : Break
  • 6:00-7:00 : Itzik Ben-Gan – Apply T-SQL Magic
  • 7:00-7:15 : Closing comments/prize giveaways

Presentation/Discussion:

SQL 2012 Discussion and Q+A

Ted Kummert, Microsoft and Mark Souza, Microsoft

SQL2012 discussion covering the following topics:

  • Running your Business and Mission Critical environments
  • BIG Data and scaling breakthrough insights throughout your organization
  • Unlock New Insights With Pervasive Data Discovery Across the Organization
  • Adopting the Cloud on your own terms

Ted Kummert is corporate vice president of the Business Platform Division (BPD) within the Microsoft Server and Tools Business at Microsoft Corp. He is responsible for leading the product strategy and development of an integrated application platform – including database and application servers, cloud services, and data programmability and modeling technologies.

Mark Souza (Site/Twitter) is a General Manager in the Microsoft Business Platform Division. He is responsible for all Customer/Partner interaction, Content and Community for the business platform products at Microsoft: Middleware, Database and Cloud. Using Customer Experiences he ensures the BPD division is building and shipping products that customers need to build enterprise class solutions. He is responsible for building the best, most vibrant technical community in the world. He also ensures that the Business Platform community has the highest quality content at their fingertips at the time they need it. Mr. Souza’s twenty eight+ years in the Information Technology business has consisted of database administration, end-user tool management, systems engineering database specialist/lead, client/server architect, Microsoft regional data technology specialist, SQL Server development customer advisory team and most recently general manager of customer, content and community.

Presentation:

Apply T-SQL Magic

Itzik Ben-Gan, SolidQ

When a new version of SQL Server is released, with most of the new T-SQL features that are introduced you can usually quickly tell what their benefits are and what you can use them for. But with some features, it can take some time before people start discovering their true value and what you can do with them. Such is the APPLY operator that was added in SQL Server 2005. Initially it seemed just like an ordinary language element with a couple of uses, but with time people found very creative and interesting uses for it. This session describes the APPLY operator, and focuses on advanced, creative uses.

Itzik Ben-Gan (Blog/Twitter) is a Mentor and Co-Founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server 2008: T-SQL Fundamentals, Inside Microsoft SQL Server 2008: T-SQL Querying and Inside Microsoft SQL Server 2008: T-SQL Programming. He has written articles for SQL Server Magazine, SolidQ Journal and MSDN. Itzik’s speaking activities include TechEd, DevWeek, SQLPASS, SQL Server Magazine Connections, various user groups around the world, and SolidQ’s events to name a few. Itzik is the author of SolidQ’s Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.

Top 10 Technological Time Savers to Keep in Touch

Social media these days can be a full time job – at least I could easily kill many hours per week in this area.  My job doesn’t allot any time for twitter, blogging, reading blogs, etc.  Therefore if I want to network, read blogs, blog, keep an eye on what’s happening in the SQL world in general, I’ve got to be smart about it, stay organized and make some shortcuts.  Here’s a list of my top 10 time savers to keep my finger on the pulse and interact with the SQL Community.  Note, all of these apps/services are free – at least at the basic level, which works fine for me.

time

  1. Google Reader – Anytime I’m on a computer, Google Reader is usually up.  Anytime I am browsing the web, I’m looking for feeds.  My three Google Reader tips:
    1. Learn the keyboard shortcuts
    2. Use folders to organize your feeds
    3. If you don’t know how Google Reader works, watch this video, or here’s a slightly deeper explanation.
  2. Google Chrome – every browser has it’s strong and weak points – I’ve learned the ins and outs of Google Chrome and it works for well me.  I know the keyboard shortcuts and I love the fact that the address bar is a built in Google search box with instant results.
  3. Paper.li – This creates a daily paper from the shared links on Twitter.  I try to set aside 5 minutes a day to read up on what’s happened in the last 24 hours.  I’d recommend these two papers:
    1. The PASS MN Paper
    2. The SQLQuill Daily
  4. Tweetdeck – newest version has a better ability to manage columns, list management and I like the chrome app.
  5. ifttt – “Put the internet to work for you” – this site/service is amazingly simple.  It allows you to create custom tasks from things that happen.  Here’s a good explanation of how it works from LifeHacker.com.
  6. Buffer – This site allows you to schedule tweets (and facebook updates), but the really cool thing it provides is the analytics of the links you send via twitter.  I was quite surprised – a few things I thought people loved, nobody clicked on.  A few things I thought was no big deal, tons of people clicked on.
  7. Dropbox – Is a simple, easy to use file synchronization tool.  I install it in the same location on all of my computers for consistency sake.  This also allows me to make bookmarks in chrome to dropbox files, sync my chrome bookmarks and have them work.  It also works well for tasks in ifttt.
  8. Keepass – Password manager – works great, I keep it in my dropbox folder and thus it’s on all my computers.
  9. TrueCrypt – Creates encrypted volumes, which looks just like a file.  Anything in my Dropbox folder that I want extra security on, I mount an encrypted volume in my Dropbox folder and add the files there.  Okay, I know on the surface it doesn’t look like it has much to do with Social Media, but I can use this to secure files for presentations, upcoming blog posts, presentations, etc – plus I also have created drives using truecrypt for data files on my local machine to mimic the drive layout of a server.
  10. Windows Live Writer – My blog editor of choice because it’s fast, free and easy to use.  It’s just like MSWord.  You can also customize it and add plugins to it.

I hope this has helped – I know they help me all the time.  In fact, I started this post on a different computer, put the notes in my dropbox folder and posted via Live Writer on a different computer.  Hopefully it will at least introduce you to one tool that will help you get organized, be more productive or interact with the SQL Community.

TimeMindMap

SQLQuill – Link Round Up – March 2012 Edition

Here’s the links I’ve tweeted in the last month – hope it is useful/entertaining/etc.

SQL

Tools

Entertainment

Sports Humor

Sports

Running/Workouts