Virtually Sober

If there is free booze and Virtualization; I'm there!

Tag Archives: SqlServer

Automating SQL Server Live Mounts with Rubrik Alta (4.0)

How many times in your career have you tested something that totally blew you away? Your mind racing with use cases both past and present. The first VM you created? Check. Your first vMotion? Check. Your first storage vMotion? Check. But what next? I just found one to add to my list and its SQL Server Live Mounts in Rubrik Alta (4.0). So what exactly is it and why is it so amazing? Glad you asked, read on!

Read more of this post

Working with SQL databases using PowerShell

One of the things I love about PowerShell is the sheer number of use cases you can address. A perfect example is working with SQL databases. If you think you need to wait for a DBA to give you data from a SQL database then you’d be wrong. You can use SELECT queries to pull data directly into PowerShell from any SQL database and not only that, you can also INSERT, UPDATE, DELETE or whatever else you desire, all from the comfort your scripts using invoke-sqlcmd in the Sqlserver PowerShell module. This also means you can now store data from your PowerShell scripts in SQL for long-term reporting, configuration management, you name it.

SQLServerBrowser

Read more of this post