“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…

0

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…


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…

0

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…


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…

0

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…


“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…

0

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…


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…


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…

1