Thanks. I will file a bug on the article to get it fixed. I have a caption in my article, but on the web page it does not....

Yes, I use it as well. I used invoke-sqlcmd2 -As DataTable in this case, but I regularly use Out-DataTable for many things. Glad you get use out of it too.

I am not sure why you would not see the instances when you use the dir SQLSERVER:\sql\localhost.

Mine shows DEFAULT as the instance name. If I cd into DEFAULT then...

If you do this:

cd SQLSERVER:\sql\localhost

dir

You should see instances. If you have a default instance then you use the word DEFAULT or default in your path.

SQLSERVER:\sql\localhost\default

Or

$wintitle = "$($CurrentUser.Name) $($Host.Name) $($Host.Version)"

Good comments. The series is meant to introduce you to PowerShell and SQL but not to imply that PS and SMO are the replacements for SSMS or TSQL. SMO...

sys.master_files will always show 0 for the memory optimized file because it is a FILESTREAM type.

sys.database_files will show the used amount of data in the memory optimized file.

You can look...

Yes, in most cases you can use notepad $profile and it will open up profile and let you say "Yes" create a new file, but only if there is a...

There may be a revision of the earlier articles. I wrote them when the versions were not as advanced as today.

We will see when I finish the last few...

SQL Azure has it's own PowerShell modules.

http://azure.microsoft.com/blog/2013/02/07/windows-azure-sql-database-management-with-powershell/

I think you misunderstood my post. I said that if it existed in AD it needed to be disabled in a prestage.

When using SMO for SQL Server you need to remember that going backwards is supported but going forward will not always work. In your case this is especially true. ...

You can look at this. I used a dependency tree.

http://sqlblog.com/blogs/ben_miller/archive/2007/10/18/scripting-tables-views-and-data-using-smo-part-3.aspx

From what you say you are dealing with a Heap and when you add and delete data in a Heap, SQL Server manages what is "allocated" to the table and...

You need to ensure that the computer name does not exist in AD. A failed install attempt can put that name in AD. The network name you add in your...