|
|
Browse by Tags
All Tags » best practice ( RSS)
-
|
What is the most required task when a DBA required to perform upgrade from previous versions? Complete understanding of the databases that are required to upgrade. Technical reference of upgrade path from previous version to the current one. Testing of...
|
-
|
First one in the series of SQL Server 2008 version, here it comes Cumulative Update package 1! What kind of fixtures are available in this CU1 package? Cumulative Update 1 contains hotfixes for the Microsoft SQL Server 2008 issues that have been fixed...
|
-
|
I believe it has been a while that we have seen the security hotfix from Microsoft Security team on SQL Server (alone). The latest security bulletin has announced important security patches that are related to SQL Server in addition to Windows operating...
|
-
|
When you have your business activities on the Internet then you have a major requirement to provide Business Continuity in finding the suitable/sustainable service provider. So I believe there are few key factors you need to consider such as the location...
|
-
|
In the past week SQL Server 2008 RC0 has been made available for early download by MSDN and TechNet Plus subscribers. RC0 is the final step before SQL Server 2008 RTMs in Q3 of this year. After logging into their respective accounts, subscribers can view...
|
-
|
Within the IT organisations it has been a huge expansion of increased challenges with regard to number of office locations and keep up the data consistent across the Enterprise. Travelling around the globe is a olden day myth and now even by sitting at...
|
-
|
One of the biggest threats in IT industry & Database world is unprecedented attacks aka most commonly termed as 'SQL injection'. There is no doubt that biggest database vendors, one of them as Microsoft so far providing recommendations regarding...
|
-
|
It may not be a hardcore requirement on day-to-day basis to drop all tables, views and stored procedures from a SQL Server database within your environment, but it will be handy to have such a code at your end when such task is required. There are 2 ways...
|
-
|
I'm not going to shoot any questions to Microsoft about RTM release for SQL Server 2008, as it was made it clear from The Data Platform Insider blog post as: Extract: "Over the coming months, customers and partners can look forward to significant...
|
-
|
Adding password complexity and password expiration to SQL Server logins is one of best feature I quote for SQL Server version 2005 onwards, similarly such password complexity policies are designed to deter brute force attacks by increasing the number...
|
-
|
In continuaton to UK User Group conference (2 day) in Microsoft Campus, Thames Valley Park Reading here is my presentation to download that was delivered on 09th April 2008. Appreciate your feedback....( read more )
|
-
|
This is a very tricky question and hard to stick to 1 or few solutions as answer, it depends! Overall the say is if there isn’t any resource contention (from your pre-installation testing & analysis) and there is enough of each resource to go around...
|
-
|
Memory - an important aspect of system performance within a RDBMS platform, not specific to a database product or application. Coming to Microsoft related products such as Windows Server and SQL Server so on, various resources available on web such as...
|
-
|
Fragmentation is dearest friend of database when you need to deal with Performance, so by using the DBCC statements and other methods here you can deal the database level fragmentation, what about the physical level fragmentation? So what is the best...
|
-
|
Another FAQ within newsgroups & forums that will SQL Server Clustering supports load balancing? It is quite common for a newbie to say and look at Clustering configuration such as Active-Active where you have n+1 nodes as a serving instances, the...
|
More Posts Next page »
|
|