Tag Archives: reference

MSSQLSERVER Error Catalog

https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-events-and-errors?view=sql-server-ver15

Posted in SQL, SQL Server, Uncategorized | Tagged , , , , , | Leave a comment

Search Windows Server patches using KBXXXX / Microsoft Security Update Guide

Server http://www.catalog.update.microsoft.com using KB number to find the patch information and download link. Security Update Guide: https://portal.msrc.microsoft.com/en-us/security-guidance Example: http://www.catalog.update.microsoft.com/Search.aspx?q=KB4489882

Posted in Productivity, Uncategorized | Tagged , , , | Leave a comment

SQL latest available patch reference

Best source for latest SQL Server patches: https://sqlserverbuilds.blogspot.com/ Ref 2: https://technet.microsoft.com/en-us/library/ff803383.aspx (Hotfix information is not updated) Option 3: https://sqlserverupdates.com/

Posted in SQL Server, Uncategorized | Tagged , , | 1 Comment

Powershell Workflow for Runbooks, Inline Script

Powershell workflow is the best way to program parallel processing using Powershell and/or in Azure run books. Though the syntax is similar, there are few differences you need to be aware of. Start with below link when you create your … Continue reading

Posted in Azure, Powershell, Uncategorized | Tagged , , , , , , | Leave a comment

Azure Database pricing tier selection

Azuer provides multiple Servie level options to choose for your database(s)s depending on number of databases/ Size/ CPU/ Number of Sessions/ Number of Connections to the database. As the number of database you want to host increases you have more … Continue reading

Posted in Azure, Referene, Uncategorized | Tagged , , , , , , , | 1 Comment

Report Data Pane is missing – Latest SQL Version – SystemInfo – Azure Infographics

Just want to share something interesting I have come across in last few weeks… ALT + CTRL + D is the shortcut to get the Report Data Pane back. At times you will not be able to see the shortcut! … Continue reading

Posted in commands, knowledge, Productivity, Referene | Tagged , , , , , | Leave a comment

SSIS Expressions – Date operations, Data Type conversions and more…

I had to use Derived Column Transformation Editor to split a datetime column into 2 parts one with Date only and another column only with Time. I had to invest some time to get the simple solution as follows… There … Continue reading

Posted in Productivity, Referene, SQL, SSIS | Tagged , , , , , | 1 Comment