Viewing 15 posts - 706 through 720 (of 2,496 total)
My understanding is that for a virtual server, you only need a licence for the number of cores that will be running SQL Server.
By default, SQL Server is set to...
October 16, 2012 at 5:24 am
Use a secure delete program to wipe those files off disk
If you do this, make sure you use a secure delete process that is compatible with the storage you are...
October 16, 2012 at 5:08 am
Have you set static ports for your named instances?
The default instance will want to use 1433 unless you tell it to use a different port. But if...
October 12, 2012 at 8:08 am
SQL Server will always write to the log. This is needed because if the INSERT command fails, SQL Server needs to put the database back too the state it...
October 12, 2012 at 7:53 am
The /PAE boot switch in Windows enables the code you need. If you have hardware data protection turned on this also enables the PAE functionality so you do not...
October 2, 2012 at 4:29 am
As far as a cluster is concerned, you are limited to Active/Passive for a given database.
If you want to have multiple instances accessing the same database, then the two simplest...
October 2, 2012 at 2:32 am
Your Active/Active scenario will not work. There is an inherent restriction with SQL Server that means a given SQL service must have exclusive access to the database file.
If somehow...
October 1, 2012 at 5:28 am
There is also the risk of people being added to an AD group and inadvertently being granted access to data they should not have access to.
Security best practice is that...
September 28, 2012 at 8:58 am
There are no performance or integrity advantages in moving the locations of Master, Model, and MSSystemResource databases.
If you make heavy use of msdb then consider moving its files to where...
September 21, 2012 at 6:47 am
You might be interested in SQL FineBuild. This can install SQL standard builds on any OS from XP onwards. It can definitely cope with the differences between W2008...
September 7, 2012 at 5:39 am
To decrypt your 'encrypted' SPs and views, google 'sql server decrypt stored procedure' and take your pick.
You might want to challenge why the daatbase objects are encrypted. It offers...
September 5, 2012 at 3:02 am
If you have the opportunity to do SQL 2012 BI training then go for it. The BI stack in SQL 2012 is very significantly better than the SQL 2008...
September 4, 2012 at 2:51 am
What security context is running the xp_delete_file? Is the shared drive visible to that security context?
August 28, 2012 at 3:12 am
A lot of people seem to be writing as though 'the cloud' is some homogenous entity that exists somewhere just this side of the horizon. This makes it easy...
August 21, 2012 at 3:23 am
Do you have the 'Windows Internal Database' installed? The internal database is a special instance of SQL Server.
August 20, 2012 at 7:02 am
Viewing 15 posts - 706 through 720 (of 2,496 total)