Madeira TeamMar 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...
Madeira TeamFeb 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...
Madeira TeamJul 26, 20171 minWorking with Very Large TablesRecently I presented an online session with the title “Working with Very Large Tables Like a Pro in SQL Server 2016”. The session...
Madeira TeamJan 15, 20151 minWhat to Expect When Transitioning from DBA to ConsultantLast week, Boris Hristov (b|t), the organizer of #SQLHangout, invited William Durkin (b|t) and me to a SQL Hangout about transitioning...
Madeira TeamSep 16, 20144 minDBA in the Cloud: Threat or Opportunity?Five years ago the term “cloud” was still a buzzword, and there was a lot of uncertainty and misconception around it. I remember many...