Tag Archives: reference



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

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

Microsoft Azure enhancements – 2014 December 11 – SQL 2014 Features and Compatibility

Azure enhancements released are huge and touching multiple services like Premium Storage, RemoteApp, Database etc… I am impressed with SQL Database enhancements! * Performance: Significant improvement to performance compare to existing offerings, support for In-memory columnstore queries. * Large Database … Continue reading

Posted in Azure, Referene, SQL | Tagged , , , | Leave a comment

Access to run SQL Profiler/Trace – Minimum access

If you need to provide access to someone only to run SQL Profiler SQL Trace you need to Grant ALTER TRACE permission. This feature is introduced in SQL Server 2005… – Permissions to run SQL Trace Reference: http://msdn.microsoft.com/en-IN/library/ms187611.aspx -Vijred

Posted in Productivity, Referene, Script, SQL, SQL Query | Tagged , , , , , , | Leave a comment