Viewing 15 posts - 1,156 through 1,170 (of 9,244 total)
webrunner (10/4/2016)
I'm planning an upgrade from SQL 2012 Enterprise Edition to SQL 2016 Enterprise Edition that also includes a physical-to-virtual switch of our cluster.
Does anyone know of any...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2016 at 3:40 am
roneri75 (10/6/2016)
Is there a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2016 at 3:31 am
when a user has the dbcreator server role and they create a database they are set as the database owner. This allows the user to inherit the DB_Owner database role...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2016 at 10:32 am
from what I'm reading you're creating a new listener each time and not adding extra subnet IPs to an existing listener.
Just add each subnet IP to the existing listener configuration
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2016 at 10:11 am
bugg (9/5/2016)
Thanks guys, due to my limited disk setup I have had to lump TempDB with user DB log files on a SSD.
Be aware this is not ideal or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 5, 2016 at 4:24 am
GilaMonster (9/5/2016)
TempDB however may well need its own drive or two, depending how much load is put onto it.
Exactly what I've been saying
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 5, 2016 at 4:14 am
SQLPRODDBA (9/1/2016)
Awesome script Perry! Is there an easy way to run this on multiple databases?
execute in a loop or cursor
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2016 at 10:49 am
bugg (8/31/2016)
Perry Whittle (8/31/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2016 at 10:40 am
Fly Girl (8/30/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 31, 2016 at 6:53 am
keep the tempdb data and log files on the same disks away from user database files. If you can put tempdb log onto a separate disk then do so.
do not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 31, 2016 at 6:45 am
master, msdb and model should just be left as is, no need to separate them.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 31, 2016 at 6:43 am
Can you list out the cluster resources, use this powershell command
Get-ClusterResource
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 29, 2016 at 12:53 am
A separate service account for each service is of course the best practice for securing your SQL server services.
However, with Availability Groups, all replicas that participate in a group with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 29, 2016 at 12:48 am
Igor Micev (8/19/2016)
I have a two node cluster. Let's say N1 is the active node and N2 is the idle one (UP in the cluster manager). I want to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2016 at 5:38 am
Eric M Russell (7/20/2016)
dndaughtery (7/20/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2016 at 5:34 am
Viewing 15 posts - 1,156 through 1,170 (of 9,244 total)