Browse by Tags

All Tags » best practices » sql server (RSS)
Quick tips & tricks on fine tuning performance problem on a SQL Server instance.
Published 6 October 8 4:51 AM | SqlServer-QA.net
Few months ago I had an excellent opportunity to learn and share the knowledge within SQL Server performance tuning, Tech-Ed Online talks [remember Tech-ed Online Panel: Leveraging ... ]. Same in the series Amit Bansal, SQL Server MVP from India and myself...
Filed under: , , , , , , , ,
How to write or deploy Secure Transact-SQL - gotchas & tips?
Published 18 September 8 2:16 AM | SqlServer-QA.net
I have been thiking to write this topic in this blog since last 3 months, before that I have done fair amount of work to get you sensible & helpful resource in securing your SQL Server environment. This was the question asked by one of the user when...
Filed under: , , , , , , ,
SQL Server 2000 and 2005 versions: set databae option Page_Verify Option to CheckSum, to be or not to be?
Published 4 September 8 3:0 AM | SSQA.net
Recently we had a discussion at work place about setting up the PAGE_VERIFY option to CHECKSUM for few databases on one of the SQL Server 2005 instance (dedicated) that is being used extensively by an application that has very limited maintenance window...
Filed under: , , , , , , , ,
MSDN & Technet webcast for SQL Server 2008 and SQL Server Compact 3.5 versions
Published 3 September 8 4:4 PM | SSQA.net
TechNet Webcast: SQL Server 2008 (Part 3 of 3): Integrate Growing Data Volumes (Level 300) Attend this session to learn how to integrate growing volumes of data with the new enhancements in Microsoft SQL Server 2008. We cover new technologies, like Change...
Filed under: , , , , , , , ,
Technical Rollup email pertaining to SQL Server, documents & guidelines
Published 3 September 8 3:59 AM | SSQA.net
Here is the list of information which is a Technical Rollup email we receive from TRM team. The list is ongoing and I have outlined the important ones that I feel and fits for 'generic' SQL Server environment. Make sure to review, download, test...
Filed under: , , , ,
SQL Server data and log files initialization, think multiple files, backup & restore performance!
Published 25 July 8 6:1 AM | SSQA.net
Whenever you perform a database creation, add a data or log file to database, AUTOGROW process is intiated or restore of database will trigger the file initialization if that is created afresh. In addition to this when you talk about files intialization...
Filed under: , , , , , , , , , ,
Cumulative Update 8 package for SQL Server 2005 Service Pack2
Published 16 July 8 4:50 AM | SSQA.net
I felt like somehow I missed to post the availability of Cumulative Update package releases here and referring the last CU7_Update package blogpost now we have CU8 available for download if the specified problem occurs in your platform as per the KBA...
Filed under: , , , , , ,
DTS Packages migration webinar - get tips and tricks from a MVP
Published 15 July 8 10:44 AM | SSQA.net
Brian Kinight is well known SQL Server Professional in the community, every user will know about SQL Server Central website which was founded by him. Join Brian to discuss the strategies of upgrading DTS packages to SQL Server Integration Services (SSIS...
Filed under: , , , , , ,
SQLKnowHow - gear up for exclusive training from professionals
Published 8 July 8 8:27 AM | SSQA.net
SQLKnowHow is the new organisation that is focused on training services based on SQL Server. In this regard they have lined up very interesting list of events in coming months, it will be a great time for the SQL Server Users in United Kingdom to grab...
Filed under: , , , , , , , ,
SQL Server Technical Rollup July 2008 - Important & Interested links for you
Published 7 July 8 2:51 AM | SSQA.net
As you may be aware all the Technical information roll-up on MSDN & Technet is sent out in email format, in this regard I wanted to share the important and interested links for you on SQL Server arena. Downloads Source Code Analyzer for SQL Injection...
Filed under: , , , , , ,
Why Do People Bash Microsoft?
Published 30 May 8 3:27 AM | SSQA.net
I found an interesting article by Kalen Delaney aka SQL Goddess (as I call) about a topic stating ' why do people bash Microsoft? ' The article was printed in SQL Server Magazine: Last week, I read a post from one of my colleagues, which shared...
Filed under: , , , , ,
SQL Server Cumulative Update uninstallation fiasco. Dude, can I remove SQL Server setup files?
Published 28 May 8 3:10 AM | SSQA.net
We have been struggling to uninstall the Cumulative Update package 7 on a development SQL Server! As it is an important aspect of installation to rollback or to have a backout plan tested if you are performing any kind of installation against your Production...
Filed under: , , , , ,
SQL Server 2005 Connectivity, Security policies & Network protocols: simple practice to follow, after installation?
Published 23 May 8 3:44 AM | SSQA.net
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...
Filed under: , , , , , ,
Install cumulative update package 7 on a SQL Server Cluster?
Published 22 May 8 3:3 AM | SSQA.net
IN continuation to the post Rollback_of_CumulativeUpdate-hotfix-ServicePack I was asked about any procedure or steps on installing Cumulative update package 7 for SQL Server 2005 Service Pack 2 on Active node SQL 2005 cluster. The simple answer is all...
Filed under: , , , , , ,
Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process
Published 21 May 8 4:20 AM | SSQA.net
The main difference betwen 32 bit and 64 bit server is Memory, you may be aware about 'Lock Page in memory' privilege to be granted to the SQL Server service accout within 32 bit based servers. This is a operating system based privilege that is...
Filed under: , , , , , , ,
SQL Server Service Pack or Hotfix patch or Cumulative Update: do not attempt Windows System Restore as a backout plan?
Published 19 May 8 4:28 AM | SSQA.net
To cut the long story short, during a recent implementation of Cumulative Update 6 and 7 on a particular 'application domain' server we have had major application issues due to a mix up of application code & these SQL cumulative update fixes...
Filed under: , , , , , , ,
SQL Server 2005 Failover Clustering on Windows Server 2008 - webcast
Published 16 May 8 9:13 PM | SSQA.net
Windows Server 2008 is on full fledged wave now after it has been launched in February and it is obvious that many questions will be flying around about supportability & manageability for existing SQL Server versions such as 2005 at the moment. Think...
Filed under: , , , , ,
SQL Server Performance issues with Fragmentation and heavy usage of TEMPDB?
Published 15 May 8 3:59 AM | SSQA.net
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...
Filed under: , , , , , , ,
SQL Server 2005 Database Mirroring choosing optimum value for auto-failover timeout?
Published 12 May 8 4:25 AM | SSQA.net
Choosing a better plan to reduce outage to your database application is a beginner to provide High Availability to your application, irrespective to database or server. You may be aware that SQL Server 2005 version provides the database mirroring which...
Filed under: , , , , , , , ,
SQL Server - Deploying Database Mirroring and Clustering parallely on same machine, performance and failover support?
Published 8 May 8 3:42 AM | SSQA.net
When you think about high availability in SQL Server then you would think about Clustering and in addition to this within 2005 version we have Database Mirroring too that can provide automated failover support to your database server applications. By...
Filed under: , , , , , , , , , ,
More Posts Next page »