.jpg)
.png)
%20(1).png)
%20(700%20%C3%97%20500%20px)%20(2).png)
May 4, 2016
SQL tip #1: Store SQL DB files in Azure storage
Did you know that you can configure an Azure SQL VM (or on premise machine) to store SQL data (.mdf) and log (.ldf) files in Azure storage?
Why? Well it means if you want to move your VM, i.e. create a new VM and migrate to it, you can easily make a change and use a simple detach and re-attach to make the database(s) available again. You can find full instructions from Microsoft here.
Try it out next time you start a new SQL Server or migrate the existing databases you have to Azure storage
Related Posts
.png)
April 27, 2016
SQL tip #2: Remove unnecessary SQL components from an Azure VM
Did you know that when you first request a SQL Azure VM it comes with everything installed? This includes Analysis Services, Integration Services, Reporting Services, etc, even if you don’t want to use them.
May 25, 2016
SQL tip #3: consider a table variable
Most developers know the # preceding a local temporary table very well, as temporary tables are really useful when you need to keep some stuff in a place for a moment while you do something else. But you may not know there are quite a lot of processes that go into making this table, or that these can really inhibit the reuse of execution plans. So a harmless #temp may be bloating your memory or putting extra pressure on your TempDB and you might not even know about it.
June 8, 2016
SQL tip #4: using output clause to return changed items
Did you know that you can use the output clause to return updated or inserted rows without having to select them again?
June 15, 2016
SQL tip #5: Be prepared for SQL 2016
Did you know that in SQL Server 2016 you can now specify the location of the tempdb files during setup?
June 30, 2016
SQL tip #6: Scripting multiple SQL objects
Sometimes we need to script multiple SQL objects, either for deployment, documentation or quick search, eg to find SSIS package name.