Viewing 15 posts - 16 through 30 (of 4,745 total)
Perry Whittle (6/23/2016)
Microsoft do not recommend changing the port on a default instance, leave it at 1433.Why do you want to change it
where is that stated Perry (just interested)
---------------------------------------------------------------------
June 24, 2016 at 10:39 am
Brandie Tarvin (6/22/2016)
Perry Whittle (3/25/2015)
I have not covered backups in detail as there will be varying preferences involved. I may do something post the stairway series.
Quick question on the backups......
---------------------------------------------------------------------
June 23, 2016 at 3:37 am
you license a server, so the number of instances do not affect it.
---------------------------------------------------------------------
June 15, 2016 at 8:20 am
my understanding is that anything that comes under client tools or connectivity does not need to be licensed
---------------------------------------------------------------------
June 15, 2016 at 7:29 am
put an exec in front of dbo.report_stale_open_teller_count
This is because if the execution of a stored procedure is not the only statement in the batch, you need to add an explicit...
---------------------------------------------------------------------
June 15, 2016 at 6:03 am
use at your peril I guess?
Are these the commands used by hardware based backup solutions?
---------------------------------------------------------------------
May 25, 2016 at 3:50 am
SQLRNNR (5/3/2016)
Ed Wagner (4/13/2016)
george sibbald (4/12/2016)
I had to answer this just to join the discussions (I got it wrong)It was certainly specific. I guessed.
+1. Very specific question. I also...
---------------------------------------------------------------------
May 4, 2016 at 6:30 am
george sibbald (4/22/2016)
---------------------------------------------------------------------
April 26, 2016 at 3:26 pm
Hi Perry, thanks for article, most useful.
I have just configured our first multi subnet AG and have a couple of questions. I note on the listener tab you have specified...
---------------------------------------------------------------------
April 22, 2016 at 9:39 am
how badly are the indexes fragmented? Have you considered reorganising rather than rebuilding, it will be less intrusive, you can then at least control log growth and cancel it if...
---------------------------------------------------------------------
April 22, 2016 at 6:50 am
everyone who got this right will have their point deducted. Its only fair.
---------------------------------------------------------------------
April 18, 2016 at 6:57 am
is this a default instance? SSMS as a client presumes port 1433, so if it is set to some other value you need to explicitly specify it.
---------------------------------------------------------------------
April 15, 2016 at 6:27 am
'meant to be' and 'have to' are two different things..............
or one different thing in this case.................:-)
---------------------------------------------------------------------
April 15, 2016 at 3:44 am
only always on is going to provide all the options the op asks for with a DR secondary and a read only secondary, but complicated and expensive, log shipping will...
---------------------------------------------------------------------
April 14, 2016 at 3:35 am
jasona.work (4/13/2016)
You don't know about handy things like the SSIS task "Transfer Jobs" and "Transfer Logins"...
Thankfully I came across those today,...
---------------------------------------------------------------------
April 13, 2016 at 10:28 am
Viewing 15 posts - 16 through 30 (of 4,745 total)