SQL Server Security, Performance & Tuning (SSQA.net)

CLR Stored Procedures - handling security on SQL Server side

SQL Master — Thu, 24 Jul 2008 08:52:00 GMT

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?

SQL Master — Wed, 09 Jul 2008 08:07:00 GMT

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

satyaskj — Wed, 18 Jun 2008 12:21:00 GMT

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

SQL Master — Mon, 09 Jun 2008 12:50:00 GMT

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

SQL Master — Sat, 31 May 2008 20:59:00 GMT

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?

SQL Master — Fri, 23 May 2008 08:44:00 GMT

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?

SQL Master — Thu, 15 May 2008 08:59:00 GMT

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?

SQL Master — Tue, 06 May 2008 08:02:00 GMT

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?

SQL Master — Wed, 30 Apr 2008 08:53:00 GMT

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?

SQL Master — Fri, 25 Apr 2008 08:30:00 GMT

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?

SQL Master — Thu, 17 Apr 2008 10:06:00 GMT

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

SQL Master — Wed, 16 Apr 2008 07:02:00 GMT

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?

SQL Master — Fri, 04 Apr 2008 09:48:00 GMT

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

SQL Master — Tue, 01 Apr 2008 09:49:00 GMT

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?

SQL Master — Wed, 26 Mar 2008 08:01:00 GMT

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)