Browse by Tags

  • Blog Post: Update - SQL Server 2008 Standard Edition from Heroes Happen Here Launch

    Over the last couple of weeks I received a number of emails from individuals who attended the Heroes Happen Here (HHH) Launch events in the spring of 2008.  These emails all asked the same question:  I got my HHH kit and went online to request my copy of  SQL Server 2008 Standard Edition...
  • Blog Post: Microsoft Acquires ProClarity to Enhance the BI Platform

    In a rather exciting development on the business intelligence front, Microsoft today announced it has signed an agreement to acquire ProClarity – a leading provider of software that provides advanced analysis and visualization technologies for the Microsoft BI Platform. The acquisition of ProClarity...
  • Blog Post: SQL Server and .NET Coffee Break Tutorials Available Online

    I recently got an email from Ralph Shillington, an MCT and former colleague, on a new resource that he is making available on the web. His company, iFoundTime Inc . is posting a series of SQL Server and .NET tutorials online and is also asking for your input on what else you want to see. While Ralph...
  • Blog Post: The “SQL Guy” Post # 22: Understanding Transparent Data Encryption

    You may have heard about Transparent Data Encryption (TDE), which was introduced in SQL Server 2008. But what does it do, what are its advantages and disadvantages and how can you leverage this technology in SQL Server? Keep reading this tips and tricks article to learn how.   Transparent Data Encryption...
  • Blog Post: Get Ready for Windows 8 & Windows Server 2012 with MAP 7.0 Beta

    Last week we released a beta version of Microsoft Assessment & Planning (MAP) Toolkit 7.0.  The MAP Toolkit,  a free download , is an agentless, automated, multi-product planning and assessment tool for quicker and easier desktop, server and cloud migrations. MAP provides detailed readiness...
  • Blog Post: “The SQL Guy” Post #3: THE POWER OF SQL SERVER 2008 CENTRAL MANAGEMENT SERVER

    Here is another great article from Saleem Hakani of the SQL Server product team at Microsoft.  Enjoy! Imagine this: Your manager has asked you to find out the available disk space for all the drives from SQL Servers in the production environment and you have 6800 SQL Servers that are spread in North...
  • Blog Post: New Generation of Microsoft Certification Exams Released

    If you've been looking forward to taking the New Generation of Microsoft Certification Exams, your wait is over. The following seven exams are now available at our testing providers. • Exam 70-528: TS: Microsoft .NET Framework 2.0 - Web-Based Client Development • Exam 70...
  • Blog Post: “The SQL Guy” Post # 13: Changes to Location of Startup Options in SQL Server 2012

    Many users have hated the way SQL Server supported configuring startup parameters in previous versions. It was confusing and buried in a single text box under the Advanced Tab of SQL Server services in Configuration Manager. The only way you could separate different options is by using a semicolon(;...
  • Blog Post: Step-By-Step: Backing Up SQL Databases to Azure

    While delivering an CANITPRO Camp not to long ago, an IT administrator shared his story as to why he had decided to move his organization's SQL backup to the cloud. It seemed that his predecessor was very diligent in switching the backup tapes every morning. He insured backups were created daily, weekly...
  • Blog Post: TechDays Speaker List Coming Together for the Data Management Track

    The Toronto stop of TechDays Canada 2008 is just a month away!! Things are heating up and we are getting together a great roster of speakers for the Data Management Track across all 7 cities. Starting with Toronto, you will be able to hear from folks such as SQL Server MVP s Tom Moreau and Val Matison...
  • Blog Post: Interesting SQL Server 2005 Encryption and Key Management Post

    I had the pleasure of attending a webcast on SQL Server 2005 Security from a developer perspective today. Dan Sellers, a member of the Microsoft Canada DPE team based in Calgary, was one of the key presenters during the session and he got asked an interesting question that I was curious to hear the answer...
  • Blog Post: IgniteIT Awards Finalist – Edmonton School

    Project: K-12 Network Overhaul   The Challenge Describe the situation, challenge or problem you or your team faced.   A private K-12 school was running on a Windows Server 2000 network with an infrastructure that had been neglected and was falling apart. Viruses, spyware, 10mb hubs, and lack...
  • Blog Post: 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...
  • Blog Post: Who Wants a Licensing Advisor?

    I do! I am the first to admit that licensing can be really confusing but there are some tools that can help you (including the CanITPro team) navigate the waters so to speak. In the virtualization realm there are some calculators which I linked in a previous article to which would help you figure out...
  • Blog Post: “The SQL Guy” Post #14: The Myth Behind Stored Procedure Behaviour

    You are a trusted database developer for your company. You developed a Stored Procedure that will perform some important functions on the database. You tested the Stored Procedure and everything looks great. The Stored Procedure runs the way you expected and within the anticipated timeframe. Everything...
  • Blog Post: “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...
  • Blog Post: [Podcast] A talk about the MVP program

    On October 23rd 2006, Microsoft Canada hosted an mini MVP summit in Mississauga which was streamed to satellite sites and MVPs across Canada. It was a great time and I got the chance to sit down with the Canadian MVP Lead Sasha Krsmanovic, SBS MVP Cal McLennan, SQL MVP Tom Moreau and US MVP Lead Ed Hickey...
  • Blog Post: 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.  ...
  • Blog Post: 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...
  • Blog Post: The “SQL Guy” Post # 28: Introducing the New IIF() Function in SQL Server 2012

    In SQL Server 2012 we have added the IIF() function to the SQL Server family of functions. It is a brand new logical function being introduced with SQL Server 2012 that allows you to perform IF..THEN..ELSE condition within a single function. This helps in simplified code and easy to read conditions....
  • Blog Post: SQLTeach Vancouver Resources

    Database Mirroring Resources: SQL Server: Database Mirroring Best Practices and Performance Considerations Database Mirroring in SQL Server 2005 SQL Server 2005 Database Mirroring FAQ SQL Q&A: Server Tuning, Mirroring, Log Shipping and more SQL Server Storage Engine : Database mirroring...
  • Blog Post: My TechNet Q&A - Ottawa & St. John's

    Rick visited St. John's Newfoundland and I made my way to Ottawa for the My TechNet Security tour and again the sessions led to some great Q&A at the end of the day. There were some great questions on SQL database encryption and you can find out more information on this at the following websites...
  • Blog Post: 22 Free Microsoft eBooks to Add to Your Must Read List

    During the summer months, I always try to catch up on my must read list. These are books that are perfect to read at the cottage on long weekends, when I’m off on vacation, or even when I’m travelling for work. For the work you do, it’s a little different; you’re probably not...
  • Blog Post: SQL Server Migration Assistant CTP for Sybase and Access Now Available

    TechEd is always a great time to stay tuned for new and exciting announcements from Microsoft and this year is no exception. Earlier in the week we announced the Microsoft Forefront family of products, a comprehensive set of security-related products that include the Antigen line of anti-virus and anti...
  • Blog Post: Team Edition for Database Professionals…

    Adam Galant is a great guy to know when it comes to Visual Studio Team System… He works in my group in Mississauga on the Developer Tools side of the house and maintains his own blog . I asked him to write up a post specifically about Tem Edition for DB IT Pros in response to a press release and...