Until we meet again…

Today is my last day with Microsoft.  After five and a half years, I recently decided to join SQLskills as “Employee #4”.  Microsoft has been very good to me over the years and I’m grateful for the friendships made and the significant memories.  For the longer story of my move – I’ll be posting soon to…

0

Announcing the new SQL MCM Program Manager

I’ve been waiting for a long running transaction to commit, so to speak, before announcing the big news… I am truly happy to announce that Microsoft Learning has hired a new SQL MCM Program Manager to keep moving forward with our recent program changes and continue to expand the program’s value and impact:   Robert…

0

Measuring impact of “optimize for ad hoc workloads” via CACHESTORE_SQLCP

The cache store “CACHESTORE_SQLCP” represents cached ad-hoc query plans, server-side cursors and prepared statements.   One way to gather memory allocation values for this specific cache store is by using the following query: SELECT single_pages_kb, multi_pages_kb FROM sys.dm_os_memory_clerks WHERE type = ‘CACHESTORE_SQLCP’ You can also see allocations to CACHESTORE_SQLCP via DBCC MEMORYSTATUS (example output below for…

0

ARP Caching and SQL Server Failover Cluster install failures

Now I’m definitely not a networking guy, so even the more basic networking concepts fill me with wonder.  One area I learned about recently with regards to the following scenario was related to Address Resolution Protocol (ARP) caching.    Consider the following scenario… You’re performing a SQL Server Failover Cluster installation and it is failing…

4

Forced Parameterization with Filtered Indexes

Consider the following scenario: You have a database that has PARAMETERIZATION FORCED enabled. You have a table using a filtered index. Here is a demo setup so you can follow along: — Create demo database USE [master] GO CREATE DATABASE [FI_PF_Error_Demo]; GO   — Set new database to forced parameterization ALTER DATABASE [FI_PF_Error_Demo] SET PARAMETERIZATION…

2

Two good Mondays in a row for the SQL MCM program

The last two Mondays have brought us two new highly qualified Microsoft Certified Masters. If you’ve been involved with the SQL Server community for the last few years, it’s likely you’ve already heard their names – Maciej Pilecki and certified today, Simon Sabin. First – a little about Maciej: Maciej Pilecki, Trainer and Consultant, Project…

0

One less “uncertified Master”

News travels pretty fast, so I thought I would get the official word out tonight before this news became too stale. As many already know, three months ago we announced some pretty significant changes to the SQL MCM program. I won’t recap those changes in great detail here, but the bottom line is that we…

1

Last batch of SQL MCM videos now published

Our last planned batch of SQL Server 2008 MCM Readiness Videos are now published – covering Partitioning, Snapshot Isolation, EXECUTE AS, SQL Injection, Replication, Partial Database Availability, Online Piecemeal Restore, optimizing procedural code, a demo of multi-server management, indexing strategies, index analysis, designing an availability strategy, Failover Cluster setup & troubleshooting and consolidation. This is…

6

Second batch of SQL MCM Readiness Videos now Released

We just added another 23 videos on Technet – making it a total of 56 videos available as of today. The new videos cover storage core concepts & guidelines, DAS vs SAN architecture, storage testing and monitoring, index internals, the clustered index debate, statistics, locking, restore internals, Waits and Queues, a clustering introduction, SQLOS concepts,…

10

How do you know if you’re ready for SQL MCM?

“Know what you know. Know what you don’t know. Don’t ever confuse the two.” Per Farny, founder of the original Microsoft Certified Master and Architect program How do you know if you are ready to take the Microsoft Certified Master SQL Server 2008 exams? This is a common question and a perfectly valid one, especially…

2