Welcome to Sign in | Join | Help

ROSQL invites you to a special meeting dedicated to SQL Server, on 5th of March 2015, starting at 17:30, at Microsoft Romania.

For registration please use the following URL: http://1drv.ms/17auGq1


17:30- 18:00 Microsoft's Data Platform lately - Cristian Lefter, SQL Server MVP, sqlserver.ro

18:10 - 19:30 End-to-End SQL Server Master Data Services - Peter Myers, SQL Server MVP, Director - Training and Mentoring at BizData

About our guest and his session

Peter Myers has worked with Microsoft database and development products since 1997.
Today, he specializes in all Microsoft BI products and provides mentoring, technical training, and training course content authoring for SQL Server, Office, and SharePoint.
Peter has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with solid experience backed by current MCSE and MCT certifications. He lives in Melbourne, Australia and has been a SQL Server MVP since 2007.
End-to-End SQL Server Master Data Services
This presentation describes how SQL Server Master Data Services can be used to implement Master Data Management (MDM). It introduces the discipline of MDM and maps common processes to the feature set of Master Data Services.
Topics include defining models, entities, attributes and hierarchies, to store and manage master data. Additionally, administrative tasks including business rules to validate data, the import and export of master data, model versioning, and permission management will be described. The two Microsoft user interfaces (the Master Data Manager web application, and the Excel add-in) will be covered, in addition to T-SQL scripting opportunities to automate master data processes.
This session will be of interest to data stewards, ETL developers and ETL administrators to appreciate what SQL Server 2012 (or 2014) Master Data Services can achieve.

If you run an online community you will probably encounter this challenge: how to filter regular users from spammers? An asnwer can be found here: http://www.stopforumspam.com/search You can search your new users here and if and also you can report spam data. I find it very useful and very accurate.
Starting with SQL Server 2005, the sys.fn_my_permissions function can be used.
It has a quite simple syntax:  fn_my_permissions ( securable , 'securable_class')

To answer the question, the code would be:
USE MyDatabase;
SELECT * FROM fn_my_permissions ('myStoredProcedure', 'OBJECT');

With Microsoft Certification recently redesigned, the usual certification path for an SQL Server professional would be the following: 
  1. MCSA (Microsoft Certified Solutions Associate) SQL Server 2008
    It requires two exams: Exam 70-432 - Microsoft SQL Server 2008, Implementation and Maintenance + Exam 70-448 - Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

  2. MCSA (Microsoft Certified Solutions Associate) SQL Server 2012
    It requires three exams: Exam 70-461 - Querying Microsoft SQL Server 2012 + Exam 70-462 - Administering Microsoft SQL Server 2012 Databases + Exam 70-463 - Implementing a Data Warehouse with Microsoft SQL Server 2012
    There is also an upgrade path for holders of MCTS - SQL Server 2008 certification: Exam 70-457 - Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 + Exam 70-458 - Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2

  3. MCSE (Microsoft Certified Solutions Expert) - Data Platform - SQL Server 2012
    It requires MCSA (Microsoft Certified Solutions Associate) SQL Server 2012 and two additional exams:
    Exam 70-464 - Developing Microsoft SQL Server 2012 Databases
    + Exam 70-465 - Designing Database Solutions for Microsoft SQL Server 2012
    There is an upgrade path from MCITP - Database Administrator 2008 or MCITP - Database Developer 2008: Exam 70-457 - Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 + Exam 70-458 - Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 + Exam 70-459 - Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform

  4. MCSE (Microsoft Certified Solutions Expert) - Business Intelligence - SQL Server 2012
    It requires MCSA (Microsoft Certified Solutions Associate) SQL Server 2012 and two additional exams:
    Exam 70-466 - Implementing Data Models and Reports with Microsoft SQL Server 2012
    + Exam 70-467 - Designing Business Intelligence Solutions with Microsoft SQL Server 2012
    There is an upgrade path from MCITP - Business Intelligence Developer 2008: Exam 70-457 - Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 + Exam 70-458 - Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 + Exam 70-460 - Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence

So, what happens after MCTS, MCITP, MCSA and MSCE? On the SQL Server 2008 track there is the advanced certification Microsoft Certified Master: Microsoft SQL Server 2008 requiring two exams:

