Eitan BluminMar 9, 20181 minWhy we should enable trace flag 3604 before part of DBCC statements?In many cases, while we using DBCC commands, we must to run two statements instead of one, in order to receive the wishful result. For example, in order to r...
Eitan BluminFeb 27, 20184 minPlanning to Increase Cost Threshold for Parallelism – Like a Smart Person!Planning to Increase Cost Threshold for Parallelism When administrating a SQL Server instance with multiple CPU cores and heavy workload, it’s common to see ...
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 BluminFeb 15, 20182 minSCHEMABINDING and Why It Can be Useful?In SQL Server, when we use the “WITH SCHEMABINDING” clause in the definition of an object (view or function), we bind the object to the schema of all the und...
Eitan BluminFeb 15, 20181 minExtremely easy tricks to list table columns’ names and replace SELECT *Everyone knows the simple T-SQL “SELECT * ” is bad practice. It can: Effects the execution plan (Table / Index Scan); Returns too much data: unnecessary extr...
Eitan BluminJan 8, 20183 minWhat Do You Do When Performance Sucks?So you are a SQL Server DBA, and you are responsible for a database, which gives you a hard time. Users constantly complain about poor performance, and the d...
Eitan BluminJan 3, 20184 minHow to fix Orphaned Users easilyWhat are Orphaned Users “Orphaned Users” is a common issue in SQL Server where a Database User is no longer associated with its relevant Server Login. This o...
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 BluminMay 10, 20172 minMy Session about SQL Server ParameterizationLast month I presented a session in the wonderful GroupBy online conference about SQL Server parameterization. The title of the session was “How to Use Param...
Eitan BluminDec 12, 20169 minSQL Server DBA Tips that Can Save Your AssOn November 9th I presented a session in the PASS Database Administration Virtual Chapter. The title of the session was “SQL Server DBA Tips that Can Save Yo...
Eitan BluminOct 20, 20163 minMachine Learning – What is It Good For?Machine Learning is a very powerful technology used in the field of predictive analytics. As far as I see it, Machine Learning is magic. The idea behind it i...
Eitan BluminSep 29, 20161 minPerformance-Oriented T-SQL Development in BelgiumOn October 10, I will come back to present in one of my favorite SQL Server conferences – SQL Server Days in Belgium, and this time it’s for a pre-conference...
Eitan BluminSep 8, 20161 minRecap of My 24HOP Session – From XML to JSONYesterday I presented my session From XML to JSON as part of the 24 Hours of PASS online event. There were around 200 attendees in my session. If you are one...
Eitan BluminSep 6, 20166 minHow to Audit Changes for Every Table in SQL ServerThe best thing about being an SQL Server consultant is that you get called in on the most interesting cases. By “interesting” I mean difficult and by “diffic...
Eitan BluminAug 22, 20163 minQuery Timeout of the Distribution AgentLast week I got a call from one of our clients. They issued an ALTER TABLE command in order to change the data type of one of the columns from TINYINT to INT...
Eitan BluminAug 4, 20162 minSQL Server 2016 Cumulative Update 1On July 25th Microsoft released the first cumulative update (#1) for SQL Server 2016. This is a good reason to celebrate. Usually we are not as excited about...
Eitan BluminJul 26, 20163 minMath in SQL Server – Calculating the Value of eThis is also called the natural logarithm, which is approximately equal to to 2.718281828459… I like numbers: many numbers, huge numbers and extreme numbers....
Eitan BluminJul 21, 20163 minWho the Hell is Going to Listen to SQL Server on the RadioAbout 3 years ago Matan Yungman contacted me and said he has an interesting proposition. We met and talked about all kinds of things, until I lost patience a...
Eitan BluminJun 14, 20163 minWe Must Wait for SP1 before Upgrading to SQL Server 2016This post is for T-SQL Tuesday, hosted by Michael Swart (blog | twitter). This month’s topic is all about SQL Server 2016 I’ve been working with SQL Server f...
Eitan BluminJan 25, 20165 minThings I learned in 2015Happy 2016! I continue my tradition of summarizing the things I learned in the past year (as a reminder, here’s what I learned in 2013 and 2014). Here’s some...
