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 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 BluminMar 13, 20172 minT-SQL Programming for Developers CourseAre you a software developer? Did you ever get to develop a software that works with a Microsoft SQL Server database? Perhaps you started out all nice and go...
Eitan BluminMay 13, 20143 minThe 3 Factors That Will Get You a Job You’ll LoveIt’s T-SQL Tuesday time, and this month’s host, Boris Hristov (blog|twitter) chose the topic of interviews. Over the time as a SQL Server professional, I’ve ...
Eitan BluminJan 2, 20143 minThings I Learned in 2013It’s 2014 now. I hope you had fun in new year’s eve. 2013 was an amazing and intense year. To recap it, I thought about sharing some of the things I learned:...
Eitan BluminAug 26, 20134 minHow to Become a Better DBAWhether you’re just starting out or already a few years in the game, you’re probably wondering how you can become a better DBA. Here’s what works for me: 1. ...
Eitan BluminJul 19, 20131 minBest SQL Server Podcast and Video Sites (Hangout)My friend Boris Hristov (Blog | Twitter) continues his Google Hangouts initiative, and this week he invited me to talk about the best learning resources for ...
