Tag Archives: reference

Search Windows Server patches using KBXXXX

Server http://www.catalog.update.microsoft.com using KB number to find the patch information and download link. 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

Querying oracle database for the first time

I have been using SQL for a decade but I never had to connect Oracle database till last week! So, even basics are like learning for me! • Oracle SQL Developer is the tool similar to SSMS you can download … Continue reading

Posted in Productivity, Useful Link | Tagged , , | Leave a comment