SqlServer-QA.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 of possible passwords. When password complexity policy is enforced and password expiration ...

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. Before we go to know how you can lockdown or know the steps, I would like to visit few leads on ...

As January 2008 almost getting finished that means 1 month in 2008 is reduced that brings the date to get RTM for SQL Server 2008. Before that the users (DBAs, Developers & Analysts) must get knowledge in making best use of SQL Server 2008 features within their platform. As we blogged earlier about VirtualTraining series for SQL Server 2008, ...

How do you define the terms ''Performance Monitoring''? What is your baseline & benchmarks? Have you ever used PERFMON (SYSMON) & PROFILER for serious performance issues within your SQL Server environment? The answer may be not 'yes' for all the questions above, in general getting know more about performance monitoring methods is not ...

Security, whether it is for your home or systems you have to be very careful! Ed Gibson, Chief Cyber Security Advisor from Microsoft has articulated very nice article that will talk more about these aspects, we have had a brief meeting with Ed when I was at Microsoft TVP during SQLBits conference. You’ve seen it, read it, heard it so many ...

What is your criteria on assigning ports to SQL Server? Are you leaving them to default 1433? Is your SQL Server is exposed to Internet or any external sources where there is a chance to produce mass attach or run code injection? Every DBA should give a review about these 3 points on the terms of security, many clients I attend to solve the ...

Here comes another instalment of SQL Server 2008 for the CTP fans.   The SQL Server 2008 November CTP has been released to the connect.microsoft.com website and is available for download here.  One of the improvements in this build is the ability to persist Lookup reference data and use non-OLEDB sources for ...

Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible). Then it comes what kind of practice you should deploy in order to obtain the ...

Continuing on the MAX WORKER THREADS topic from ThisBlog I have been asked about method of calculating the amount of system resources that will be used when the setting is increased to 500 from 255 (default). Well, as one of the best practices you must test the implications and usage in hiking such a value that will affect the whole server ...

This is not SQL Server related, more kind of Business Continuity related!  What's the best email management system for your business? What system is the most effective with virtually no downtime and is also easy to manage? Read this white paper to find out. Osterman Research surveyed organizations using Barracuda Spam Firewall, GFI Mail ...