You searched for the word(s):
Showing page 1 of 11 (106 total posts)
< 1 second(s)
Nice script, Merrill.
It shows how you might do it the easy way.
However, it lacks to use the picture property "date taken", which is available using .Net properties in System.Drawing.
The script in this reference uses this property information, which will even make your photo library more ...
I noticed a
Error: 18456, Severity: 14, State: 11
Login failed for user 'domain\account'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: xxx.xxx.xxx.xxx]
( SQL2008R2 sp2 CU4 on win2008R2 )
Turns out this login didn't have any auth to get to this sql ...
Great post, Rob.
I just feel the need to emphasize the needed SET options when working with filtered indexes, as these settings a mandatory for all connections hitting that table.
So not only at create time of the index !
( bol/technet weren't clear on this : http://technet.microsoft.com/en-us/library/ms188783.aspx )
Been bit by it once ( on ...
this may be an interesting case for your request.
must be something in the url on this page. the copy/pasted url works ?-)
apparently the links are broken ... e.g. Updates on QDPMA Stats Stream - Updated points to http://www.qdpma.com/cbo/statstream.html which gives me "Server not found"
Nice fast lane solution, Allen.
I used this one to just list all queries for rdl files on a given location:
Since RDL is XML maybe just look for the query element
$RptFilePath = "X:\ItsMe\My Documents\SQL Server Management Studio\Custom Reports\"
$ResultFile = "$env:temp\ReportQueries.csv"
$RDLs = ...
Great piece of documentation and test cases.
Just a quick note:
Chances are Logman throws an error. This will not be captured in a Try/Catch because Logman puts that in its standard output.
Quick workaround can be:
"Logman start SQLPerf" | Out-File -FilePath $LogmanCmdFile -Force -Encoding default
$test = ( Start-Process -FilePath $LogmanCmdFile -Wait ...
Another great post, Allen.
Another example of powershell's versatility and the way it can serve use all.