A couple of days ago, Microsoft published the second Cumulative Update (CU2) for Microsoft SQL Server 2012 SP1. If this CU covers an issue you are experiencing, you should install it quickly. Otherwise, it is not mandatory. Which issues are covered by this CU2? This CU2 contains 51 Hotfixes: 35 for the Engine 6 for SSAS 3 for SSIS 7…
I recently faced a problem in Visual Studio LightSwitch 2012 with SQL Server views. I attached an external datasource to my project and when I tried to import my view (which is very simple) I experienced some issues. Here is my View in SQL Server 2012: During the import process a warning says my view doesn’t have any primary key…
This month, Microsoft has released the first hotfix for SQL Server Service Pack 1. Analysis This Hotfix concerns the installation of SQL Server components and Analysis Services. If you have installed the RTM version with Analysis Service and successfully installed Service Pack 1, you may experience problems in the next installation process for other component: The installation freezes and does…
For this end of the year, I decided to present you the new permissions on SQL Server 2012. How to have a list of all permissions ? It’s very simple with this query: SELECT * FROM sys.fn_builtin_permissions(”) SQL 2008 R2 SQL 2012 With this comparison, you can see that there are 19 new permissions in SQL Server 2012. To have a great…
A couple of days ago (20 November 2012), Microsoft rolled out the first cumulative update (CU1) for SQL Server 2012 Service Pack 1 (SP1). It’s just two weeks after the release of the first Service Pack (SP1) we are talking about here. What this first CU for SQL Server 2012 SP1 features: This CU1 contains 44 hotfixes: 33 for the…
I recently had the chance to go through a so called Risk and Health Assessment Program for Microsoft SQL Server (SQLRAP) at one of our clients. The SQLRAP assesses your SQL Server implementations to ensure proper productive use. It is an excellent opportunity to review the best practices and perform a validation of your client environment by a Microsoft SQL Server Engineer.…
I have recently read that PowerPivot and Power View are natively present in Office 2013 and especially in Excel 2013. I found this fun and decided to install the preview of Office 2013!:-D First, what are PowerPivot and Power View? PowerPivot is an add-on to Excel which is used for adding and integrating large amounts of data in Excel workbooks.…
Microsoft Visual Studio LightSwitch is a new application development tool wich allows to create fast and nice web and desktop applications. The development environment is the same as the other .NET development tools and creating a new application with LightSwitch works, at the beginning, exactly like with other .NET application: create a new project and choose your programmation’s language between…
In my life prior to SQL Server, I worked with Visual Studio Team System (VSTS). The “Schema and Data Comparison” feature of SQL Server 2012 Data Tools is a direct descendant of Visual Studio for Databases Professionnals (aka Data Dude) included in VSTS. What is SQL Server Data Tools? These new tools replace BIDS (Business Intelligence Development Studio). But they…
I recently talked to a customer about SnapManager, its recommendation on the number of databases and about a way to prevent the creation of more than 35 databases. The NetApp recommendation is no more than 35 databases on a single volume. The reason is that SQL Server has to use 4-5 worker threads per database in order to manage the…
This week, the third cumulative update was made available on the Microsoft website. What is in this CU for SQL Server 2012? This CU has 36 hotfixes: 25 for the engine 1 for SSAS 4 for SSIS 6 for SSRS To have more information and download it, click here Historic of SQL Server 2012 If you update your SQL Server…
For this last day (
) of the TechEd 2012, I going to present the new certification cycle for dba who wants to be certified for SQL Server 2012. But before, let’s start with a brief introduction on Enterprise Information Management, also called EIM
