Azure SQL Database Resource Limits,

Azure SQL Database Resource Limits. Azure SQL as an service database limitation SQL Database is a general-purpose relational database service in Microsoft Azure that supports structures such as relational data, JSON, spatial, and XML. It delivers dynamically scalable performance. SQL Database shares its code base with the Microsoft SQL Server database engine. With Microsoft’s cloud-first strategy, the […]

Continue Reading

powershell to install sql server 2012

powershell to install sql server 2012 Installation Options The Setup supports the following installation options while installing SQL Server 2012 on a Server Core operating system: Installation from Command Line To install specific features using the command prompt installation option, use the /FEATURES parameter and specify the parent feature or feature values. The following is […]

Continue Reading

PowerShell script to help uninstall SQL Server 2008 R2 Evaluation Edition

PowerShell script to help uninstall SQL Server 2008 R2 Evaluation Edition Get-ChildItem HKLM:SOFTWAREMicrosoftWindowsCurrentVersionUninstall | select @{Name=’Guid’;Expression={$_.PSChildName}}, @{Name=’Disp’;Expression={($_.GetValue(“DisplayName”))}} | where-object {$_.Disp -ilike “*SQL*R2*”} | where-object {$_.Guid -like ‘{*’} | % {“rem ” + $_.Disp; ‘msiexec /x “‘ + $_.Guid + ‘”‘; ”} > uninstallR2.bat The script is quite straight forward, it just lists everything in the uninstall bit of the […]

Continue Reading