• “The SQL Guy” Post # 9: SQL Server Database Engine Permission Model–Part 3

    In this third and final instalment of our series on the SQL Server Database Engine Permission Model, we look execution context switching – in other words when I access an object, from whose perspective should I be assigned permissions.  As always, if you want to test these out and don’t have SQL Server handy, you can download a full-featured evaluation copy of SQL Server 2008 R2 from the TechNet...
  • Happy Holidays from the Canadian IT Pro team

    Damir, Ruth and Myself along with our manager Ryan and extended team member Chris want to wish you all the best. You're awesome and you make a difference for your users and customers every day. If no one has said it recently - Thank you for doing a great job this year. If things are a little slower at work over the next while - take some time to recharge and spend time with your friends and family...
  • Online Media nourishment. Fit for IT Pro consumption.

    Hello folks, This is my compilation of some of the online resource available to you in January 2012.   JANUARY 2012 !!!  My god… Where did 2011 go???  Time really flies by,  and that’s one more reason to review this list and plan our learning opportunities. This list featuring both live and on-demand content for December including webcasts, videos, virtual labs, and podcasts...
  • Powershell on the Way to Work–Part 9

    Today is car pool day.   Only problem is somebody at work took that literally and I’m squished in the back seat of a Compact with a “Mr. Turtle” pool. So I promised to show you one of the cooler Cmdlets I ran into, EXPORT-CSV. Ok, so what if I told you I could give you a line in Powershell you could run on a staff member’s computer to show just HOW MANY Mp3 files were sitting on their personal...
  • Got that FREE DoubleDouble? Here’s Things To Do While Enjoying It!

    Rick’s blog post and call to action to download the System Center 2012 RC products and get a coffee card from that great Canadian chain whose name rhymes with Jim Morton is a great incentive to action, but many folks have asked “What do I do after I have the System Center 2012 RC products to maximize my learning?”.  GREAT QUESTION! Before anything else , you have to download the SC2012 RC products...
  • Powershell on the Way to Work–Part 8

    Ok feeling better today. Today we’re going to quickly touch on “Objects”. Now before all of you IT Pros go running into a corner screaming and casting oil slicks beyond you, we are NOT opening up Visual Studio. But we are going to touch lightly on a topic that is important to be aware of when using Powershell. No, you will not get tested on this. Really it’s not that bad...
  • “The SQL Guy” Post # 8: SQL Server Database Engine Permission Model–Part 2

    Last week we started the first of a three-part series on SQL Server database permissions and the permissions security model used by the database engine.  Last week’s blog post covered the commands used in T-SQL to manage permissions, as well as the security scope within SQL Server.  This week we look into how permissions behave they are applied at various points of an ownership chain, such...
  • Powershell on the Way to Work–Part 7

    “Aaaaaachoo!” Sorry got as cold today.  But we can still chat right? Today we’re going to learn about Variables in Powershell.   Ok don’t run away.  I’m not going to get all Developer on you and starting speaking in Tongues and spout Functions and code. We’re going to use Variables for the moment the same way we did in Dos.   Dos was easy SET THIS=SomethingOrOther And...
  • Powershell on the Way to Work–Part 6

    Hello, back on the grid again.  literally.   It appears that “Somebody” decided that redirecting all the traffic down a one lane residential street was a good idea.  So I’m stuck for a bit.  We can talk. Being that I have Time on my hands I think today we’ll talk about time in Powershell.   It IS far cooler than the old CMD.EXE prompt and far more Powerful.  ...
  • What was I thinking???

    Hello folks, Today my daughters helped me realize something. they convinced me to stop watching videos and reading “howto” articles and actually strap on the snowboard and go to the hills with them. You see… I’ve been contemplating learning to Snowboard. I went out I bought a board, boots, a helmet, the whole kit and kaboodle. (I don’t know where this expression comes...
  • How would you like a DoubleDouble ?

    This time of year everyone is rushing to get things done both work and in their home life. As you rush to the get ready for the holidays – you might also be like a lot of IT folks who relish the time in-between December 25th and new years eve. This slower / quieter time at work could open up an opportunity – a brief window of time - where you can try some things out before the new year...
  • Powershell on the Way to Work–Part 5

    Oh hey.  Back again are you?  Good thing too.  Flat tire so I’m stuck on side while the Tow Truck driver changes my tire…. So let me take a few minutes today and show you a pretty cool Cmdlet called GET-CHILDITEM. If you remember a bit back, I showed you how typing DIR executes a GET-CHILDITEM. So you might think “Ah! GET-CHILDITEM is Powershell’s version of DIR!” You might think that...
  • Powershell on the Way to Work–Part 4

    Traffic was rotten today so I’m sitting in a coffee shop.  Don’t tell the boss ok? So last time I mumbled something or other about Aliases and did a Wave of my hands to make you look the other way.  No ? I didn’t do that?  Darn Jedi mind tricks. So we mentioned Aliases.    Those familiar with the Unix world will know what an Alias is.   It’s just another word...
  • Powershell on the Way to Work–Part 3

    Hey!  Glad to see you again.   I took the bus today.   Gives me a little more relaxing time to clear my brain.  It’s nice not to be stuck on the HIghway today. We were playing with getting some basic help on a Powershell Cmdlet.  As we said, most of them are pretty good as they provide examples. Let’s take a look at one of the simpler Cmdlets called “GET-CONTENT”...
  • “The SQL Guy” Post # 7: SQL Server Database Engine Permission Model–Part 1

    This week we start the first of a three-part series on SQL Server database permissions and the permissions security model used by the database engine. In conversations with many individuals across the country, I have found that not all DBAs or prospective DBAs that I have talked to are always sure about how SQL Server security works and a common understanding may help clarify some things. This week...
  • Powershell on the Way to Work–Part 2

    Gimme a second here, just have to park the car for a moment and get out my coffee.   Rush hour is crazy today. If I remember correctly we introduced you to a new Console called Powershell.   Really.  Just that.  A Shell.  Yeah we’re pretty certain it may bring about World Peace someday but we’re going to stick to the basics. Last time we run a Cmdlet (CoMmanD-LET...
  • “The SQL Guy” Post # 6: Save Time Connecting to SQL Server Using Management Studio (SSMS)

    OK, so I’ve been on a bit of a break over the last couple of months. Truth is, with TechDays Canada being one of the major things I am responsible for here at Microsoft Canada, time has been a previous resource. Now that the TechDays 2011 tour is complete, things are looking up to keep these blog posts going. This post provides you with some info on how to take advantage of SQL Server Management Studio...
  • Powershell on the Way to Work–Part 1

    I’ve heard from many IT Pros who want to learn Powershell.   They want to because they need to.   All the new technology revolves about Powershell.  Many vendors are beginning to adopt Powershell as an automation solution. But just where do you start? Let’s start at the beginning.   An Introduction.   My friends, this is the Powershell Console Powershell...
  • Cloud Computing–You’re Probably Already Using It!

    I’m not sure if are aware of this, but twice a year through something we call "The Global Relationship Study" – we here at Microsoft Canada reach out and contact you to see how we're doing and what Microsoft could do better. Every year a number of items come up where you tell us we need to do more to make you understand how some of our technologies can help you be successful in your role...
  • Demystifying Microsoft’s Virtualization Stack: #4 System Center Virtual Machine Manager integration

    Dave Kawula knows his stuff when it comes to Virtualization. When I asked him to put together some screencasts, we came up with a short series of them following the flow from planning through to deployment and management. I wanted to call each one out individually and wrap it together into a series – so we called it “Demystifying Microsoft’s Virtualization Stack” and here we go. Great stuff in here...
  • Demystifying Microsoft’s Virtualization Stack: #3 Disk Subsystems

    Dave Kawula knows his stuff when it comes to Virtualization. When I asked him to put together some screencasts, we came up with a short series of them following the flow from planning through to deployment and management. I wanted to call each one out individually and wrap it together into a series – so we called it “Demystifying Microsoft’s Virtualization Stack” and here we go. Great stuff in here...
  • Have Many Kinds of Devices and Need to Manage Them All? We Have a Tool for That…

    Over the last few months while out visiting many communities through TechDays and other events, I often get questions from IT professionals responsible for ensuring that all devices connected to the corporate network are safe, secure, and accounted for.  With the influx of consumer-focused devices in the workplace that many of you are facing, having a tool to enable this is even more critical...
  • Get your SystemCenter 2012 Groove on! New TechNet Labs LIVE!

    Hot off the press! Get yourself setup with some hands on experience while you are DOWNLOADING the RC for use in your lab and test environments.  These are remote connections to our hyper-v enabled hosting services with pre-built and documented step by step labs you can try.  They are also GREAT for play time in a sandbox where you don’t have to colour inside the lines. There are four new...
  • Demystifying Microsoft’s Virtualization Stack: #2 Node Configuration

    Dave Kawula knows his stuff when it comes to Virtualization. When I asked him to put together some screencasts, we came up with a short series of them following the flow from planning through to deployment and management. I wanted to call each one out individually and wrap it together into a series – so we called it “Demystifying Microsoft’s Virtualization Stack” and here we go. Great stuff in here...
  • Demystifying Microsoft’s Virtualization Stack: #1 Planning Hyper-V Installs

    As I mentioned yesterday in the introductory blog post about Dave Kawula – he knows his stuff when it comes to Virtualization. When I asked him to put together some screencasts, we came up with a short series of them following the flow from planning through to deployment and management. I wanted to call each one out individually and wrap it together into a series – so we called it “Demystifying Microsoft...