Viewing 15 posts - 1,276 through 1,290 (of 7,499 total)
Keep in mind you cannot connect Object Browser using and admin:server\instance connection.
You must use a Query panel ( New Query ) and then connect using admin:server\instance .
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 11, 2013 at 3:40 am
Also with SQL2012, only a single active DAC is allowed !
only one DAC is allowed per instance of SQL Server. If a DAC connection is already active, any new request...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 9, 2013 at 11:52 pm
Here's a good starter article to get to your answer: SAN Replication vs. Clustering vs. Mirroring Which should be used when? by Denny Cherry.
You've posted in a SQL2005 forum. If...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 4, 2013 at 1:58 am
Whenever I suspect the IO system to be unreliable, I move all DB stuff that is on it !
No doubt.
I wouldn't take the risk of down time or losing data...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 4, 2013 at 12:38 am
Well, could be someone of these users is locking some critical data, blocking everybody else from processing their stuff.
Attached you can find my SP_dba_whoblocks sproc which I use on all...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 3, 2013 at 2:29 am
did you check for (b)locking in your sqlinstance ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
January 3, 2013 at 12:04 am
DanMaxic (12/13/2012)
Please dont try use master.sys.xp_cmdshell, becouse of security reason it might be blocked.
u can use the DMV dm_exec_connections to get the info:
SELECT TOP 1 local_net_address FROM...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 13, 2012 at 11:57 pm
just a very primitive tip: Start small !
Start building your disaster recovery project with a very small scope, not that critical to business activity.
Only read the headers of the...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 10, 2012 at 12:49 am
Red Gate should indeed fix ALL refs it has to this wonderful resource !
1) Grant deserves it ! :smooooth:
2) The topic deserves it ! :kiss:
3) many people are looking...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 6, 2012 at 10:33 am
Guess what was the first script my win-admin produced using powershell: A nice GUI :hehe:
A wpf window requesting user input.
Just like I did, he started off with...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 6, 2012 at 9:39 am
Del Lee (12/6/2012)
Not sure why we are concerned about SQL Injection on this, though. I'm doing a straight INSERT. ...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 6, 2012 at 8:43 am
Del Lee (12/6/2012)
Thanks for all the replies. ..
Thank you for the feedback !
Keep in mind you will - sooner or later - hit localization problems because you convert stuff to...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 6, 2012 at 7:55 am
Looking at your code a bit more in detail ... :blush:
Why doesn't it hit a syntax error ??
IMO for your code to work it should be something like this :
$cmd.commandtext...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 6, 2012 at 7:03 am
of course - to get started - you can always use this catch block
catch {
write-host 'Catch block' -BackgroundColor Yellow -ForegroundColor Black
Write-Host $_.Exception.message -BackgroundColor Red -ForegroundColor...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 6, 2012 at 5:52 am
I use SQLPSx sqlpsx.codeplex.com , just for convenience 😀
[HashTable]$SprocParams = @{}
foreach ( $c in $RecordFields ) {
$SprocParams.Add($c.Name , [string]$CurrentRow.$($c.Name) )
}
$rc = Invoke-StoredProcedure -connection "Server=$TargetSQLServer;Database=$SQLDb;Trusted_Connection=True;Connect Timeout=5;Application Name=$Global:ApplicationName;Workstation Id=$env:COMPUTERNAME;" -timeout 5...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 5, 2012 at 8:12 am
Viewing 15 posts - 1,276 through 1,290 (of 7,499 total)