Other SQL Server Blogs around the Web

Browse by Tags

• 2005
• 2008
• 64-bit
• activex
• api
• beginner
• best practice
• best practices
• blocking
• blogs
• compatability
• computing
• cursor
• database
• dba
• documentation
• hardware
• heavy
• high cpu
• iis
• initialize
• kba
• management
• memory
• memory leak
• network
• oledb
• oltp
• performance
• platform
• pool
• protocol
• query
• queue
• replication
• reporting
• resource governor
• sa password
• sap
• security
• service pack
• small
• sql authentication
• sql server
• sqlnci
• stops
• store
• stored procedure
• symmettric keys
• table
• terminate
• tsql
• usage
• versioncontrol
• wait
• webcast
• websites
• windows authentication
• X64

• Control the database version - an important task for DBA!

  Do you need to control the database version? How often you document the changes of a database? I find it very difficult and helpless whenever I go to solve a database problem, hearing about they have no clue about database and its properties, sounds familiar... Posted Dec 09 2008, 01:37 AM by SqlServer-QA.net Filed under: sql server, database, dba, stored procedure, best practices, application, documentation, beginner, small, versioncontrol

• 64 bit computing configuration with SQL Server 2005 - what you can take-on?

  It has been a while in posting X64 related information here, so that comes now about configuration gotchas you may need, for a starter though. X64 computing platforms have become common installations now a days due to the hardware reduced costing and... Posted Apr 23 2008, 06:31 PM by SSQA.net Filed under: sql server, performance, X64, computing, hardware, application, sap, compatability, 64-bit

• See how Resource Governor can help you 'in action' in managing SQL Server resources?

  As you may be aware about new features within SQL Server 2008, one of the them is Resource Governor which is a feature than you can use to manage SQL Server workload and system resource consumption. It will enable you to specify limits on the amount of... Posted Feb 08 2008, 02:11 AM by SSQA.net Filed under: sql server, security, management, 2008, query, application, blogs, resource governor

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

  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... Posted Jan 29 2008, 01:36 AM by SSQA.net Filed under: sql server, security, best practice, application, sql authentication, store, sa password, windows authentication, symmettric keys

• FIX: The SQL Native Client OLE DB provider (SQLNCLI) leaks memory when you call the IRowsetFastLoad::Commit method in a SQL Server 2005-based application

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX... Posted Oct 21 2007, 12:54 PM by SSQA.net Filed under: sql server, memory, kba, application, oledb, sqlnci

• FIX: A memory leak occurs when you call the Initialize method and the Terminate method of the SQLDistribution object in a loop in an application that you develop by using Microsoft ActiveX replication controls in SQL Server 2005

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX... Posted Sep 24 2007, 01:02 PM by SSQA.net Filed under: sql server, performance, 2005, kba, replication, application, initialize, memory leak, activex, terminate

• Web Server: What’s New in IIS 7 for IT Pros

  So what's coming wth IIS7, the overview session will highlight the key points of interests for IT Pros in Internet Information Services version 7. IIS7 modularity increases security by allowing a reduced installation footprint and creation of specialized... Posted Sep 04 2007, 08:34 AM by SSQA.net Filed under: sql server, management, webcast, reporting, iis, application, pool, websites

• Performance - check whether it is affecting application or system, don't blame SQL Server alone

  Its a general assumption that whenever performance is degraded, the finger will be pointed to SQL Server, pretty easy eh!? If you look at any of the SQL Server related forums then 3 in 10 questions asks same question and nothing but shove blame on SQL... Posted Sep 03 2007, 09:42 AM by SSQA.net Filed under: sql server, performance, security, blocking, table, query, application, wait, oltp, high cpu, queue

• FIX: An application that is included in SQL Server 2005 may stop responding when you specify a network protocol that is not valid in the application

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX... Posted Aug 31 2007, 11:41 AM by SSQA.net Filed under: sql server, kba, network, application, stops, protocol

• SQL Server Express installation on X64 platform?

  Can we get install SQL Server Express 2005 edition on X64 environment? Yes and No. Yes for SQL Server Express on X64 and EMT64 that too in Windows on Windows ( WOW ), but No it is not supported on IA64 systems. This enhancement is enabled since the service... Posted Aug 28 2007, 06:05 AM by SSQA.net Filed under: sql server, performance, X64, service pack, application, platform

• TSQL cursors vs API cursors - poor cursor usage

  Cursors are based for a definitive purpose, but heavy usage of such methods will prove as costly expense on database performance. The process of cursor is prolonged, as a cursor first has to be defined with its features set, then populated after positioning... Posted Aug 27 2007, 08:54 AM by SSQA.net Filed under: sql server, performance, tsql, cursor, api, application, usage, heavy