Operating System Performance Checklist
Like SQL Server, Windows Server is mostly self-tuning. But like SQL Server, there are things we can do to help optimize Windows' performance.
And every time we help boost the performance of Windows Server, we are at the same time boosting the performance of SQL Server.
http://www.sqlpronews.com/2004/1220.html
|
12.20.04 |
|
Stop
Playing Phone Tag With Your Hosting Provider
Call
Rackspace anytime around the clock and you'll talk to
a live person. Rackspace doesn't just believe in support--
they believe in Fanatical Support™.
http://www.sqlpronews.com/2004/1216.html
|
12.16.04 |
|
SQL
Server Hardware Performance Checklist
From
this previous article, on using Performance Monitor,
you may have identified some potential hardware bottlenecks
that are negatively affecting your SQL Server's performance.
In this section, we will take a look at each of the
major components of a SQL Server's hardware, and examine
what can be done to help maximize the performance of
your hardware.
http://www.sqlpronews.com/2004/1215.html
|
12.15.04 |
|
Using
Performance Monitor To Identify SQL Server Hardware Bottlenecks
The
best place to start your SQL Server performance audit
is to begin with the Performance Monitor (System Monitor).
By monitoring a few key counters over a 24 hour period,
you should get a pretty good feel for any major hardware
bottlenecks your SQL Server is experiencing.
http://www.sqlpronews.com/2004/1209.html
|
12.09.04 |
|
Backing
Up And Restoring Your MySQL Database
If
you've been using MySQL database to store your important
data, it is imperative that you make a backup of your
data to prevent any loss of data. This article shows
you how to backup and restore data in your MySQL database.
This process can also be used if you have to move your
data to a new server.
http://www.sqlpronews.com/2004/1206.html
|
12.06.04 |
|
Crystal
Reports - Microsoft SQL Server
Microsoft
SQL Server is the leader for inexpensive and middle size
SQL solutions. Plus it is now capable to serve large enterprise
on Microsoft Windows platform. Crystal Reports is the
most flexible tool on the market and it has market recognition.
Multiple software vendors offer Crystal Reports as the
main reporting tool: Microsoft, Best Software, Oracle
to name a few.
http://www.sqlpronews.com/2004/1130.html
|
11.30.04 |
|
Programming
Auto-apply In Accounts Receivable
Considering
that Great Plains is now very good candidate for integration
with POS application, such as Microsoft Retail Management
System or RMS and Client Relation Systems, such as Microsoft
CRM - there is common need in Great Plains customizations
and integrations, especially on the level of MS SQL
Server transact SQL queries and stored procedures.
http://www.sqlpronews.com/2004/1108.html
|
11.08.04 |
|
Microsoft
Navision Integration With Microsoft RMS
It
was originally written by Denmark-based Navision Software
in its own proprietary language C/SIDE (Client/Server
Integrated Development Environment). Currently Navision
is supported on two platforms - Navision native (C/SIDE)
database and on Microsoft SQL Server. In this small article
we would like to give you the clue on Navision integration
with Microsoft Retail Management System - Microsoft RMS.
http://www.sqlpronews.com/2004/1026.html
|
10.26.04 |
|
Microsoft
Navision Database: C/SIDE Or MS SQL Server
Microsoft
Business Solutions promotes Navision (former Attain)
on US market as excellent manufacturing applications
(formerly it was promoting Great Plains).
http://www.sqlpronews.com/2004/1011.html
|
10.11.04 |
|
Microsoft
Great Plains Dynamics On Pervasive SQL.2000 Data Repair
Up
to the version 7.5 Microsoft Great Plains, and if you
are looking to version 7.0, 6.0, 5.5, 5.0 or 4.0 - then
it was Great Plains Dynamics were available on Pervasive
SQL.2000 or Btrieve.
http://www.sqlpronews.com/2004/0927.html
|
09.27.04 |
|
TenFold
Announces SmartSQL Feature
|
Automated
SQL injection: What your enterprise needs to know
SQL
injection exploits may soon be as common as those targeting
Windows and Unix flaws, experts say. An estimated 60%
of Web applications that use dynamic content are likely
vulnerable, with devastating consequences for an enterprise.
A presentation of an automated attack targeting SQL injection
flaws is planned for Black Hat Briefings this week in
Las Vegas. This two-part interview with SPI Dynamics CTO
Caleb Sima will tell you what you should fear, why and
what you can do to mitigate your risk.
http://www.sqlpronews.com/2004/0727.html
|
07.27.04 |
|
Mixed
Emotions About .NET Managed Code in SQL Server
Microsoft's
impending release of the new capability to write stored
procedures in SQL Server is a big advance and technologically
admirable, but it raises serious questions about whether
such a capability is appropriate. In short, do managed
stored procedures increase or solve some of the management
problems associated with writing database-driven applications?
http://www.sqlpronews.com/2004/0622.html
|
06.22.04 |
|
Microsoft
Puts SQL Server in Line With Rivals on Backup Databases
LOVELAND,
Colo.--(BUSINESS WIRE)--June 3, 2004--Windows & .NET Magazine
Network, a Penton Media property, announced the winners
of the Best of TechEd 2004 Awards at a reception at the
Marriott Marina hotel in San Diego. Kim Paulsen, group
publisher of the Penton IT Media's Windows Group, and
team presented awards to Windows technology vendors in
12 categories and announced an overall Best of TechEd
winner.
http://www.sqlpronews.com/2004/0608.html
|
06.08.04 |
|
Get
an early look at the new MySQL certifications
There
are a couple of new certifications in town, and they call
themselves MySQL Core and Professional. The Core certification
was released in March 2003. The Professional exam went
to beta test a month later. These first two certifications
are designed for users and administrators. Each requires
only one test, but you must have Core certification before
you go for Professional.
http://www.sqlpronews.com/2004/0525.html
|
05.25.04 |
|
Microsoft
Adds ActiveViews to Free SQL Reporting Services Add-On
|
Large
Data Operations in SQL Server
The
articles in the Quantitative Performance Analysis series
examined the internal cost formulas used by the SQL Server
query optimizer in determining the execution plan and
the actual query costs for in-memory configurations. The
previous articles restricted the actual query cost analysis
to in-memory cases where all necessary data fit in memory
so that performance was not limited by the disk configuration.
This article provides a first look at queries involving
data large compared to available memory and queries involving
write operations where performance is limited by the disk
configuration.
http://www.sqlpronews.com/2004/0427.html
|
04.27.04 |
|
MySQL
Ready for Enterprise Database Reliability
Open-source
database software maker MySQL AB plans to unveil next
month an enterprise-level capability that automatically
shifts workloads to another database server when one fails.
http://www.sqlpronews.com/2004/0323.html
|
03.23.04 |
|
SQL
Server Parallel Execution Plans
Microsoft
SQL Server introduced parallel query processing capability
in version 7.0. The purpose of parallel query execution
is to complete a query involving a large amount of data
more quickly than possible with a single thread on computers
with more than one processor.
http://www.sqlpronews.com/2004/0127.html
|
01.27.04 |
|