To prepare for the MCM certification you can use free documentation resources provided by Microsoft or you can enroll in the SQL Server 2008 Microsoft Certified Master (MCM) Accelerated Exam Preparation Program (priced at US$2,900).

Once you've obtained your MCM you can go further by applying to the Microsoft Certified Architect Program for SQL Server 2008. The application fee is US$125 and if you are accepted into the program, the fee to take the MCA Board Exam is US$7,500.

Similar to the MCM certification - there is the SQL Server Analysis Services (SSAS) Maestro program, dedicated as the names says to the Analysis Services 2008 R2. The program's training is priced at €7000 + VAT.

Last but not least - for SQL Server 2012 - Microsoft re-branded the MCM certification as Microsoft Certified Solutions Master (MCSM). On the Microsoft Learning site there is a note "The first two MCSM certifications will be for SQL Server 2012 tracks."

Good luck!

This article: http://bit.ly/sql2012ro
Workshop Dates:
2,3 May 2012
31 May 2012, 1 June 2012

SQL Server 2012 Early Adoption Cook Book bit.ly/sql2012cookbook
Product Documentation for Microsoft SQL Server 2012 (Books Online)
Microsoft SQL Server Data Tools
SQL Server Virtual Labs
BI Image X: SQL 2012 RC0 (multiple files)
Technet SQL Server 2012: The New World of Data
MVA - Cloud on your terms with Microsoft SQL server 2012: Scale on demand
Data Quality Services "How Do I?" Videos
Tutorials for SQL Server 2012
Microsoft® SQL Server® 2012 Best Practices Analyzer
TechNet Edge SQL Server 2012 Videos
SQL Server AlwaysOn Solutions Guide

Comparison of SQL Server Compact, SQL Server Express 2012 and LocalDB
SQL Express v LocalDB v SQL Compact Edition

Vulnerability in the Microsoft XML Editor Could Allow Information Disclosure

It's been a while since SQL Server security needed a patch and today it just happened. A vulnerability in Microsoft XML Editor allows an attacker to obtain sensitive information by using a custom Web Service Discovery (.disco) file. Read more about this vulnerability here

Do you want to test Windows Azure and the credit card condition stops you?

Not anymore!

You can test Windows Azure without having a credit card using a new promotion:

There is a small catch - you need a code to use this promotion and the code can be obtained simply by writing an email or message to me.
Did you know?
  • A ton of recycled paper is equivalent to recycling a newspaper and two white sheets daily for one year.
  • A ton of recycled paper saves 20 trees, 3.800 kWh, 32.000L of water and prevents 27 kg of pollutants from being released into atmosphere.

So why we recycle paper?

  • To reduce deforestation, and this way there will be fewer: landslides, climate change, floods, habitat and biodiversity destruction and destruction of recreation areas;
  • To reduce the imports of wood
  • To reduce water consumption by up to 60%;
  • To reduce energy consumption by up to 40%;
  • To reduce air pollution by up to 70%;
  • To diminish pollution by up to 35%;
  • To decreases the amount of garbage deposited in landfills or incinerators.

Personal story: I lost 60kg of extra weight today :) - I mean by that recycling 60 kg of paper. ( For Bucharest you can use "Depozitul de maculatura".)

The SQL Server 2008 R2 RTM is here and with it a lot of new resources.
  1. Test Drive
  2. Webcasts, Videos and events
  3. Blog posts
  4. Books
  5. Documentation
  6. Whitepapers
  7. E-Learning Clinics (thanks to Greg Low)
  8. Local Resources

At least the following downloads are available:
Microsoft SQL Server 2008 R2 RTM - Express
Microsoft SQL Server2008 R2 RTM - Express with Advanced Services
Microsoft SQL Server 2008 R2 RTM - Express with Management Tools
Microsoft SQL Server 2008 R2 RTM - Management Studio Express

In case you didn't know the SQL Server 2008 R2 Express Edition - expands the size limit of a user database to 10GB.

