Viewing 15 posts - 4,966 through 4,980 (of 7,168 total)
TeraByteMe (2/17/2012)
You guys appear to have a great grasp on working with Regular Expressions and PowerShell. Any resources (books, articles, etc...) that you can recommend?
I have a fair amount of...
February 18, 2012 at 1:03 pm
I worked on this for a minute too. Since you're looking for subsequent lines to add value to your object's row it's back to that nasty loop logic...see if this...
February 17, 2012 at 1:21 pm
Anytime, happy to help 😀
January 27, 2012 at 3:43 pm
BATCHSIZE controls the number of rows committed to the DB at one time.
January 27, 2012 at 1:32 pm
This worked for me:
Add-PSSnapin SqlServerCmdletSnapin100 -ErrorAction SilentlyContinue
Add-PSSnapin SqlServerProviderSnapin100 -ErrorAction SilentlyContinue
[System.Reflection.Assembly]::LoadWithPartialName(‘Microsoft.SqlServer.Smo’) | Out-Null
foreach($linkedServer in (Get-ChildItem SQLSERVER:\SQL\MYSERVER\DEFAULT\LinkedServers)) {
$linkedServer.Script() | Out-File ("C:\LinkedServer." + $linkedServer.Name.Replace(".","_").Replace("\","$") + ".sql")
}
January 27, 2012 at 11:49 am
Jeff Moden (1/26/2012)
January 26, 2012 at 9:28 am
Jeff Moden (1/25/2012)
babatmanpub (1/25/2012)
Just for those who would like to change $pshome : you can do it here :with regedit
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\PowerShell\1\PSConfigurationProviders\Microsoft.PowerShell]
"ApplicationBase"="c:\\Windows\\System32\\WindowsPowerShell\\v1.0"
Nicely done.
Shifting gears a bit (and no implications about...
January 26, 2012 at 7:09 am
Jeff Moden (8/16/2011)
I know it doesn't help but this is one of the many reasons why I try to do as much as possible from T-SQL. 😉
The environmental oddities introduced...
January 26, 2012 at 7:04 am
Wow, 20 thread views and not one poll reply or comment? Is everyone ignoring the Windows Event Log entries on their SQL Servers?
January 11, 2012 at 2:56 pm
An update on this: we disabled the job that was running the process doing 1.3MM reads every 30 minutes during the day since it was learned that it was a...
January 9, 2012 at 1:26 pm
From Metadata Visibility Configuration:
In SQL Server 2005, the visibility of metadata is limited to securables that a user either owns or on which the user has been granted some permission.
Synonyms...
January 9, 2012 at 11:55 am
The EXECUTE AS Clause sets the execution context to a Database User, not a Server Login. The distinction implies that the Database User executing the proc must exist in all...
January 9, 2012 at 9:34 am
You can check for encrypted connections with this query:
SELECT *
FROM sys.dm_exec_connections
WHERE encrypt_option = 'TRUE' ;
January 9, 2012 at 9:10 am
baal32 (1/2/2012)
Each user can rate each item 0 or 1 times. Let's assume the rating itself...
January 5, 2012 at 11:00 am
I am confident I could actually pass it off too 😛
Thanks for the guidance. I am not going to dig into the possibility of an internal memory leak. I think...
December 27, 2011 at 3:32 pm
Viewing 15 posts - 4,966 through 4,980 (of 7,168 total)