Tag Archives: reference

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 , , , , | Leave a 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

Extend Laptop display to Monitor but on different direction

I know most of you have been using this this feature but had to do more research for simple customization. In my work location I had to arrange my additional Monitor on left side. By default, My Windows-7 Laptop assumes … Continue reading

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