Infrastructure at your Service

Microsoft Archives - Page 3 of 18 - Blog dbi services

Stéphane Haby

SQL Server 2016: New SQL PowerShell CMDLETs for ErrorLog

By | Database Administration & Monitoring | No Comments

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 present you the 2 new CMDLETs for the Error Logs: Get-SqlErrorLog: Retrieves the SQL Server Logs. Set-SqlErrorLog: Sets or resets the maximum number of error log files before recycling. My first step is to search all commands with “Sql”: Get-Command | Select Name |Where-Object {$_.Name…

 
Read More
Stéphane Haby

Set the SQL Native Client Default Port with PowerShell

By | Database Administration & Monitoring | No Comments

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 the SQL Native Client 11.0 Configuration (32bit) – as seen in the SQL Configuration Manager?” This is a very good question and I decide to write this blog as an answer to this question. The first step is always the same, initialization of my object: [reflection.assembly]::LoadWithPartialName(“Microsoft.SqlServer.SqlWmiManagement”) |…

 
Read More
Stéphane Haby

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

By | Database Administration & Monitoring, Development & Performance, Technology Survey | No Comments

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 Store and how it’s working. Simple SELECT Query To begin, I execute a simple SELECT on a table with 3 different methods: SELECT * FROM QS_test; exec sp_executesql N’SELECT * FROM QS_test’ EXEC sp_GetQS_test; The “sp_GetQS_test” is a stored procedure with the select statement. I created a little…

 
Read More
Stéphane Haby

Trace Flag 4199 or not in SQL Server 2016?

By | Technology Survey | 2 Comments

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 enables all query optimizer fixes. A lot of DBAs have enabled this Trace Flag globally during the build of a new server. If you want to take advantage of an enhancement or a fix, the T4199 becomes a necessity……

 
Read More
Stéphane Haby

SQL Server 2016: RTM first installation

By | Database Administration & Monitoring | No Comments

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 directly in the Database Engine Configuration. In the installation wizard, the number of files is automatically based on the number of logical processors but limited to 8 max. You can also notice that all secondary’s…

 
Read More
Stéphane Haby

SQL Server 2005 decommissioning failed!

By | Database management | No Comments

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 time, I had to uninstall an old SQL Server 2005 clustered instance in a 64 bits architecture on Windows Server 2008R2. In fact, this clustered environment contains many other instances (either SQL Server 2005 or 2008 R2). But during the uninstallation, an error happened…. First,…

 
Read More
Stéphane Haby

SQL Server 2016: new tools management strategy

By | Business Intelligence, Database Administration & Monitoring, Database management | No Comments

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 for SQL Server on a single web page: https://msdn.microsoft.com/en-us/library/mt238365.aspx As DBA, this page is absolutely to be marked in your browser. The two major tools, SQL Server Management Studio (SSMS) and SQL Server Data Tool (SSDT), are…

 
Read More
Stéphane Haby

SQL Server 2016: Extended Events are more powerful as Trace Flag for Backups and Restores

By | Database Administration & Monitoring | No Comments

Before SQL Server 2016, we use Trace Flag to display information about backup and restore operations like the 3004, 3014, 3213 or 3604. Here a link to the MSDN with a great SQL Server trace flag list SQL Server 2016 provides 2 new Extended Events: backup_restore_progress_trace database_backup_restore_throughput backup_restore_progress_trace will give detailed information during the backup process and restore operation database_backup_restore_throughput will provide different throughput about backup/restore process Create an Extended Event for Backup & Restore…

 
Read More
Stéphane Haby

SQL Server: Now Cumulative Updates (CU) need to be install!

By | Database Administration & Monitoring | No Comments

 Since this year, Microsoft recommends to install Cumulative Updates (CU) like Service Packs (SP) In the past, Microsoft always recommended to apply the Service Packs and security fixes for SQL Server. Cumulative Updates were applied only if you had a specific problem in order to resolve it. Now, we need to follow a new rule: “ Microsoft recommends ongoing, proactive installation of SQL Server CUs as they become available: SQL Server CUs are certified to…

 
Read More
Stéphane Haby

Attunity Replicate: Replicate numeric data types from Oracle to SQL Server is easy

By | Application integration & Middleware | No Comments

After the good article “A short glance at Attunity replicate” from Franck Pachot, I will continue to explain our test on Attunity Replicate with datatype and how this tool do the mapping between Oracle and SQL Server for numeric datatypes. Introduction The first step is to find the mapping between Oracle and SQL Server. I summarize this mapping in this table: As you known (or not), in SQL Server, you have a replication with Oracle…

 
Read More