sql server - SQL Server Knowledge Sharing Network (SqlServer-qa.net)

Re-configuring RAID on the server - a detailed approach and best practices

Reconfiguring the hardware or software on the server is a big job and you wouldn't attempt to perform the task on day-to-day basis or even not in your life time. Here is the detailed steps that are involved in this mammoth task refer to this post...

Posted Feb 19 2009, 12:58 PM by satya with | with no comments

Filed under: sql server, configuration, code, raid, hardware

Is there anyway to find out when a table was dropped, and by what user?

Here is another Frequently Asked Question in the forum to find out the damage that has happened in your SQL Server environment. To find out more on what has been referred review this Forum_Post link.

Posted Jan 07 2009, 10:25 AM by satya with | with 1 comment(s)

Filed under: sql server, permissions, drop, user, securq

Best Practices on Disk Defragmentation methods on a SQL Server - specific to data file and indexes drives?

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...

Posted Dec 23 2008, 12:16 PM by satya with | with no comments

Filed under: security, best practice, sql server, disk, database drive, tools, fragmentation

SQL Server stored procedure vulnerability heap buffer overrun in SQL Server, MSDE, and SQL Express

You may have seen the sp_replwriterovarbin - New SQL Server Injection-Based Attack Found vulerability about the new public reports of a vulnerability that could allow remote code execution on systems with supported editions of SQL Server 2000, 2005, 2005...

Posted Dec 23 2008, 12:14 PM by satya with | with no comments

Filed under: security, best practice, sql server, stored procedure, permissions, vulnerability, block

How to deal: "The EXECUTE permission was denied on the object 'sp_executesql', database 'mssqlsystemresource', schema 'sys'." issue

One of the TRUSTWORTHY features within SQL Server 2005 will be like when you are running a stored procedure with a dynamic execution query ( sp_executesql or EXECUTE), you may receive the following error message: Server Msg 229, Level 14, State 5, Line...

Posted Aug 11 2008, 12:13 PM by satya with | with 1 comment(s)

Filed under: dynamic sql, tsql, database, object, security, sql server

SQL Server 2008 RTM is released, its official now!

Microsoft press announces that SQL Server 2008 is available for users and as per PressRelease : . ..announced the release to manufacturing of Microsoft SQL Server 2008, the new version of the company’s acclaimed data management and business intelligence...

Posted Aug 07 2008, 09:11 AM by satya with | with no comments

Filed under: sql server, microsoft, rtm, release, community, 2008

SQL Server - How to return string values?

I found this interesting question within SSP forums: Is it possible to return only the upper case of a given string. For a string say, 'My name Is John Cramps' I should get the output as 'MIJC' I am using SQL Server 2005. Visit forum http...

Posted Jul 29 2008, 09:13 PM by satya with | with no comments

Filed under: sql server, tsql, values, string, code

SQL Injection attacks - don't forget to visit guidance information from Microsoft

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...

Posted Jun 01 2008, 12:23 AM by satya with | with no comments

Filed under: security, best practice, sql server, microsoft, authentication

3GB Memory & Windows Server 2003 Standard Edition - Interesting question & Valueable insight on resolution

This is the question: I am configuring a server with Windows Server 2003 Standard Edition and SQL Server 2000 Enterprise Edition. The server has 4GB memory. From what I have read the AWE/PAE switch only works with Advanced Server or Datacenter Editions...

Posted May 31 2008, 01:46 PM by satya with | with 2 comment(s)

Filed under: sql server, server, pae, windows 2003, configuration, 3gb

Refactoring Stored procedures on a SQL Server database?

I would like to refer this Interesting thread that talks about advantages you can take with Profile when you have a need of refactoring the database objects between old & new versions, useful tips on the post too.

Posted May 26 2008, 11:00 AM by satya with | with no comments

Filed under: sql server, schema, script, stored procedure

Best practices/Gotcha's when migrating 2k DB's to 2K5 box? (also 2K->2K)

Here is another interest forum post that will talk through the best practices, gotchas and FAQ when you are performing a database upgarde from SQL Server 2000 to 2005 version. Post link .

Posted May 25 2008, 04:56 AM by satya with | with no comments

Filed under: best practice, sql server, blogs, faq, gotchas, links, upgarde

SQL Server installation error 703 : An INternal read error occurred on media <path>, unable to load the installation information...

One of the forum user reported about an error they are getting when trying install SQL Server 2000. By default you need to have Administrator rights on the server where you are trying to install the SQL Server binaries, in this case the user has used...

Posted May 19 2008, 10:42 AM by satya with | with no comments

Filed under: sql server, installation, 703, error, media

SQL Server Performance issue - high value for Full Scans/sec?

One of the intersting post in forums and replies to them: I recently took a new position as the DBA for a web app company. Getting to understand the performance issues that are a major concern for the company I have started monitoring the servers. The...

Posted May 15 2008, 11:57 AM by satya with | with 1 comment(s)

Filed under: sql server, performance, forums, table, full scans, tempdb

SQL Server 32 bit and 64 bit, what is the major difference?

This is anothe FAQ within the forums about what is the major difference between 32 bit and 64 bit application, well the answer you get is Memory. I feel there is much more associated between them, follow this ForumDiscussion topic for more information...

Posted Mar 17 2008, 01:28 PM by satya with | with no comments

Filed under: sql server, 2005, performance, management, 2000, difference, 64 bit, memory, 32 bit

SQL Server multiple instances and resource utilization - best practices

A newbie or FAQ within Forums and Newsgroups that having multiple instances and how best to set the resources on the server such as memory, CPU etc. Should you configure each of the instances to use specific portions of the available Operating System...

Posted Mar 14 2008, 02:28 PM by satya with | with 2 comment(s)

Filed under: best practice, sql server, indexes, performance, management, multiple, clustering, instances, monitoring

SQL Server Knowledge Sharing Network (SqlServer-qa.net)

Browse by Tags