• The “SQL Guy” Post #25: String Concatenation Using CONCAT() in SQL Server 2012

    SQL Server 2012 introduces a brand new string function called CONCAT() . CONCAT() string function allows you to concatenate up to 255 string or variable values in to one single string. It requires a minimum of two input values when calling the function and takes care of implicitly converting the data values to a string by following the data type conversion rules of SQL Server 2012. This function would...
  • The “SQL Guy” Post #26: New OFFSET and FETCH Query Options in SQL Server 2012

    SQL Server 2012 introduces brand new query hints that allow you to implement query paging solution. In the past, we have used TOP operator to return the top number of rows from a table. However, OFFSET & FETCH options of the ORDER BY clause can give you more benefits than just the TOP operator.   Assume you have 50,000 records in a table and you want to query 1200 rows starting from 25000...
  • Déployer Windows 7 avec MDT 2010, Partie 3 – Déployer une image référence Windows 7

    This post is the third post in a 4-part series for our French-speaking readers on how to use MDT 2010 to deploy Windows 7 in your environment. The series is written by Yannick Plavonil , a Microsoft MVP based in Quebec. You can find this and more on his own blog – Revue du Geek . Let me know what other topics you would like covered in the future. Leave a comment or send an email by clicking on the...
  • The “SQL Guy” Post # 23: TRIGGER-less Tracking of Database Changes

    There are times when you need to track all the changes happening to a table. In the past, developers have used custom code to track changes by calling stored procedures, triggers and until recently even change data capture (also known as CDC). SQL Server now supports a simplified method of auditing changes using DML statements without having to use Triggers or CDC (Change Data Capture) . SQL Server...
  • Déployer Windows 7 avec MDT 2010, Partie 2 – Creer une image référence Windows 7

    This post is the second in a  4-part series for our French-speaking readers on how to use MDT 2010 to deploy Windows 7 in your environment. The series is written by Yannick Plavonil , a Microsoft MVP based in Quebec. You can find this and more on his own blog – Revue du Geek . Let me know what other topics you would like covered in the future. Leave a comment or send an email by clicking on the...
  • Gérer les drivers dans MDT 2010, Partie 1 – Les drivers fournis sous forme d’application

    Continuing with our theme of how to make use of the Microsoft Deployment Toolkit 2010 , here we have the first of a 3-part series for our French-speaking readers on how to manage drivers using MDT 2010 to help ensure your deployment of Windows 7 on your new PCs works well.  The series is written by Yannick Plavonil , a Microsoft MVP based in Quebec. You can find this and more on his own blog ...
  • The “SQL Guy” Post # 24: Backing Up Large Mission-Critical Databases

    In an ideal world, hard drives and other hardware never fail, software is never defective, users do not make mistakes, and hackers are never successful. However, we live in a less than perfect world and we should plan and prepare to handle adverse events.   In today’s topic, we will focus on best practices for backing up large mission critical databases. Performing and maintaining good backups...
  • Déployer Windows 7 avec MDT 2010, Partie 4 – Utilisation la base de donnée dans MDT

    This post is the fourth and final post in a 4-part series for our French-speaking readers on how to use MDT 2010 to deploy Windows 7 in your environment. The series is written by Yannick Plavonil , a Microsoft MVP based in Quebec. You can find this and more on his own blog – Revue du Geek . Let me know what other topics you would like covered in the future. Leave a comment or send an email by clicking...
  • Exam Prep for 70-659 Part 7: Configuring Child Network Adapters

    As I wrote in an earlier post , there is no better time to write your exam for 70-659 Windows Server 2008 R2, Server Virtualization, than now and particularly before May 31, 2012. So to aid in that endeavour, Joseph Yedid, an IT specialist with Enhansoft in Ottawa, has put together a series of posts focused on getting IT folk ready to pass this exam. Joseph writes his blog at www.josephyedid.com but...
  • MCSE is Back–and Better Than Ever!!

    I remember getting my first MCSE certification in the mid-1990s and feeling really proud of the accomplishment.  Many of my peers at that time also pursuing an MCSE felt that it was a certification that would increase their likelihood to get hired over a candidate that did not hold the certification.  Things were good and we were all doing well.  Over the years, the MCSE was replaced...
  • Exam Prep for 70-659 Parts 11 & 12: Configure Authorization Rights and Manage VMware Hosts

    As I wrote in an earlier post , there is no better time to write your exam for 70-659 Windows Server 2008 R2, Server Virtualization, than now and particularly before May 31, 2012. So to aid in that endeavour, Joseph Yedid, an IT specialist with Enhansoft in Ottawa, has put together a series of posts focused on getting IT folk ready to pass this exam. Joseph writes his blog at www.josephyedid.com but...
  • Windows Server “8” Beta Getting Started–The Minimal Server Interface (aka MinShell)

    As IT professionals one of our key responsibilities is to ensure that the servers we are running have the smallest attack footprint possible.  While keeping these same servers updated with the most recent patches also helps to ensure that the impact of malware is minimized, patching a full fledged GUI install of Windows Server means that the likelihood of a reboot being required was far greater...
  • Gérer les drivers dans MDT 2010, Partie 2 – Quelle stratégie à adopter ?

    Continuing with our theme of how to make use of the Microsoft Deployment Toolkit 2010 , here we have the second post of a 3-part series for our French-speaking readers on how to manage drivers using MDT 2010 to help ensure your deployment of Windows 7 on your new PCs works well. The series is written by Yannick Plavonil , a Microsoft MVP based in Quebec. You can find this and more on his own blog ...
  • Exam Prep for 70-659 Part 8: Create and Deploy Virtual Machines

    As I wrote in an earlier post , there is no better time to write your exam for 70-659 Windows Server 2008 R2, Server Virtualization, than now and particularly before May 31, 2012. So to aid in that endeavour, Joseph Yedid, an IT specialist with Enhansoft in Ottawa, has put together a series of posts focused on getting IT folk ready to pass this exam. Joseph writes his blog at www.josephyedid.com but...
  • Talking to MVPs & Customers at MMS 2012– Manulife’s Journey to Private Cloud

    This year I get the opportunity to connect with the sizeable contingent of customers, Partners and Microsoft Valued Professionals (MVPs) attending the Microsoft Management Summit 2012 (MMS 2012) in Las Vegas April 16-20. Each of the individuals I spoke to were very excited about what they will see and hear about Microsoft’s Private Cloud Platform , System Center 2012 , as well as upcoming technologies...
  • Talking to MVPs & Customers at MMS 2012– Kathleen Wilson

    This year I get the opportunity to connect with the sizeable contingent of customers, Partners and Microsoft Valued Professionals (MVPs) attending the Microsoft Management Summit 2012 (MMS 2012) in Las Vegas April 16-20. Each of the individuals I spoke to were very excited about what they will see and hear about Microsoft’s Private Cloud Platform , System Center 2012 , as well as upcoming technologies...
  • Exam Prep for 70-659 Part 9: Managing and Monitoring Virtual Machines

    As I wrote in an earlier post , there is no better time to write your exam for 70-659 Windows Server 2008 R2, Server Virtualization, than now and particularly before May 31, 2012. So to aid in that endeavour, Joseph Yedid, an IT specialist with Enhansoft in Ottawa, has put together a series of posts focused on getting IT folk ready to pass this exam. Joseph writes his blog at www.josephyedid.com but...
  • Talking to MVPs & Customers at MMS 2012– Brad Bird & Colin Smith from Cistel Technology

    This year I get the opportunity to connect with the sizeable contingent of customers, Partners and Microsoft Valued Professionals (MVPs) attending the Microsoft Management Summit 2012 (MMS 2012) in Las Vegas April 16-20.  Each of the individuals I spoke to were very excited about what they will see and hear about Microsoft’s Private Cloud Platform , System Center 2012 , as well as upcoming technologies...
  • Microsoft Private Cloud Guided Labs Now Available

    The cavalcade of virtual hands-on labs just keeps on going!  Not only can you try out the features and capabilities of Windows Server “8” beta (now Windows Server 2012) as I blogged about this morning, we have also just released a series of 14 guided labs to allow you to get you familiar with Microsoft’s Private Cloud platform , including System Center 2012 and Windows Server 2008 R2 SP1 . ...
  • Talking to MVPs & Customers at MMS 2012– Kath McBride from Microsoft Canada

    This year I get the opportunity to connect with the sizeable contingent of customers, Partners and Microsoft Valued Professionals (MVPs) attending the Microsoft Management Summit 2012 (MMS 2012) in Las Vegas April 16-20. Each of the individuals I spoke to were very excited about what they will see and hear about Microsoft’s Private Cloud Platform , System Center 2012 , as well as upcoming technologies...
  • Talking to MVPs & Customers at MMS 2012–Dave Kawula from Tricon Consulting.

    This year I get the opportunity to connect with the sizeable contingent of customers, Partners and Microsoft Valued Professionals (MVPs) attending the Microsoft Management Summit 2012 (MMS 2012) in Las Vegas April 16-20. Each of the individuals I spoke to were very excited about what they will see and hear about Microsoft’s Private Cloud Platform , System Center 2012 , as well as upcoming technologies...
  • Exam Prep for 70-659 Part 5: Configuring Child Resources

    As I wrote in an earlier post , there is no better time to write your exam for 70-659 Windows Server 2008 R2, Server Virtualization, than now and particularly before May 31, 2012. So to aid in that endeavour, Joseph Yedid, an IT specialist with Enhansoft in Ottawa, has put together a series of posts focused on getting IT folk ready to pass this exam. Joseph writes his blog at www.josephyedid.com but...
  • Exam Prep for 70-659 Part 10: Configuring Delegation of Rights

    As I wrote in an earlier post , there is no better time to write your exam for 70-659 Windows Server 2008 R2, Server Virtualization, than now and particularly before May 31, 2012. So to aid in that endeavour, Joseph Yedid, an IT specialist with Enhansoft in Ottawa, has put together a series of posts focused on getting IT folk ready to pass this exam. Joseph writes his blog at www.josephyedid.com but...
  • Talking to MVPs & Customers at MMS 2012– Rory McCaw & Efim Idelman from InFront Consulting

    This year I get the opportunity to connect with the sizeable contingent of customers, Partners and Microsoft Valued Professionals (MVPs) attending the Microsoft Management Summit 2012 (MMS 2012) in Las Vegas April 16-20. Each of the individuals I spoke to were very excited about what they will see and hear about Microsoft’s Private Cloud Platform , System Center 2012 , as well as upcoming technologies...
  • Zoom, zoom, zoom, we’re going to the moon…with Microsoft Private Cloud

    These days around the Microsoft Canada office and particularly in my little corner of the world, everyone is laser focused on getting IT folks downloading, learning and certified on Microsoft technologies…specifically private cloud technologies. And just to give you a bit of incentive, we’ve come up with The Skyrocket Sweepstakes . Y’know…for anyone in IT who wants their career to “take off”. What...