Everything SQL related and then some
A few days back I got a call close to midnight where a client’s client was facing an issue. They had recently suffered a power failure and the Sysadmin while bringing the database server online deleted the ldf file for the database by mistake. I can only assume he thought log file meant error logs…
If you don’t know what this means pay attention!! I recently posted a blog about the characteristics of a senior DBA. One of the points mentioned there was how Senior DBA are often left with a feeling that they have only scratched the surface. At the time I didn’t know this was a scientifically proven…
A quick video showing that the mdf and ldf files are actually ** NOT ** dropped during server restart. Thanks to Mike for bringing up this topic. https://www.youtube.com/watch?v=N4eB-uY5MYI We also cover some quirky behavior by tempdb where it still detects the changes in model database and persists them to tempdb after the restart. More on…
I am not sure how many other users have visited this blog but it’s been one of my go to places when I wanted to read up on a particular topic. Tons of e-books available to avid reader of IT literature. Updated link below NEW DOWNLOAD LINK Old link http://blogs.msdn.com/b/mssmallbiz/archive/2015/07/07/i-m-giving-away-millions-of-free-microsoft-ebooks-again-including-windows-10-windows-8-1-windows-8-windows-7-office-2013-office-365-sharepoint-2013-dynamics-crm-powershell-exchange-server-lync-2013-system-center-azure-clo.aspx
Recently imported a table where the column names where quoted using double quotes which then became the table names , So a column name would be “Airline” instead of Airline. Here is a simple script to rename all the columns in all tables within a database. SELECT ‘[‘ + TABLE_SCHEMA + ‘]’ + ‘.[‘ +…