I thank Malathi (b|t) for hosting TSQL Tuesday #97. Topic for this month is “Setting learning goals for 2018”. I want to acknowledge that my learning goal will change with time and it happens every year. My first priority is my employer. I need to learn, improve and implement what the company need. Beside that […]
There are many blog posts available online about reading SQL Server Error Log or SQL Server Agent Error Log. What I needed was to search for a string (or string within a string) in all available error logs. Save the results in a table. That way I can find the frequency and pattern of the […]
I thank Rob Sewell (b|t) for hosting TSQL Tuesday #94. Topic for this month Let’s get all Posh – What are you going to automate today?. If you are a database professional most likely you heard of dbatools by this time. Dbatools is a free PowerShell module with over 200 SQL server administration, best practice […]
I thank Kendra Little (b|t) for hosting TSQL Tuesday #93. Topic for this month Interviewing Patterns & Anti-Patterns. What advice do you have for people preparing for or going through an interview?. After initial phone screening I went for in person interview. I was scheduled to meet 5 interviewer. Last person in the list was […]
There was a question in dba.stackexchange.com titled “module_end extended events duration in microseconds?” that I answered and it was Microsecond in that instance. Later on, I questioned myself if the duration is always in Microseconds for extended events. I found it is a mix of Millisecond, Microsecond and some are unknown meaning famous NULL. I […]