Stéphane Haby

Neue Datenbank Konsole Befehle (DBCC) CLONEDATABASE

Sie haben es vielleicht noch nicht gesehen, aber mit den Service Pack 2 von SQL Server 2014 gibt es einen neuen DBCC Befehl: CLONEDATABASE. „DBCC CLONEDATABASE sollte Kopien eines Schemas und den Statistiken einer Produktionsdatenbank erstellen, um bei Leistungsproblemen Abfragen(…)

SQL Server 2016: New SQL PowerShell CMDLETs for ErrorLog

With the latest release of SQL Server Management Studio(SSMS) 2016 (13.0.15500.91), downloadable here, was introduced new CMDLETs for Always Encrypted, SQL Agent and the  ErrorLog. In this article, I will(…)

Set the SQL Native Client Default Port with PowerShell

I written an article about “SQL Server 2012: Configuring your TCP Port via PowerShell” and I received a question from PaulJ: “How do you set the port for(…)

SQL Server 2016 – Query Store: retrieve query that doesn’t appear!

For our event SQL Server 2016 in September, I am studying the new functionality Query Store. My colleague David Barbarin have written few months ago about Query(…)

Trace Flag 4199 or not in SQL Server 2016?

Some Trace Flag like T1117 and T1118 are no more needed as you can read on David’s blog. But that’s not all, you have also the T4199… What’ does the Trace Flag T4199? This Trace Flag(…)

SQL Server 2016: RTM first installation

I was very surprise with this new version of SQL Server and his installation. The first point is that we don’t need any more to install the framework .Net 3.51 manually… The second main point is the configuration of TempDB(…)

Attunity Replicate: additional column on the target

In December 2015, my colleague Vincent did a test with additional column with Oracle GoldenGate 12.2. Hervé & Vincent asked me(…)

Attunity Replicate: Backup & Restore a task

By a customer, we faced the question: how to backup and restore a replication task in Attunity Replicate? We don’t see any button or menu into the administration web console and in the Guide line, we haven’t really a(…)

SQL Server 2005 decommissioning failed!

The support for SQL Server 2005 is no more available, so we are migrating all the latest databases running under SQL Server 2005 to SQL server 2012 or higher! Last(…)

SQL Server 2016: new tools management strategy

A lot of customer’s feedbacks are about difficulties to find easily SQL Server tools. Now, it is easier… 😉 A unified web page for SQL Server Tools The first good news is that Microsoft unified and gathered these tools(…)