Also looking at the downloads related to SQL Server 2008 R2 it seems that also a trial is available for download.
Probably this is not the right question. What is certain is that twitter has become a valuable source of information. I had to add new words to my language, words like "to tweet" "tweetup" "twitterview". You have no idea what tweetup or twitterview means? Tweetup or tweet-up is defined by Macmillan Dictionary as [quote] a meeting of two or more people who know each other through the Twitter short messaging service [/quote]. Impressions from a SQL Server 2008 R2 tweetup can be found on SQL Server Team's FaceBook page and on The blog from the dkRanch - The Tweetup.
As for twitterview - I will assist at the first one (for me) in a few hours:
Donald Farmer ‘Twitterview’ with SQL Server Magazine
Attention SQL Server enthusiasts: mark your calendar for April 14, 9:30 AM PDT. SQL Server Magazine is hosting a ‘Twitterview’ with Donald Farmer, Principal Program Manager for SQL Server. This is your opportunity to ask Donald your burning BI questions. This is a continuation of SQL Server Magazine’s article by Shelia Molnar about Microsoft’s BI Strategy.
Not participated in a Twitterview before? It’s easy! Donald will answer your questions via the SQL Server Magazine Twitter account (@SQLServerMag) from 9:30 AM to 10:00 AM PDT.

If you ever need help with SQL Server use the hashtag (a hash tag is simply a tag with the hash "#" symbol as prefix) #sqlhelp.

I will close by mentioning just a few of the channels I follow:
  • @MS_SQL_Server - The official SQL Server twitter
  • @billramo - Bill Ramos SQL Server expert on manageability and performance troubleshooting and fan of agile and UI development
  • @SQLServerMag - SQL Server Magazine is dedicated to helping DBAs, database developers, and BI professionals get the most out of SQL Server.
  • @SSRS - Blogs Posts and Connecting with the SQL Server Reporting Services Team
  • @buckwoody - Buck Woody - Database Guy
  • @mssqltips - MSSQLTips - Your source for daily SQL Server tips
  • @donalddotfarmer - Donald Farmer - Working @ Microsoft in Business Intelligence. Personal interests: philosophy, art, and indulgences starting with food and wine and ending who knows where?
  • @sqlpass - Professional Association for SQL Server. Connect, Share, Learn.
Come to the twitterview with Donald Farmer Yes

Published Update
Twitterview: Microsoft’s Donald Farmer on SQL Server 2008 R2 (the transcript)
SQL Server 2008 R2 Tweetup Video Montage

With SQL Server 2008 R2 RTM knocking at the door a list with R2 resources may come in handy.
So here you are:
  1. SQL Server 2008 R2 Update for Developers Training Kit (April 2010 Update)
    The SQL Server 2008 R2 Update for Developers Training Kit is ideal for developers who want to understand how to take advantage of the key improvements introduced in SQL Server 2008 and SQL Server 2008 R2 in their applications, as well as for developers who are new to SQL Server.
    It contains presentations (22), demos (29), hands-on labs (18), videos (35) as well as an utility to help configuring your computer for running the demos.
  2. E-Learning Clinics (thanks to Greg Low)
  3. Webcasts
  4. Whitepapers
  5. GITCA Fireside Chats
  6. PASS - The Professional Association for SQL Server
  7. Articles and blogs
  9. Local Resources
  10. Other resources
  11. Free ebook: Introducing Microsoft SQL Server 2008 R2
According to Data Platform Insider blog, May 2010 will bring SQL Server 2008 R2 both on Microsoft's products price list and also to the customers.

More details here: SQL Server 2008 R2 gets an official date
Microsoft SDL (Security Development Lifecycle) team released recently two guidance papers:
The SQL Injection subject is not at all new. As an example 9 years passed since NGSSoftware published their SQL Server Injection Whitepapers.
What brings new the SDL Quick Security Reference on SQL Injection? Among other things it describes the role in addressing this issue for the business decision maker, the architect, the developer, and tester.
The following graphic based on data published by breach.com shows the importance of SQL Injection as a threat:

It is supposed to be feature complete. What will differ in the RTM version depends on your feedback!
Download the CTP here: Microsoft SQL Server 2008 R2 November CTP