Home » Applied SQL »sql server »sqlserverpedia-syndication »SSC » Currently Reading:

SQL Server 2012 CU2 – Have a little fun (#AppliedSQL)

SQL Server 2012 Cumulative Update (CU) 2 is out! If you’re like Me-from-10-years-ago, you couldn’t care less!

But there are actually some good reasons for paying attention to new CUs.  For example: it’s one good way to get to know the new version of SQL Server: play with the bugs before you install the updates! (You DO have the new version of 2012 on a test box somewhere, right? If no, download a trial version from MS).

A lot of these bugs are pretty out there, though…how do we play around with “Access violation when you run a DAX or MDX query against a tabular model database through a BI semantic model connection in SQL Server 2012 “?  Yeah, that sounds easy to set up. 

Ooh, here’s a simple one! “Cannot show requested dialog” error message when you try to view properties of a database in a SQL Server 2012 instance.  Perfect.  So let’s just do what it says!  

  1. Create a new SQL user, “Test”.
  2. Create a new database, “TestDB”.
  3. Assign the user Test as the TestDB owner.
  4. Now, log into SSMS as Test, right click TestDB, and try to view properties.

Voila! You get the error! 

See the error! See the fix!

Then apply CU2 and try it again.

No, seriously…go do all this yourself. If you’re not in the habit of playing around with new versions of SQL, of the updates, of reproducing issues, this is the ideal first step.  Get in there and DO it, man.  Start to pay attention to and get passionate about the product you work with.

Happy days,
Jen McCown

Currently there are "3 comments" on this Article:

  1. cos says:

    nice post.
    Is there a way to subscribe to be notified about future CUs? I find that even after applying CU 2, I still have a bunch of issues w/ SSAS.

    thx much,

  2. cos says:

    thx, Jen!

Comment on this Article:

Minion Reindex by MidnightDBA is here!


Excellent Index Maintenance

Download Minion Reindex, log feature requests, read documentation, and sign up for the newsletter at MidnightSQL.com/Minion!

Monday, Oct 27 12:00PM CDT: Attend the Minion Reindex Intro Webinar.

MidnightSQL Consulting

Need help? Got an emergency? Write us at Support@MidnightDBA.com!

We can schedule time to help with your backup/restore issues, high availability and disaster recovery setup, performance problems, and a great deal more. Very often, we're even available on the moment for downtime issues and emergencies.

For more information about MidnightSQL consulting, email us or check out www.MidnightSQL.com. Happy days!

Where are We?

November 3-7: PASS Summit, Seattle, WA

PASS Summit: Jen is presenting How to Interview a DBA: A Panel Debate on Thursday 11/6 1:30pm, room 401 (along with Adam Machanic, Sean McCown, Bob Pusateri, and Michelle Ufford).

PASS Summit: Sean is presenting Performance Tuning Your Backups on Wednesday 11/5 3:00pm, room 602-604.

December 11: Presenting "Powershell Cmdlets.." at Alaska SQL Server User Group

January 30: "Become an Enterprise DBA" precon at Austin SQL Saturday

Blog Posts by Category


How to Eat Pop-tarts
Watch DBAs@Midnight live on Fridays,m 11pm Central time

The best database career advice you’ve never heard!


The DBA Roadmap Seminar is 7 MP3 tracks (over 5 hours!) of insider guidance on your database career. We'll teach you how and what to study as a DBA, weigh in on controversial resume debates, teach you to recognize a worthy recruiter, and discuss the new professionalism of interviews. Also some bonus materials, PDF companion guides, and really spiffy intro music!

Once your $99 PayPal payment is submitted, you'll get the download link in e-mail! (Download is a 370Mb ZIP file.)

Become a DBA. Become a BETTER DBA. Use the Roadmap.

Visit www.DBARoadmap.com for info, forums, and more!

Add to Cart View Cart

Cunningham’s Law

"The best way to get the right answer on the Internet is not to ask a question, it's to post the wrong answer."
Relevant: http://xkcd.com/386/