SQL Server 2012 New Stuff Jump Off Point March 31, 2013
New stuff link
Review of new stuff for SQL Server 2012.
XEvents and Distributed Replay.
SQL Server 2012 Encryption March 19, 2013
Overview of how to help secure the SQL Server platform, and how to work with users and securable objects.
Information about how to implement cryptographic functions.
Information about how to use a password to encrypt data.
Information about how to use a symmetric key to encrypt data.
Information about how to use an asymmetric key to encrypt data.
Information about how to use a certificate to encrypt data.
[ ENCRYPTION ]
[ RECOMPILE ]
[ EXECUTE AS Clause ]
SQL Server 2012 BIS Samples October 6, 2012
Software Required and Download Locations
- SharePoint 2010, Enterprise or Evaluation Edition
- Download the Evaluation Edition: http://technet.microsoft.com/en-us/evalcenter/ee388573.aspx
- Get an evaluation product key: http://technet.microsoft.com/en-us/evalcenter/ee391660
- Download the appropriate edition of SharePoint 2010 Service Pack 1: http://support.microsoft.com/kb/2510766
- SQL Server 2012, Enterprise Edition, Developer Edition, Standard Edition, or Evaluation Edition
- Download the Evaluation Edition: http://www.microsoft.com/en-us/download/details.aspx?id=29066
- Microsoft® SQL Server® 2012 Reporting Services Add-in for Microsoft® SharePoint® Technologies 2010: http://www.microsoft.com/en-us/download/details.aspx?id=29068&WT.mc_id=rss_alldownloads_all
- Office 2010, Evaluation Edition
- Download a 60-day free trial version: http://office.microsoft.com/en-us/try
- Visual Studio 2010 Tool for Office Runtime: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=20479
- Microsoft .NET Framework 4
- Download using the standalone Installer: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=17718
- PowerPivot for Excel: http://www.microsoft.com/en-us/download/details.aspx?id=29074
- Power View and PowerPivot HelloWorldPicnic Samples for SQL Server 2012: http://www.microsoft.com/en-us/download/details.aspx?id=26718
- Image Files for HelloWorldPicnic Sample Model in PowerPivot and Power View: http://www.microsoft.com/en-us/download/details.aspx?id=26719
- AdventureWorks samples: http://msftdbprodsamples.codeplex.com/releases/view/55330#
- AdventureWorksDW2012 Data File: http://msftdbprodsamples.codeplex.com/releases/view/55330#DownloadId=165405
- AdventureWorks Tabular Model SQL Server 2012: http://msftdbprodsamples.codeplex.com/releases/view/55330#DownloadId=353143
- AdventureWorks Internet Sales Tabular Model SQL Server 2012: http://msftdbprodsamples.codeplex.com/releases/view/55330#DownloadId=353144
Sample Files for Validation
Summary:This white paper provides practical guidance to help BI professionals and decision makers decide whether SQL Server 2012 Analysis Services tabular or multidimensional modeling provides the best fit for your next BI solution.
The examples in this white paper are based on the AdventureWorksDW2012 data file. The AdventureWorks Internet Sales Tabular Model SQL Server 2012 sample project is also used for demonstration purposes. These samples are available for download at http://msftdbprodsamples.codeplex.com/releases/view/55330.
By default, data in tabular models is processed, compressed using the xVelocity in-memory analytics engine (VertiPaq), and stored in an Analysis Services database. The xVelocity engine is an in-memory columnar storage engine that is optimized for high performance analysis and exploration of data. Tabular models are queried using Multidimensional Expressions (MDX) or Data Analysis Expressions (DAX). The xVelocity engine provides fast query times for aggregation queries even on large fact tables.
There are a few very important design considerations if you are planning to use DirectQuery:
• MDX queries are not supported for a model in DirectQuery mode. This means
you cannot use Microsoft Excel or Microsoft PerformancePoint as reporting
clients on top of a DirectQuery-only model, because these clients all issue
SQL Server 2012 and SSRS June 14, 2012
SQL Server 2012 Reporting Services Tips, Tricks, and Troubleshooting
Went to test the Data Source link and got the error Cannot convert claims identity to windows token. Started digging around on the web and found numerous articles and blog posts about making sure the Claims to Windows Token Service (C2WTS) is set up and running in SharePoint. We had set this up for performance point in our production environment but not in our test environment. Got out the notes and set up a new service account in test to run the service. Made sure it was given the correct rights on the SSRS server of act like a part of the OS and able to impersonate another identity. Set up the delegation to the SQL server we were trying to hit and started the service. Still got the error Cannot convert claims identity to windows token. Went through this video and tried to verify we had everything set up correctly. Got Microsoft Support on the case and they started looking at the issues as well. I finally found this blog and started focusing on the bz71 error which I found. Tying the bz71 error to the Process ID I noticed that the User Account running the process was the SSRS Service Account. I thought the process of converting a claims identity to a windows token would be handled by the user running the C2WTS and the account associated with that service. It appeared that the process doing that conversion or at least the process throwing the error is actually the service account running the SSRS Service Application. I then set the permissions for the SSRS Service account in the local policy on the SSRS Server to be the same as the C2WTS Account. I restarted the Service Applications via central admin and things started working.