Tag: syndicated

  • 2011 MVP Summit – Day 1

    I’m glad I went running this morning. It’s been a long day, in and out of sessions and meetings all day on the Microsoft campus. I didn’t get to a lot of sessions, preferring to meet with people in the hallways and talk about SQL Server and database stuff. The most valuable time for me is always the time when I get to talk with people and network, building bonds and relationships that will help me in the future.

    Or maybe will help the other person. Networking is funny that way. You never know if you’re giving or receiving more from a person, but it all seems to result in a great synergy to me.

    Glad I was up early to run as I had to work a bit tonight and am about to head out to the evening reception.

     

     

  • Test Complete – MCM

    I took the MCM test today, and finished it. I needed the time allotted and it was, well, an experience.

    I’m glad it’s done as I have a number of other things to work on. I’ll get results in a few weeks and in the meantime, I’ll get permission to see what I can write about the experience.

  • You Can’t Disable the CLR in SQL Server – MCM Prep

    At least not completely. There are some functions in SQL Server that are built on the SQL CLR, and even if you have disabled the CLR for user written code, it still loads app domains and functions for system code.

    An example of this is the spatial data type. It’s a SQL CLR written user defined data type, but written by Microsoft. If you create a spatial variable, the SQL CLR loads an app domain and code for the UDT using spatial data.

    Not a big problem, and not a security risk from my standpoint, but it is worth knowing if you have to debug into memory or some detailed traces/events and see the SQL CLR loading. Don’t panic, and understand that you can’t prevent this from loading for these system objects.

  • T Minus Three Days to the MCM Test

    I take the MCM test on Friday. I’ve been watching videos and reading white papers and blogs for the last few weeks and I know that I don’t necessarily know enough. To some extent I have an advantage since I test well on multiple choice tests and I have a broad set of knowledge for SQL Server.

    rockholesBut I don’t know enough. The more I study, the more it becomes painfully clear how much more there is to SQL Server that I don’t understand. Each day I learn something new, but I also learn that there are things I wasn’t aware of

    Often, I find that things I just learned are things that friends already know. The thing that gives me some hope is that they will learn something and tell me, not realizing I already know about it.

    We all have these uneven holes of knowledge, and just because we do, or don’t, know about feature X, doesn’t mean that we don’t know a lot about feature Y. We have un-evenly learned SQL Server since there isn’t a set path on which to learn.

    So I’m nervous, just because it’s a measure of my skill, not because it matters to my career. It will give me a benchmark, and a place from which I can make a plan for how much more I want to learn about SQL Server, and in which areas to work.