SQL Server Education (by the geeks, for the geeks)
I had a scenario where in I had to automate index maintenance in a mirroring environment. Database mirroring requires a database to be in full recovery mode and thus index rebuild …
SQL Server – Automate Index Maintenance in Mirroring environment Read MoreThis is a relatively a short blog providing a general introduction to SQL Server Analysis Services Tabular Model management using Windows Powershell. You can discover and learn more about Powershell from …
SQL Server Analysis Services Tabular Model Management using Powershell Read MoreIn this article i’ll show you the steps to Enable PS in Windows Server 2008 R2. Windows Server 2008 gets shipped with Powershell v1.0. But it is disabled by default to …
Enable Powershell Feature in Windows Server 2008 R2 – SQL Server Read MoreThe dir command allows you to see the available Files & Folders in a directory. The same command is available in Powershell to see all available Files and Folders in a …
SQL Server: Use of Dir | Get-ChildItem | LS in Powershell Read More