.jpg)
.png)
.png)
.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.
This of course makes your VM run slower, as you have resources being allocated for services you don’t need. So how do you go about removing the unnecessary components?
When you attempt to run the SQL Server Installation Center it will complain with an error it cannot find the media. However if you look in the C drive you will find a directory similar to “C:\ SQLServer_SQLMajorVersion.SQLMinorVersion_Full” (for SQL 2012 this would be C:\SQLServer_12.0_Full) which contains all the media.
Try it out next time you start up a new SQL Azure VM, or go into your existing ones and make sure you remove any services you are not using.
Related Posts
.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?
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.