Stéphane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.
I’m pleased to announce that Microsoft gives now the opportunity to choose Linux as a new operating system for SQL Server. To try this new version, you can find in the Cloud Azure a new template in the marketplace. In the search bar, tape “SQL Server vnext” and you’ll find the “SQL Server vNext on Red Hat Enterprise Linux 7.2”.…
If you have restricted access to the server and you do not know if your packages are installed on the SQL Server with the R Services, you have the possibility to do it by T-SQL. The R command/function to use is “installed.packages()”. As you can read in the R Documentation for installed.packages(), this function scans the description of each package.…
Now, in the latest version of SQL Server, you have one of the most expected function as well as for developers as for administrators, splitting a string natively in T-SQL: STRING_SPLIT(<character expression>,<separator>) This function has 2 parameters: The character expression with a data type of nvarchar,varchar,nchar or char The separator with a data type of nvarchar(1), varchar(1), nchar(1) or char(1)…
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 zu untersuchen.“ MSDN Quelle finden wir hier. Dieser Befehl kann nur Benutzedatenbanken klonen. Wie Sie sehen, für die Systemdatenbanken ist…
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…
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…
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…
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…
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…
In December 2015, my colleague Vincent did a test with additional column with Oracle GoldenGate 12.2. Hervé & Vincent asked me to do the same test with Attunity Replicate between Oracle and SQL Server. For the story, Hervé does the test with a previous version here. I create a task and select the Scott schema. I run the replication On…
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 section about Backup and Restore ??? How to back up a task? The backup is, in reality, an export… The first…
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…
