Infrastructure at your Service

SQL Server Archives - Page 20 of 20 - Blog dbi services

Stéphane Savorgnano

SQL Server View problem in LightSwitch 2012

By | Application integration & Middleware | One Comment

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 (apparently it’s mandatory in LightSwitch) and that a key has been inferred… When I check…

 
Read More
Stéphane Haby

SQL Server 2012: First Hotfix for Service Pack 1 available

By | Database Administration & Monitoring | No Comments

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 not finish. Problem Windows Installer tries to repair the installation and then blocks the next…

 
Read More
Stéphane Haby

SQL Server 2012: new permissions

By | Technology Survey | No Comments

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 overview, I prefer use this query ordering by the class description: SELECT class_desc,count(*) as Permission_Number…

 
Read More
Stéphane Savorgnano

Risk and Health Assessment Program for Microsoft SQL Server

By | Database management | One Comment

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. The SQLRAP program will collect data from the SQL Servers, perform a very thorough analysis,…

 
Read More
Stéphane Haby

Office 2013 and SQL Server 2012: an integrated, powerful BI solution

By | Business Intelligence | No Comments

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. More information here. Power View is a feature of SQL Server 2012 Reporting Services Add-in…

 
Read More
Stéphane Savorgnano

Overview of Microsoft Visual LightSwitch

By | Application integration & Middleware | No Comments

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 Visual Basic and C#. The following will change our habits. In fact instead of creating…

 
Read More