1) Should a database be owned by an account with no privileges? 1b) If so should this account be a domain account? 1c) If so, should this account...
thanks frank - is there a best practices document for sql server 2008 R2, as i can't find one - the one i had has disappeared! i have found the 2008...
What are shared stored procedures and where are theses stored? Someone told me that when you run a copy database wizard shared stored procedures are...
Should we ever set the PageVerify setting to TornPageDetection? 1) Does CHECKSUM do everything and more that TornPageDetection? 2) Someone told me...
Can you run Powershell scripts on Unix?
Can anyone help me understand how many always on groups can be stored, and where? The trainer we had didn't really know SQL 2012 and confused the...
Does anyone have a link to a whitepaper for SQL 2012 best practices and recommended configuration? I found one for 2008 but there doesn't appear to...
Can Always-On groups be configured on a domain controller? I can't find any refernece online for thsi - if anyone can send a link confirming this -...
I am assuming this can't be done, but someone asked this so I was wondering why they asked this question!
What are the requirements if I build a cluster with more than 8 nodes? Operating system, do I need at least windows 2008? SQL Server version, what...
Does anyone know what a (DHCP) lease timeout is? I was informed this may prevent an application connection to a SQL Server (database).
Can anyone confirm the above question, and if so, why? I heard this once but want to confirm if this is true and why...
Is there any easy way to simulate disk corruption? I want to test integrity checks, database recovery for a suspect database, and rebuilding a...
Can the transaction log of a principal database in a database mirror partnership be shrunk without breaking the mirroring?
1) you have to have a master key created for TDE to work, however, can any master key be created on a SQL instance for any database to be encrypted...
1) how do you extend a database data file onto another drive, when the drive is running out of disk space? i heard there is a way of doing this via a...
After reading about TDE and restoring an encrypted database on another server, can anyone please answer the following?: 1) When I restore an...
Hi Shehap. Thanks for your reply. I have a witness setup. The database is running on the new principle (was mirror before server crash). Can you...
I am rebuilding one node which usually has the principle database on. This means I have to re-install SQL and setup Database mirroring. The database...
how can i temporarily stop tempdb usage on alive server, so i can shrink the tempdb files, and not restart the sql server service? tempdb is used a...
Separate names with a comma.
