Tag Archives: sql

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

Solution – Error: Could not retrieve initialization strings. Run DBAmp Configuration program and press OK on Options dialog.

SF_Replicate fails with below error: Error: Could not retrieve initialization strings. Run DBAmp Configuration program and press OK on Options dialog. NOTE: At times, you may encounter this error when you execute SF_RefreshAll with “Yes” option and when it tries … Continue reading

Posted in SQL, 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

Knowledge Share 2014-06

• Can I change SQL Server Name/ Instance Name: o Yes, you can change SQL Server name. Especially when you rename your server name, it is good option to change your SQL Server name. o http://msdn.microsoft.com/en-us/library/ms143799.aspx is the article which … Continue reading

Posted in knowledge, SQL | Tagged , , , , | Leave a comment

Knowledge Share 2014-05

* Function to convert a list into a table (Collected this piece of code from my Colleague, Satya Addala) * Computed columns can not be altered but needs to be dropped and re-created * Caution while creating DDL triggers, specially … Continue reading

Posted in knowledge, Script, SQL, SQL Query | Tagged , , , , , | Leave a comment

Blocking Monitor and alert

I have created following blocking monitor which will monitor and alert if threshold is crossed. We can pass the parameters when the alert to be triggered (Number of blockings and number of seconds the blocking persists). I have configured a … Continue reading

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

Knowledge Share 2014-04

In SQL Server 2014, you can have 8 secondary replicas, it was 4 in SQL 2012 Ref: What’s New (DB Engine) SQL Server 2014 – http://msdn.microsoft.com/en-us/library/bb510411%28v=sql.120%29.aspx#DataFiles What is Cardinality Estimation? This is new feature in SQL Server 2014: The cardinality … Continue reading

Posted in knowledge, Productivity, SQL, sql2014 | Tagged , , , , , , , | Leave a comment