Database Administration & Monitoring SQL Server 2016: Extended Events are more powerful as Trace Flag for Backups and Restores 12.05.2016 by Stéphane Haby 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(…)
Database Administration & Monitoring SQL Server: Now Cumulative Updates (CU) need to be install! 10.05.2016 by Stéphane Haby 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(…)
Application integration & Middleware Attunity Replicate: Replicate numeric data types from Oracle to SQL Server is easy 04.05.2016 by Stéphane Haby 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(…)
Development & Performance, Technology Survey SQL Server 2016: Microsoft R Server 04.05.2016 by Stéphane Haby In my last article, I wrote about the R Services into SQL Server. Now, Microsoft provides an open source R platform to complete this new SQL Server integrated feature in 2016.
Development & Performance, Technology Survey SQL Server 2016: R Services 19.04.2016 by Stéphane Haby I was during a long time captivated by the R programming language. I’m happy to see that SQL Server 2016 provides now a SQL Server R Services. This service enables SQL Server to execute R scripts. The first(…)
Database management, Technology Survey SQL Server 2016: CREATE TABLE for Stretch Database is available 30.03.2016 by Stéphane Haby This month, the Release Candidate 1 (RC1) for SQL Server is available. With this new version, you can now use the “CREATE TABLE” command for Stretch Databases. If you read the msdn page(…)
Database Administration & Monitoring, Technology Survey SQL Server 2016: new upgrade advisor 14.03.2016 by Stéphane Haby I write this article because it is very interesting to see that the upgrade advisor has evolved… Recently (February 11, 2016), a new version is available: Microsoft® SQL Server 2016® Upgrade Advisor Preview 1.4 The msi package(…)
Database Administration & Monitoring SQL Server Tips: Find sql logins when “windows authentication only” is enabled 05.02.2016 by Stéphane Haby A customer asks me to find all sql logins enabled on servers where windows authentication only is enabled. The goal is to clean sql logins on all servers through the CMS (central management server). In some cases, sql logins are(…)
Database Administration & Monitoring, Database management SQL Server Tips: Default trace enabled but no file is active… 14.01.2016 by Stéphane Haby I discover a strange error with a customer about the default trace. As you know, SQL Server has a default trace with a lot of events like the data and log file growth. This trace is enabled by default and(…)
Technology Survey SQL Server 2016: temporal table with In-Memory 08.01.2016 by Stéphane Haby In SQL Server 2016 CTP 3.0, temporal tables with In-Memory OLTP is supported. 🙂 At the JSS2015 (Journée SQL Server 2015), I have presented a little demo about temporal table with a table(…)