Browse by Tags

Microsoft Security Bulletin Summary for July 2008 - what is it now?

Published 9 July 8 3:7 AM | SSQA.net

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

Filed under: sql server, security, hotfix, service pack, best practice, vulnerability, guidance

Internet Database based Services find a suitable service provider

Published 2 July 8 3:31 AM | SSQA.net

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

Filed under: sql server, best practice, isp, asp, service provider

SQL Server 2008 Release Candidate - public download is available now.

Published 10 June 8 5:36 AM | SSQA.net

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

Filed under: sql server, download, documentation, ctp, best practice, release candidate, rc0

Achieving 99.99% Business Continuity with SQL Server tools

Published 6 June 8 2:39 AM | SSQA.net

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

Filed under: business continuity, sql server, high availability, version, 2008, best practice

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

Published 31 May 8 3:59 PM | SSQA.net

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

Filed under: sql server, blogs, security, best practice, injection, authentication, attacks, reference

How to drop all tables, all views, and all stored procedures from a SQL Server 2005 Database?

Published 20 May 8 3:12 AM | SSQA.net

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

Filed under: sql server, backup, table, drop, stored procedure, tsql, best practice, views

SQL Server 2008 features and getting through CTP, RC, RTM. Are we there yet?

Published 14 May 8 3:23 AM | SSQA.net

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

Filed under: sql server, performance, blogs, ssms, dba, dmf, best practice, new features, resource governor, policy based framework

SQL Server 2005 Login Security - CHECK_POLICY and CHECK_EXPIRATION setting, how it affects the password policy?

Published 30 April 8 3:53 AM | SSQA.net

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

Filed under: sql server, microsoft, security, feature, password, best practice, trustworthy, computing, logins, policies, settings, check_policy, check_expiration

SQL Server 2008 - What's new for IT Pro community [UK Usergroup conference]

Published 9 April 8 10:28 AM | SSQA.net

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 ) Read More...

Filed under: sql server, community, 2008, enterprise, best practice, whatsnew, conference, usergroup, itpro

SQL Server 2005 Scalability and Performance - recommended limit on number of instances on a clustered environment?

Published 4 April 8 4:48 AM | SSQA.net

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

Filed under: sql server, memory, maintenance plan, i/o, clustered, best practice, monitoring, resources, configuration, performance monitoring, contention

SQL Server Memory - what's your method on Configuration and Troubleshooting Issues

Published 1 April 8 4:49 AM | SSQA.net

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

Filed under: sql server, performance, memory, cache, disk space, troubleshoot, system, best practice, raid, hardware, monitoring, configuration, baseline

What's your practice on Disk Defragmentation methods - specific to data file and indexes drives?

Published 26 March 8 3:1 AM | SSQA.net

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

Filed under: sql server, performance, blogs, dbcc, disk space, object, file, best practice, monitoring, showcontig, defrag, diskkeeper

SQL Server 2005: Clustering FAQ is Active/Active a load balancing solution?

Published 29 February 8 4:4 AM | SSQA.net

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

Filed under: sql server, performance, blogs, environment, clustered, clustering, san, best practice, monitoring, benchmarking

Best Practices for Measuring and Managing Today's Complex Messaging Environment

Published 27 February 8 8:26 PM | SSQA.net

Like SQL Server Data, email is also an important aspect of day-to-day business life, more or less it is a business-critical communication tool, and downtime can be disastrous for your company. As like to the Disaster Recovery for your data, is your email...

Filed under: business continuity, sql server, backup, disaster recovery, best practice, communication, email, messaging

SQL Server 2008 Resource Governor FAQ

Published 25 February 8 1:36 AM | SSQA.net

Bottlenecks aka locking & blocking is a quite common scenario within a RDBMS platform, that too SQL Server is not an exception at all. With an access to shared resources causes bottlenecks and demands on shared resources cause poor response time and...

Filed under: sql server, performance, memory, dba, i/o, disk, 2008, development, cpu, best practice, capture, resource governor

SQL Server Lockdown - Step by Step procedure

Published 13 February 8 2:31 AM | SSQA.net

Do you want to lockdown your SQL Server environment? Hope you dont'! Though it is not a good practice or recommendation to perform, but will atleast prove how far your SQL Server environment has securit compliance as per the industry best practices...

Filed under: sql server, microsoft, security, tools, article, sa, procedure, best practice, downloads, bpa, lock down

SQL Server Performance - what it takes for a newbie DBA in resolving performance issues?

Published 5 February 8 2:57 AM | SSQA.net

SQL Server Performance Tuning, sounds familiar on a DBA perspective and though it sounds like an easy words but when you start analyzing the problem it is far deeper inside. When you refer to the web resources such as forums/newsgroups then a common question...

Filed under: sql server, performance, blogs, blocking, security, query, best practice, index plan, sql server central, newsgroups, forums

SQL Server 2008 Change Data Capture - Do you really want to log all the data activities such as audit trails?

Published 1 February 8 9:50 AM | SSQA.net

In continuing from the series of Change-Data-Capture tags on this site I have been testing through this CDC feature on my test environment, which has proved fruitful results (to some extent). But the in the real world scenario do you really need to log...

Filed under: sql server, users, ctp, environment, cdc, best practice, testing, triggers, new features, audit trial, change data capture, stored procedures

Unattended installation of application on multiple sites by using sa password with a symmetric key, is it possible in SQL Server?

Published 29 January 8 1:36 AM | SSQA.net

The newest ranch of Security - trust worthy features in SQL Server 2005 usage of symmetric keys has an important role. Always the document suggests to use Windows Authentication of security purpose and better control of user/security management, but when...

Filed under: application, sql server, security, best practice, sql authentication, sa password, symmettric keys, store, windows authentication

Best way to deploy SQL Server 2005 with SAN

Published 28 January 8 2:1 AM | SSQA.net

If it is a first time you are deploying the SQL Server 2005 on a SAN, then there are few things you need to be considered that will be raised by installations that are either deploying SQL Server for the first time or are upgrading to SAN from direct...

Filed under: sql server, performance, tools, 2005, san, best practice, raid, hardware, configuration, benchmarking, downloads, iometer, deployment, sqlio