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 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 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 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 BluminSep 4, 20165 minWhy Would I Want to Use JSON in SQL Server?SQL Server 2016 offers built-in support for JSON, in a similar way to the support offered for XML since SQL Server 2000. Both XML and JSON are semi-structure...
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 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...
Eitan BluminDec 4, 20138 minService Broker Sample: Asynchronous TriggersIntroduction Service Broker is a cool feature new since SQL Server 2005. Yes, SQL 2014 is just around the corner so it’s hardly “new” any more. But in realit...
Eitan BluminOct 9, 20133 minHow to Limit IO Requests with SQL Server 2014 Resource GovernorResource Governor was introduced in SQL Server 2008 in order to allow us have better control over our system resource consumption. With Resource Governor, we...
Eitan BluminApr 17, 20131 minCool Tool – SQL Space MapI came across a cool open source tool called “SQL Space Map“. The tool, written by Ryan McCauley, presents a visual representation of table and index sizes: ...
Eitan BluminMay 7, 201210 minService Broker Sample: Multi-ThreadingIntroduction Service Broker is a cool new feature since SQL Server 2005. Yes, SQL 2012 just came out so it’s hardly “new” anymore. But in reality, many DBAs ...
