Sign in
|
Help
Home
Blogs
Media
All Tags
»
SQL Server
»
application
(
RSS
)
Recent Posts
Control the database version - an important task for DBA!
64 bit computing configuration with SQL Server 2005 - what you can take-on?
See how Resource Governor can help you 'in action' in managing SQL Server resources?
Unattended installation of application on multiple sites by using sa password with a symmetric key, is it possible in SQL Server?
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
Tags
.NET
Advisories / Bulletins
ASP.NET
C#
Community
Digital Media
Exchange
General
General Security News
Media Center
Microsoft
News
OpsMgr 2007
Rants
Security
Sharepoint
SPPS03_Tips
SQL Server
System Center
Tools
VB
Vista
Windows 7
Windows OS
Windows Server
Browse Blog Posts by Tags
Showing related tags and posts for the
Blogs
application. See
all tags in the site
.NET
2005
2008
64-bit
activex
api
beginner
best practice
best practices
blocking
blogs
compatability
computing
cursor
dashboard
database
datetime
dba
defragmentation
documentation
error log
hardware
heavy
high cpu
iis
initialize
kba
management
memory
memory leak
msdn
network
oledb
oltp
performance
platform
pool
profiler
protocol
query
queue
replication
reporting
resource governor
roles
sa password
sap
security
service pack
small
sql authentication
sqlnci
stops
store
stored procedure
symmettric keys
table
terminate
tsql
usage
versioncontrol
wait
webcast
websites
windows
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 to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Dec 9 2008
Filed under:
Filed under:
application
,
sql server
,
database
,
dba
,
documentation
,
best practices
,
stored procedure
,
beginner
,
versioncontrol
,
small
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 to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Wed, Apr 23 2008
Filed under:
Filed under:
application
,
sql server
,
performance
,
x64
,
hardware
,
computing
,
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 to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Fri, Feb 8 2008
Filed under:
Filed under:
application
,
sql server
,
management
,
blogs
,
security
,
query
,
2008
,
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 to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Jan 29 2008
Filed under:
Filed under:
application
,
sql server
,
security
,
best practice
,
sql authentication
,
sa password
,
symmettric keys
,
store
,
windows authentication
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 to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Sun, Oct 21 2007
Filed under:
Filed under:
application
,
sql server
,
memory
,
kba
,
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 to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Mon, Sep 24 2007
Filed under:
Filed under:
application
,
sql server
,
performance
,
replication
,
kba
,
2005
,
memory leak
,
terminate
,
activex
,
initialize
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 to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Sep 4 2007
Filed under:
Filed under:
application
,
sql server
,
management
,
webcast
,
reporting
,
iis
,
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 to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Mon, Sep 3 2007
Filed under:
Filed under:
application
,
sql server
,
performance
,
blocking
,
security
,
query
,
table
,
wait
,
queue
,
high cpu
,
oltp
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 to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Fri, Aug 31 2007
Filed under:
Filed under:
application
,
sql server
,
kba
,
stops
,
network
,
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 to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Aug 28 2007
Filed under:
Filed under:
application
,
sql server
,
performance
,
x64
,
service pack
,
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 to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Mon, Aug 27 2007
Filed under:
Filed under:
application
,
sql server
,
performance
,
usage
,
cursor
,
tsql
,
api
,
heavy
.Net framework 3.5 beta1 - get now for new features
If you are building on the new features in the .NET Framework 3.0, such as Windows Workflow Foundation (WF), Windows Communication Foundation (WCF), Windows Presentation Foundation (WPF), and Windows CardSpace, you'll want to preview the The .NET...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Jul 17 2007
Filed under:
Filed under:
application
,
sql server
,
performance
,
windows
,
.NET
Using Application roles and security - SQL Server 2005
In SQL Server, you can create database roles for easier administration of permissions in a database. Instead of granting individual permissions to each user separately, you can group users with the same permission needs by making them members of the same...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Jun 19 2007
Filed under:
Filed under:
application
,
sql server
,
performance
,
msdn
,
security
,
roles
SQLServer2005 Profiler (profiler90.exe) fails to launch with Application Error (0x0000005)
Further details and resolution for this problem can be found from this FAQ entry....( read more ) Read More...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Jun 19 2007
Filed under:
Filed under:
application
,
sql server
,
profiler
,
error log
What is the default datetime format in SQL Server?
There might be various questions in the forums asking what is the default datetime format in SQL Server, how to change the date format. Further into the details make a note that there is no international standard for representation of datetime values...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, May 8 2007
Filed under:
Filed under:
dashboard
,
defragmentation
,
application
,
datetime
,
sql server
Page 1 of 1 (15 items)