|
Why SQL Server Security has been so much important!! |
 |
 |
 |
|
Written by Hemantgiri S. Goswami
|
|
Wednesday, 29 October 2008 23:39 |
|
Security! This is the word comes in mind of every concerned person when it comes to store, access and share the data and database or database server. At times when applications are run in the geographically restricted area, there were less chance of its exploitation and with spread of internet and the availability of application over the internet security of data, databases and database servers has become vital. Why SQL Server Security has been so much important!!
Well, for every organization or institute or company or government has there data that is vital to them, and not need to be accessed by the authorized person or entity only. And that is vital to set some security standards for such a critical data so that you can prevent your data as much as you can with proper security mechanism and set of standards within organization and in your scope for MS SQL Server Security. |
|
Read more...
|
|
|
SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization |
|
|
|
|
Written by Ola Hallengren
|
|
Wednesday, 06 August 2008 18:47 |
|
Here is a ready to use solution for all your needs for automated database backup, integrity check and index optimization in SQL Server 2005 and SQL Server 2008. The solution is based on stored procedures, functions, sqlcmd and SQL Server Agent jobs. The documentation and the script is available for download.
|
|
Last Updated ( Monday, 23 November 2009 23:09 )
|
|
Read more...
|
|
Written by Deepak Kumar
|
|
Tuesday, 11 April 2006 20:45 |
|
Decided to start up on the DBA ladder so what’s better than starting of with monitoring table’s health using ‘DBCC Showcontig’. Each time using the insert, update and delete statement increases the fragmentation in tables. |
|
Read more...
|
|
|
SQL Server 2008 RTM available for download!! |
|
|
|
|
Written by Deepak Kumar
|
|
Thursday, 07 August 2008 16:11 |
Microsoft officials announced at TechEd South Africa on August 6 that SQL Server 2008 has been released to manufacturing. SQL Server 2008 is available as of today for MSDN and TechNet subscribers and will be available for evaluation download on Aug 7th.
SQL Server 2008 Developer (x86, x64, ia64)
SQL Server 2008 Enterprise (x86, x64, ia64)
SQL Server 2008 Standard (x86, x64)
SQL Server 2008 Web (x86, x64)
SQL Server 2008 Workgroup (x86, x64) |
|
How long does a SP stay in the cache? |
|
|
|
|
Written by Deepak Kumar
|
|
Saturday, 02 September 2006 22:25 |
|
As a SQL Database Developer or Administrator you must be eager to know how long does a Stored procedure execution plan stay in the cache? On what basis and parameters MS SQL Server decide age of an execution plan to reside in cache?
Well the answer is, it is based on the cost factor and number of reference to that object in cache.
Let’s see how it goes in details: |
|
Read more...
|
|
|
|
|
<< Start < Prev 1 2 Next > End >>
|
|
Page 1 of 2 |
