Perry Whittle

Forum Replies Created

Viewing 15 posts - 901 through 915 (of 9,244 total)

RE: SQL Patching with powershell

Srl832 - Wednesday, March 1, 2017 11:14 AM
Hi Perry,
I couldn't figure out how to post formatted code alongside my question. Thanks for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

March 2, 2017 at 7:22 am

#1931171
RE: Can you set up AlwaysOn between two different clusters?

JP10 - Wednesday, March 1, 2017 10:23 AM
Grant Fritchey - Wednesday, March 1, 2017 3:58 AM
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

March 2, 2017 at 6:49 am

#1931161
RE: RDP into SQL server BAD or not

Phil Parkin - Wednesday, March 1, 2017 10:15 AM
Perry Whittle - Wednesday, March 1, 2017 10:05 AM
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

March 2, 2017 at 6:44 am

#1931157
RE: Windows Authenticaion vs. Mixed Mode

bmg002 - Wednesday, March 1, 2017 8:55 AM
We run mixed mode where I work mostly because in the even that something horrible...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

March 1, 2017 at 10:10 am

#1931022
RE: SQL Server 2014 Patching (on Cumulatives updates) and Rolling Updates - Need advice

the rational is simple, whilst the patches are applied and the instance is in upgrade mode, you don't need other factors muddying the waters.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

March 1, 2017 at 10:07 am

#1931021
RE: RDP into SQL server BAD or not

Lynn Pettis - Wednesday, March 1, 2017 9:45 AM
Most servers I have worked with only have 2 management RDP sessions
Yes, this...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

March 1, 2017 at 10:05 am

#1931020
RE: Windows Authenticaion vs. Mixed Mode

one of the primary reasons for separating databases and logins to a separate instance is where you have different security requirements. So, yes it is completely valid in your case
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

March 1, 2017 at 8:55 am

#1930994
RE: RDP into SQL server BAD or not

GilaMonster - Wednesday, March 1, 2017 5:43 AM
Perry Whittle - Wednesday, March 1, 2017 4:47 AM
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

March 1, 2017 at 8:50 am

#1930992
RE: RDP into SQL server BAD or not

John Mitchell-245523 - Wednesday, March 1, 2017 4:41 AM
Don't forget there are only two RDP connections to each server
Unless the server is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

March 1, 2017 at 4:47 am

#1930927
RE: Change sql server collation

WhiteLotus - Tuesday, February 28, 2017 6:12 PM
Hi Guys ..
I would like to change sql server collation . Can I just reinstall...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

March 1, 2017 at 4:28 am

#1930923
RE: SQL Server 2014 Patching (on Cumulatives updates) and Rolling Updates - Need advice

better to control this yourself, suspend data movement at the primary, apply patches and resume data movement
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

March 1, 2017 at 4:19 am

#1930921
RE: Can you set up AlwaysOn between two different clusters?

Grant Fritchey - Wednesday, March 1, 2017 3:58 AM
Can you have an availability group across two different failover clusters? Yes.
The issue is,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

March 1, 2017 at 4:17 am

#1930920
RE: Process to Compress Existing Table and it's Indexes

dont blindly compress tables and indexes, especially tables that are write intensive. It's more suitable for static tables
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

March 1, 2017 at 4:10 am

#1930919
RE: RDP into SQL server BAD or not

generally it's bad practice, this should be carried out in a separate environment
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

March 1, 2017 at 4:07 am

#1930917
RE: Moving 2 TB ( 600 databases ) from 32 bit SQL Server 2008 R2 to 64 bit SQL Server 2014 from Friday night to Sunday Evening

I would probably be inclined to offline the databases on the source and copy the database files to the target and then attach the databases at the target
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉

March 1, 2017 at 4:06 am

#1930915

Viewing 15 posts - 901 through 915 (of 9,244 total)