Eitan BluminFeb 19, 20182 minThe king is dead, long live the king!Everyone, who deal with SQL server, know sample database AdventureWorks, which has been with us since the days of SQL Server 2005. Most of official SQL Serve...
Eitan BluminJan 8, 20182 minWhat is Graph Processing in SQL Server 2017?There is a growing need for Graph Databases in the market. This is a type of database, which is capable of storing, representing and manipulating graphs easi...
Eitan BluminDec 25, 20172 minWhat is the Automatic Plan Correction in SQL Server 2017?SQL Server 2017 brings a new interesting feature, that might be a game changer in some environments. I’m talking about Automatic Plan Correction. This featur...
Eitan BluminDec 7, 20173 minHow to Update @@SERVERNAME to Actual Machine Name?The @@SERVERNAME Global Variable The system global variable @@SERVERNAME can be used to return the name of the machine the SQL Server is hosted on. This var...
Eitan BluminNov 16, 20171 minCan I pause or resume an index rebuild operation?One of the cool new features in SQL Server 2017 (and currently also in public preview in Azure SQL Database) is the option to pause and resume an online inde...
