Infrastructure at your Service
In the last IT Tagen 2016, I presented the Dynamic Data Masking (DDM) and how it worked. To add a little fun, I applied the DDM to a temporal table to see if the history table inherits also from DDM’s rules. In this blog, I explain all the different steps to reproduce my last demo. Step 1: Create the table and the temporal table in the database DDM_TEST USE [DDM_TEST] GO CREATE TABLE [dbo].[Confidential]( [ID]…
Today, to finish the year, I post a brief personal impression of the IT-Tage 2016 in Frankfurt at the Hotel Maritim, where I was also be a speaker. I presented 2 sessions on SQL Server: “SQL Server Errorlog Entmystifizierung” & “SQL Server 2016: Neue Sicherheitsfunktionen”. I wasn’t the only one from dbi services who spoke at that conference: David Barbarin with also 2 sessions: “SQL Server – Locks, latches and spinlocks” & “SQL Server 2016…
After a little trip, just 1-hour flying from Zürich to Ljubljana yesterday, the SQL Saturday Slovenia 2016 begins this morning at the Faculty of Computer and Information Science of the University of Ljubljana… I needed to wake up very fast because my session was the first of the day at 9:00 AM. I also very happy to meet and to share my expertise with Slovenian and other SQL Server experts. My session was about the…
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”. Follow all “classic” steps to create your new VM SQL Server on Linux: First step,…
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. The output is a table with 16 columns with basically these information: Package LibPath Version…
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) The function return a table of one column with all splitting string A first test…
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 es nicht möglich, denn es treten Fehlermeldungen auf: Msg 12603, Level 16, State 1, Line…
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…
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”) |…
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…
