Browse by Tags

All Tags » sql server   (RSS)
CLR Stored Procedures - handling security on SQL Server side
24 July 08 01:52 AM | SQL Master | 2 Comments   
Ok this is not new to say you can write stored procedures in any language to manage them in SQL Server, as 2005 version has started this CLR integration functionality that is exposed in an assembly called system.data.dll, which is part of the .NET Framework. Read More...
Microsoft Security Bulletin Summary for July 2008 - what is it now?
09 July 08 01:07 AM | SQL Master | 2 Comments   
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 Read More...
SQL Server: PERFMON counters to identify server utilization data
18 June 08 05:21 AM | satyaskj | 2 Comments   
Recently I have been involved to carry over an assesment of server utilization on the SQL estate farm (nearly 150+) instances, as it stands it is not an easy job to obtain the results when you have no influence on accessing required information on a shared Read More...
SQL Server - Precision Performance techniques using RML Utilities
09 June 08 05:50 AM | SQL Master | 2 Comments   
As a DBA, you probably often find yourself striving or struggling to improve the performance of SQL Server instance queries (might be smaller or complex ones). By default in order to get further analysis on the system's performance you need to perform Read More...
SQL Injection attacks - don't forget to visit guidance information from Microsoft
31 May 08 01:59 PM | SQL Master | 2 Comments   
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 security-related Read More...
SQL Server 2005 Connectivity, Security policies & Network protocols: simple practice to follow, after installation?
23 May 08 01:44 AM | SQL Master | 2 Comments   
Secured by default, secured by design is the buzzword and catchy stuff for any Enterprise IT administrators. Then it comes about standards and policies to follow such as ISO , with the recent threats (last 10 years) and vulnerabilities within IT world Read More...
SQL Server Performance issues with Fragmentation and heavy usage of TEMPDB?
15 May 08 01:59 AM | SQL Master | 2 Comments   
Whenever a performance issue occurs on the SQL Server database best option for diagnosing and troubleshooting common problems by using publicly available tools such as Profiler, System Monitor (Perfmon), and Dynamic Management Views (DMVs) in SQL Server Read More...
SQL Server - Kill a KILLED/ROLLBACK status process without restarting Server or SQL services?
06 May 08 01:02 AM | SQL Master | 2 Comments   
This may be the typical situation within your database environment where the you might have killed a SPID (Process) that has been running for long time, without knowing the ROLLBACK operations for such processes. Say if you are executing a stored procedure Read More...
SQL Server 2005 Login Security - CHECK_POLICY and CHECK_EXPIRATION setting, how it affects the password policy?
30 April 08 01:53 AM | SQL Master | 2 Comments   
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 Read More...
SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?
25 April 08 01:30 AM | SQL Master | 2 Comments   
In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases Read More...
SQL Server latch waits - index contention & performance issues how DMVs can help you to get information?
17 April 08 03:06 AM | SQL Master | 2 Comments   
What kind of performance issues you see on day-to-day basis within your environment? The following elements are important factors that can add fuel to the fire (problem): Faulty hardware • Hardware that is not configured correctly • Firmware settings Read More...
SQL Server problem: Excessive paging and memory bottlenecks
16 April 08 12:02 AM | SQL Master | 2 Comments   
Paging and Memory bottlenecks are quite common when a performance problem strikes on your SQL Server. As we discussed here previously and relevant blog posts below talks about them: Paging and Available Memory for Operating sysem, what you need to know? Read More...
SQL Server 2005 Scalability and Performance - recommended limit on number of instances on a clustered environment?
04 April 08 02:48 AM | SQL Master | 3 Comments   
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, Read More...
SQL Server Memory - what's your method on Configuration and Troubleshooting Issues
01 April 08 02:49 AM | SQL Master | 5 Comments   
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 Read More...
What's your practice on Disk Defragmentation methods - specific to data file and indexes drives?
26 March 08 01:01 AM | SQL Master | 5 Comments   
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 Read More...
More Posts Next page »