Organizations may have many concerns about performance when migrating databases to Azure. Fortunately, Microsoft provides some great tools to help improve performance and save money. In this article, Monica Rathbun explains how to take advantage of these features.
2019-02-28
2,433 reads
In the world of paradigm shifts, many organizations are looking at the prospect of a technology migration, where capabilities are moved to a new set of technologies, supporting and enabling the business for the future. On other hand, a technology or platform may reach the end of its life for other business reasons, like ease of use, increased cost, etc.
2018-08-07
3,088 reads
There is a new utility to import data from SQL Server on premises or Azure SQL to Azure SQL Data Warehouse (ASDW)
2017-07-17
1,532 reads
2017-03-09
535 reads
2017-03-08
989 reads
2017-02-28
9,157 reads
Execute at source, and will generate an output with TSQL commands to create temp tables filled with top 50 long lasting queries from all databases.
Then execute output at destination and will do the same and show comparison of matching queries!!
2016-12-19 (first published: 2016-12-06)
791 reads
Aaron Bertrand follows up on a recent post about DATEFROMPARTS() with a deeper look into the estimates and potential mitigation techniques.
2016-08-15
3,092 reads
Use provided script to fix orphan users for all databases after Instance Migration. Tested on SQL 2014.
2016-01-04 (first published: 2015-12-17)
1,438 reads
Use this script to set recommended Log files size growth for larger DBs. For more, please refer article: http://sqlmag.com/blog/choosing-default-sizes-your-data-and-log-files
2015-12-15 (first published: 2015-12-07)
1,206 reads
There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...
By Steve Jones
Today’s coping tip is to find a new way to tell someone you appreciate...
I was given 4.5 months notice this past June and was fortunate to find...
Comments posted to this topic are about the item Stairways to ScriptDOM Level 4...
Comments posted to this topic are about the item The Availability Group Secondary Connection
I am getting the following error when I try to use the Expression below....
Ask SSC