Viewing 15 posts - 31 through 45 (of 90 total)
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
October 19, 2015 at 3:50 pm
fmonsua (7/21/2015)
$wintitle = $CurrentUser.Name + " " + $Host.Name + " " + $Host.Version
Or
$wintitle = "$($CurrentUser.Name) $($Host.Name) $($Host.Version)"
July 21, 2015 at 8:43 am
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...
April 23, 2015 at 4:32 pm
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...
April 21, 2015 at 7:49 am
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...
March 20, 2015 at 8:21 am
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...
March 20, 2015 at 8:20 am
SQL Azure has it's own PowerShell modules.
http://azure.microsoft.com/blog/2013/02/07/windows-azure-sql-database-management-with-powershell/
February 5, 2015 at 3:15 pm
I think you misunderstood my post. I said that if it existed in AD it needed to be disabled in a prestage.
January 5, 2015 at 8:34 am
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. ...
January 5, 2015 at 8:27 am
You can look at this. I used a dependency tree.
January 5, 2015 at 8:25 am
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...
January 5, 2015 at 8:11 am
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...
January 5, 2015 at 8:04 am
Here is a great post about how to configure the firewall part.
http://www.lewisroberts.com/2009/08/16/msdtc-through-a-firewall-to-an-sql-cluster-with-rpc/
But the idea is that every cluster after Windows 2003, you configure the MSDTC resource inside each...
January 5, 2015 at 7:41 am
Thanks. I will have that fixed.
September 9, 2014 at 8:53 pm
OK, thanks. I have used it on SQL 2005 and above with great success so I guess mileage varies on the project and versions of SQL server.
Thanks for commenting.
May 14, 2014 at 6:47 pm
Viewing 15 posts - 31 through 45 (of 90 total)