Infrastructure at your Service

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

Stéphane Haby

SQL Server 2014: the next version

By | Technology Survey | No Comments

At TechEd North America 2013, Microsoft introduced a lot of new versions: Windows Server 2012 R2, System Center 2012 R2, Windows 8.1, Visual Studio 2013 and, and, and… SQL Server 2014, of course!8-O You think I’m crazy or it’s a joke!;-) No, No, it’s for real. You can see the first page about SQL Server 2014 on Microsoft site here: You can register to be part of the first testers having an evaluation version. An…

 
Read More
Stéphane Haby

SQL Server 2012: CompoundCurve – a new geospatial feature

By | Database management | No Comments

There are three new geospatial features in Microsoft SQL Server 2012: CircularString, CurvePolygon, and CompoundCurve. For the fun and as an example, I will test CompoundCurve, a set of circular strings that may be combined with line strings, and store a “dbi” character set in a table.:-D What is CompoundCurve? It’s a set of circular strings, or circular strings combined with line strings, that form a desired curved shape. The end point of each element…

 
Read More
Stéphane Savorgnano

SQL Server 2012: Create & replay a trace with Distributed Replay

By | Database management | One Comment

My last blog was about installing and configuring Microsoft SQL Server 2012 Distributed Replay. This time, I will show you how you can create a trace and replay it with Distributed Replay Clients on a specific SQL Server target. This is my Distributed Replay configuration:   Creation of the trace I will use the two Distributed Replay clients to generate a workload against the target server with two PowerShell Windows which will execute diverse SQL…

 
Read More
Stéphane Savorgnano

SQL Server 2012: Installing and configuring Distributed Replay

By | Database management | No Comments

Distributed Replay is a new fonctionality of Microsoft SQL Server 2012. It helps you assess the impact of future upgrades (SQL Server, hardware, OS) or SQL Server tunings by replaying a trace captured from a productive SQL Server environment to a new SQL Server test environment. This new functionality is similar to SQL Server Profiler, but with more possibilities: e. g. replaying the trace from multiple clients (up to sixteen), use a stress or  synchronization…

 
Read More
Stéphane Haby

SQL Server 2012: new perfmon counters

By | Development & Performance | One Comment

I have read some blog postings concerning the new perfmon counters, but I have not seen really extensive overviews yet. In this post, I would like to present not only what is new, but also what has changed (or not) and how to find it. The first step is to select all objects in SQL2008R2 and SQL2012 from the view sys.dm_os_performance_counters. Remarks: All object or counter definitions from this post come from msdn. Objects comparison The…

 
Read More
Stéphane Haby

SQL Server 2012: Configuring your TCP Port via Powershell

By | Database management | 10 Comments

Changing the default TCP port 1433 for SQL Server is an important step for securing your SQL Server. I have written a script in PowerShell to modify the port number that helps me perform this task. This blog posting will show you how to do it. Please note that the code in this article is for SQL Server 2012 on Windows Server 2012. Initialization Run SQLPS to launch the SQL PowerShell in a command prompt. First…

 
Read More
Stéphane Savorgnano

SQL Server 2012 SP1: Second Cumulative Update available (CU2)

By | Technology Survey | No Comments

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 for SSRS If you need more information and/or details on these hotfixes, click here. Historic of…

 
Read More
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