Viewing 15 posts - 496 through 510 (of 2,496 total)
How do you plan to access your database engine in the cloud?
If you go down the IaaS route then you install SQL on a VM and everything is...
February 17, 2014 at 3:56 am
SQL 2012 Enterprise is only licensed by Core. If you think you are using CAL licenses with EE then you may not be correctly licensed.
SQL 2013 BI and SQL...
February 17, 2014 at 3:33 am
The network resource issue and the Kerberos issue are probably not related, and in any case the thing that is killing your cluster install is the network issue.
After your cluster...
February 12, 2014 at 4:47 am
A number of companies package SQL Express with their product, and run the SQL install during the product install. In most situations it is best to install a named...
February 11, 2014 at 8:47 am
Windows 2012 and Windows 2012 R2 require their own source media for the .Net 3 install. Even though Microsoft has very large amount of software currently in support that...
February 10, 2014 at 10:00 am
It should be OK, but as you said, you need to test...
February 10, 2014 at 9:37 am
The most recent fix I know for SQL 2005 is KB 2716427 which is a security fix that is applied to SP4. It is cumulative to all previous fixes...
February 10, 2014 at 7:40 am
There are LOTS of components in AWS. If you try to learn everything before you use anything, it is a very steep learning curve. My advice is to...
February 10, 2014 at 6:01 am
The SP installer can update the clustered components on all nodes, plus the non-clustered components on the node on which it is run, all within a single run of the...
February 10, 2014 at 5:47 am
If you install your own SQL instance then you can use transactional replication.
As part of our migration from co-lo datacentres to AWS, we had SQL P2P replication running between the...
February 10, 2014 at 5:14 am
Full Text catalogues created by SQL Server are an intrinsic part of the database. If you do anything to these files without letting SQL Server know then the database...
January 28, 2014 at 3:49 am
Why are you planning to upgrade only to SQL 2008 R2?
Apart from SSIS, there are very few changes between SQL 2008 and SQL 2012 or even SQL 2014. The...
January 28, 2014 at 3:42 am
It is always good to ask your assistant if they know the answer, it is quicker than asking in any forum, and Google is the most knowledgeable assistant I know.
January 28, 2014 at 3:04 am
One of your core best practices should be to review your current best practices with regards to the evolution of your technology
Derek's post is full of sound advice, and what...
January 27, 2014 at 3:41 am
The application should be calling on prived stored procedures to do the job safely.
+1
January 21, 2014 at 2:46 am
Viewing 15 posts - 496 through 510 (of 2,496 total)