Eitan BluminMar 163 minThe Ultimate Compression Savings Estimation Script for an Entire Databaseדחיסת מידע ב-SQLSERVER יכולה לחסוך שטח ואף לשפר ביצועים. אבל במקרים מסוימים זה יכול לגרום יותר נזק מתועלת, וחשוב לזהות מקרים אלה.
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 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 BluminAug 29, 20172 minThe 10 Basic Concepts of T-SQLFor the end of the latest Basic Querying and Programming in SQL Server course, I prepared a list of the basic concepts I recommend the students to remember a...
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 31, 20165 minA Recap of PASS Summit 2016Yes, it’s that time of the year again. It’s time for the annual PASS Summit. Just like every year, I had the pleasure of attending Summit – as a data profess...
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 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 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 29, 20163 minIf You Need to Think, You’re Doing It WrongA month ago, my wife and I were in Barcelona for a short vacation. In one of the days, we entered a small place called Wok to Walk for dinner. The concept is...
Eitan BluminMay 8, 20162 minWhy I Love SQLBitsLast week I attended SQLBits 2016 in Liverpool. I had such a great time, and I would like to share it with you. I arrived on Tuesday evening, so I had enough...
Eitan BluminApr 27, 20163 minColumnstore Index Enhancements in SQL Server 2016One of my most favorite technologies is Columnstore. Thankfully, the guys at Microsoft seem to agree with me, because they continue developing this technolog...
Eitan BluminApr 25, 20161 minPartition to Filegroup Mapping in SQL ServerSuppose you have a partition function and a corresponding partition scheme in SQL Server. The partition scheme maps each partition to a filegroup. It also in...
Eitan BluminApr 19, 20162 minManaging Users and Permissions on Vertica environmentLike most database management systems, Vertica allows managing security for users in order to make sure each user gets only the permissions that he actually ...
Eitan BluminApr 11, 20165 minLife Balance מה קורה ביום בהיר אחד כשהמנכ”ל מכריז על מהפיכה חברתיתהכל התחיל ביום בהיר אחד, כשגיא גלנצר מנכ”ל החברה התעורר והכריז “אני רוצה לחולל מהפכה חברתית!” בהתחלה, כולנו הסתכלנו עליו במבטים שואלים ואז, היה לו גם הסבר די...
Eitan BluminMar 3, 20161 minHow to Grant Permissions Only on the Replica in Database Mirroring and AlwaysOn AGYou work with Database Mirroring or AlwaysOn AG, and you want to make sure your end users work only on the secondary server. How should you do that? Scenario...
Eitan BluminMar 2, 20161 minHow to Use Parameters Like a Pro and Boost PerformanceYesterday I presented my favorite session “How to Use Parameters Like a Pro and Boost Performance” in the DBA Fundamentals PASS Virtual Chapter. I love this ...
