It's over. There's no more MCM program or certification from Microsoft. The last MCM test was given last year and no upgrades are planned for SQL Server 2012 or SQL Server 2014. That's a little sad, though there are quite a few of our SQL Server professionals that can still proudly wear the MCM title for the rest of their careers.
The MCM tests were designed differently than all the other MCP type tests, requiring more thought and deduction, as well as practical skills. The lab in particular was daunting to many of the MCMs, most of whom would tell you about the difficulties in getting through the scenarios in the limited time alloted. All of the people I've talked to found the challenge refreshing and also informative, enabling them to learn a few things about their knowledge, even from the problems they didn't complete.
Since that chapter in Microsoft Learning is complete, and the tasks likely out of date, I'd ask that Microsoft Learning release the questions and scenarios to the world as an open source project. Unlike the other certifications and exams, these questions aren't going to be re-used anytime soon and the knowledge could help many people learn to build better solutions.
This would be a great move, allowing many DBAs to challenge themselves with the questions and scenarios in practice labs. The types of scenarios could be used in interviews for new employees, either as they are written or modified for a particular environment. Professionals using the SQL Server platform would get an idea of not only the broad level of knowledge that MCMs have, but they'd also have a way to test themselves and direct their own learning to become better rounded SQL Server developers and administrators.
I doubt it would happen, but I'd think Microsoft could help the community, generate some goodwill, and help improve the overall quality of people working on their platform.
Get your SQL Server database under version control now!
Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…
Ricky Leeks on Learning .NET Memory Management
Pick up all six free articles in one free download. Find out what Ricky has to teach you about garbage collection, memory management gotchas, and more. Download the article pack free.
16 essential SQL Server tools
In one installer, the award-winning SQL Toolbelt contains everything you need to work with SQL Server. "The SQL Toolbelt provides tools that database developers as well as DBAs should not live without." William Van Orden. Download a free trial.
Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks". More »
Optimize your queries—and obtain simple and elegant solutions to a variety of problems—using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you’ll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you’re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks. Get your copy from Amazon today.
Yesterday's Question of the Day
(by Steve Jones):
I have created a certificate for the login/user Sales1 as follows:
CREATE CERTIFICATE Sales1Cert
AUTHORIZATION Sales1 WITH SUBJECT = 'Salesperson1 certificate'
I have also created a symmetric key that has been used to encrypt some sales data as follows:
CREATE SYMMETRIC KEY SalesSymKey
WITH ALGORITHM = AES_128
ENCRYPTION BY CERTIFICATE Sales1Cert
I now want to give Sales2 access to decrypt the data encrypted by the SalesSymKey symmetric key, but I don't want them to have access to other keys that are encrypted with the certificate Sales1Cert. What two things should I do?
Run "CREATE CERTIFICATE Sales2Cert AUTHORIZATION Sales2 WITH SUBJECT = 'Salesperson2 certificate'"
Run "ALTER SYMMETRIC KEY SalesSymKey ADD ENCRYPTION BY CERTIFICATE Sales2Cert"
A single certificate can be used to encrypt and secure multiple other keys. A single key can also be secured by multiple certificates. Therefore the solution is to add a certificate for user Sales2 with
CREATE CERTIFICATE Sales2Cert
AUTHORIZATION Sales2 WITH SUBJECT = 'Salesperson2 certificate'
Then add the encryption to the Symmetric key using this certificate with:
ALTER SYMMETRIC KEY SalesSymKey
ADD ENCRYPTION BY CERTIFICATE Sales2Cert
This way both users can use their own certificate to access data secured by SalesSymKey, but they would not be able to access data secured by other keys.
Run the script from query analyser on the source server. Remember to change query results to text and also remove include column headers option from query options. If filepaths are different on source and destination just do a find and replace on file path. Copy the output of query and run it on destination and you are done
Optimization not enough
In my execution plan i can see some warning like:
1. "Type conversion in expression (CONVERT_IMPLICIT(varchar(40),[PAIntel].[ActivationDateTime],0)) may affect "CardinalityEstimate" in query...
Security for Linked report
- We have a master report "AP Aging" under "Europe" folder.
In Security "GAE-G-AccountingReportServicesW1" AD group is added.
"GAE-G-AccountingReportServicesW1" includes users Olga, Christian,...
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.