A client’s SQL Server 2008 R2 SP2 patch failed, and the setup logs showed Failed to connect to server, Error: 0x80070422. Here is how we traced and fixed it.
MySQL – ELT() and FILED() Functions to Extract Index Position From List
MySQL’s ELT() returns the value at a given index position in a list, and FIELD() does the reverse. Here is how both functions work, with simple examples.
“I Don’t Know” – DBAs Should Learn to Use This Phrase – Notes from the Field #119
In Notes from the Field #119, Mike Walsh explains one of the most important things DBAs should learn: how and when to say ‘I don’t know’.
SQLAuthority Banner Journey: Five Looks in Ten Years
The SQLAuthority banner journey, told by the banners themselves: the first banner of a blog called Journey to SQL Authority, a green one with an MVP badge, a blue one with a cloud, a poll winner, and the 2016 banner that is still at the top.
SQL SERVER – Extended Events to watch for using ColumnStore Index
Profiler can’t show how ColumnStore indexes work, so a DBA friend asked which extended events to watch. Here are my notes on the events worth tracking.
SQL SERVER – How Enable Transparent Database Encryption (TDE) for Database Mirroring?
hey incidentally wanted to enable Transparent Database Encryption (TDE) on their server and wanted me to guide on how to enable.
Interview Question of the Week #063 – How to Recompile Stored Procedure for Specific Table?
After a big data change in one table, we wanted fresh plans. Here is how to recompile stored procedure plans for a specific table, with a word of caution.