SQL Server – Resolve “The /IAcceptSQLServerLicenseTerms command line parameter is missing or has not been set to true.”

As I blogged before, I am in the process of downgrading most of our Enterprise Edition SQL Servers to Standard Edition. The Uninstalls and Installs are done from the command-line. When I tried to install SQL Server 2012 Standard from the command-line, I used the following command-line I have added new-lines above so that you … Continue reading SQL Server – Resolve “The /IAcceptSQLServerLicenseTerms command line parameter is missing or has not been set to true.”

Advertisements

PowerShell: Save Millions By Downgrading Your SQL Server Edition & Partially Automate It!

This is one of those fresh ideas I wish I had but in reality it did not occur to me until it came down to me for execution from above me. Good job managers! Kudos. Sorry, I did not come-up with this! Execution: "I can do really well and you have got the best". I … Continue reading PowerShell: Save Millions By Downgrading Your SQL Server Edition & Partially Automate It!

PowerShell: Backup All SSAS Databases To A Network Share

I am working on downgrading SQL Server Enterprise Edition (EE) s/w to Standard Edition (SE) where EE features are not used (to save money on licensing). We have a big list of these to go through. That required all SSAS databases to be backed-up to the network and restored after the edition downgrade. I will … Continue reading PowerShell: Backup All SSAS Databases To A Network Share

SQL Server: Identify And Defragment Indexes Using DBCC SHOWCONTIG & DBCC INDEXDEFRAG

A good defrag script is worth its weight in gold. This time, I copied this from Microsoft and am shamelessly posting it here because I don't know when MS will bury it somewhere where it cannot be located anymore! Just because you de-fragmented does not actually mean that it did it! It means, it tried. … Continue reading SQL Server: Identify And Defragment Indexes Using DBCC SHOWCONTIG & DBCC INDEXDEFRAG

SQL Server – Breakup A Monolithic Data File (Database) Into Multiple Small Files And Breakaway From Shrinking!

If the SQL Server databases being manged are a few GB in size each, then having a single .mdf file for data is fine. However, if the size is anywhere in the hundreds of GB or more, then a single .mdf file is certainly not the way to go. Related to this, please checkout my … Continue reading SQL Server – Breakup A Monolithic Data File (Database) Into Multiple Small Files And Breakaway From Shrinking!