Browse by Tags

  • Blog Post: Step-By-Step: Building A System Center Virtual Machine Manager Lab Part 1

    *This post was authored by Garth Gorling. Correction of author is forthcoming Virtualization, and more specifically Hyper-V , is awesome. While I am knowledgeable about Hyper-V, I'm always interested in learning more. I'm interested in having separate, isolated networks. I want users to be...
  • Blog Post: Step-By-Step: Deploying Lync Server 2013 Monitoring

    Recently, significant changes have come to the Microsoft Lync Server 2013 surveillance infrastructure. Starting with the removal of the monitoring server role that is directly integrate on the frontends. Lync Server 2013 allows you to monitor two different types of data: the data for registration...
  • Blog Post: Étape par Étape: Déploiment des Lync Services de Surveillances

    Des modifications importantes ont été apportées à l’infrastructure de surveillance de Microsoft Lync Server 2013 , à commencer par la suppression du rôle Serveur de surveillance qui est intégrer directement sur les Front-ends. Lync Server 2013...
  • Blog Post: TechDays Montreal is a Wrap.....but SQLTeach is only a few weeks away

    After a weekend recovering from TechDays Montreal, most of the teams gets a couple of weeks rest before the Ottawa stop of TechDays on November 27, and then on to Winnipeg and Calgary, and finally Vancouver in January.  If you have not yet registered for these events, they are filling up really...
  • Blog Post: “The SQL Guy” Post # 12: Understanding Data Hashing Techniques in SQL Server

    I don’t often deal a lot with the business intelligence side of SQL Server preferring to spend most of my time on the relational side of the house.  However, once in a while topics about optimizing a data warehouse or helping to secure BI data peak my interest.  I ran across this article by...
  • Blog Post: SQL Server 2005 SP1 CTP is Now Available

    Yesterday, Microsoft announced the public availability of SQL Server 2005 Service Pack 1 (SP1) Community Technology Preview (CTP). In addition to the availability of the SP1 CTP, the SQL Server team is introducing a new transparent customer collaboration model, which will extend the CTP process to service...
  • Blog Post: 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...
  • Blog Post: SQL Server 2008 RC0 Available For Download on TechNet

    Yesterday the SQL Server team reached a key milestone with the release of SQL Server 2008 RC0.  SQL Server 2008 provides a comprehensive data platform that is secure, reliable, manageable, and scalable for your mission critical applications. With it, developers can create new applications that can...
  • Blog Post: Reading Email at Midnight Proves Useful - SQL Server 2008 July CTP is Now Available

    Most folks that know me also know that I tend to work rather late. Well past midnight most nights. It's not that I am a workaholic but there is that 11pm to 2am sweet spot when the kids are asleep and you can focus on whatever it is you need to do. Last night, while going through my email I got a new...
  • Blog Post: The “SQL Guy” Post # 30: How to Recover from a Lost SA Password in SQL Server 2012

    Working at Microsoft provides many opportunities to receive pearls of wisdom from individuals at other parts of the organization.  Saleem Hakani sent along this little gem a few days ago and I wanted to share it with you.  It outlines how to recover an SA password if you forgot it – though...
  • Blog Post: “The SQL Guy” Post #17: Recovering Data Using SQL Server Emergency Mode

    Remember those days when the database would go in to suspect mode and you had to perform various steps to recover the database by putting the database in the emergency mode and then extracting the data out of that emergency database?   These are the high level steps you had to perform in previous...
  • Blog Post: “The SQL Guy” Post #20: Using Cell Level Encryption in SQL Server

    Last week you learned how to setup the encryption key hierarchy in SQL Server .  Now, let’s use encryption to encrypt sensitive data in SQL Server.   It is quite possible that you might have sensitive data that needs encryption at a finer level of detail than the entire database. Most of the...
  • Blog Post: Using SQL 2005 as an IDS log analyzer - Ingenious!

    When my team goes out on tour or as part of a product launch, we meet a lot of people who have fantastic ideas on how to use Technology to get things done and make their lives easier. One of these people is Yaroslav Pentsarskyy – a student at British Columbia Institute of Technology. He came out to the...
  • Blog Post: “The SQL Guy” Post # 11: SQL Server’s Black Box Can Be Very Helpful

    Ever wanted to find out what was happening when SQL Server crashed? Your investigation should also include reviewing the SQL Server activities much like what profiler would do. SQL Server 2005 (including 2008, 2008R2 and the upcoming 2012) come with a default trace enabled out of the box. This trace...
  • Blog Post: “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...
  • Blog Post: SQL Server Roadmap to Denali Webcast Series

    SQL Server 2012 (previously SQL Server code-named “Denali”) has, so many great features for reporting, high availability, business intelligence, and more . If you haven’t had time to sit down and start learning about what’s new in the latest release of SQL Server, join Microsoft Canada for a weekly webcast...
  • Blog Post: Reason #11 To Attend TechDays–The Data Platform Content Area

    We’ve revealed the keynotes , the Windows Client and Phone Track , the Developer Tools, Languages and Framework track , the Developer Practices & Architecture , and the Cloud Computing and Online Services track, but the one thing that all of these have in common is the need to access, store, and...
  • Blog Post: “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...
  • Blog Post: An MVP on SQL Server Clustering

    I was in my "office" this afternoon catching up on some reading and as I flipped through the March edition of the TechNet Magazine a familiar face pops up. Dr. Tom Moreau is a local (Toronto) MVP on SQL Server and he has written a really good article covering tips for clustering a set of SQL Servers...
  • Blog Post: A Few Sleepless Nights

    A while back Ruth did an interview with Cameron McKay about an upcoming infrastructure project he was in the planning stages on.  While the planning is done and the implementation also complete, I thought it was time to revisit with Cameron and talk about how things went.  Turns out Cam was...
  • Blog Post: Cameron McKay: Rebuilding from the Ground Up

    Energize IT 2008 has come and gone. I had a great time talking, rocking, and connecting with the GTA community. Ruth shared this interview she did with Cameron McKay from McKesson Canada about their total network rebuild around Hyper-V, SQL 2008, OCS and more.... You can count on hearing more about this...
  • Blog Post: “The SQL Guy” Post #5: SYNONYMously Reference SQL Server Objects

    Continuing on a topic that includes some more content aimed at DBAs and developers, this week we’ll look at how SYNONYMs can make your life easier.   What would you do when an object that is referenced in several places and in several databases (Stored Procedures, Functions, etc.) is being moved...
  • Blog Post: VHD Library Now Online

    A lot of you have been asking for pre-configured VHDs so that you can test some of the latest Microsoft technologies. We get tons of requests for the VHDs we use when we are on tour, but due to licensing issues (i.e. the Core I|O VHDs were built with my personal TechNet keys) we can't supply them. I...
  • Blog Post: “The SQL Guy” Post # 10: INSERT Multiple Rows with Table Value Constructor

    Wouldn’t it be nice to have the ability to insert multiple rows of data using one Insert statement? Every time you create a table and have to insert rows manually, you will need to repeat “Insert Into <Tables> values..”   SQL Server 2008 and up provide the ability to insert multiple rows of...
  • Blog Post: “The SQL Guy” Post #15: Best Practices For Using SQL Server Service Accounts

    Securing SQL Server is one of the top priorities of any SQL Server DBA. It is extremely important for DBA’s and system admins to make sure that SQL Server is TIGHTLY SECURED and is not exposed to users that don’t need access to SQL Server. Only valid and required users MUST be granted “required” permissions...