SQL Server Administration
|
67 results found for SQL Server Administration, displaying items 1 - 20
|
|
[May 18, 2000]
|
|
Microsoft Testing SQL Server 6.5-to-2000 Upgrade
Brian Moran reports that Microsoft is offering free upgrade testing to encourage the many customers still running SQL Server 6.5 to move to the upcoming SQL Server 2000 release and to make sure the process goes as smoothly as possible.
Windows IT Pro
—
Brian Moran
|
[May 15, 2000]
|
|
MSMQ: Time Out for Your Database Applications
Many people overlook Microsoft Message Queue Server in their application development strategies, but this powerful messaging technology can give your applications a simple, robust way to interact with SQL Server.
Windows IT Pro
—
Ken Spencer
|
[May 11, 2000]
|
|
Read the Fine Manual
Brian Moran says SQL Server professionals have an excellent, but underused, resource in SQL Server Books Online--also available in hard copy.
Windows IT Pro
—
Brian Moran
|
[May 8, 2000]
|
|
Using XML to Store Session Data
To eliminate session variables in Active Server Pages (ASP) applications, you can store all session variables in an XML string.
Windows IT Pro
—
Ken Spencer
|
[May 4, 2000]
|
|
Phasing Out Support for Older SQL Server Versions
Most of us have plenty of time to plan how we're going to move to SQL Server 2000, but those of us on older versions of SQL Server may need to map out our migration strategy sooner rather than later.
Windows IT Pro
—
Brian Moran
|
[May 1, 2000]
|
|
Hardware's Golden Rule
Ken Spencer reminds you about the often overlooked "golden" rule: If your hardware is golden, you've already eliminated many potential problems.
Windows IT Pro
—
Ken Spencer
|
[April 27, 2000]
|
|
In Defense of Database Kin
Brian Moran chastises organizations that treat database integration as an afterthought rather than a key element of a complex whole.
Windows IT Pro
—
Brian Moran
|
[April 24, 2000]
|
|
Putting COM Calls to the Test
Ken Spencer says the way you call COM objects can have a dramatic effect on application performance.
Windows IT Pro
—
Ken Spencer
|
[April 20, 2000]
|
|
Database Deja Vu
Brian Moran says the database revolution UNIX folks fanned 10 years ago has reignited under the banner of Windows technologies.
Windows IT Pro
—
Brian Moran
|
[April 17, 2000]
|
|
Returning an XML Document as a String
Here are three options for generating a complete XML document or stream from a stored procedure, then returning the XML document or stream as a string to the calling application.
Windows IT Pro
—
Ken Spencer
|
[April 13, 2000]
|
|
Time to Speak Up
Brian Moran says that whether you hang your hat in the consulting world or at a “real job,” the occasional technology presentation gives your resume and career a boost.
Windows IT Pro
—
Brian Moran
|
[April 10, 2000]
|
|
Good Business Reasons for Using XML
XML provides practical solutions for many application needs, such as handling errors and storing session data.
Windows IT Pro
—
Ken Spencer
|
[April 6, 2000]
|
|
To Tweak or Not to Tweak?
'Tis nobler to have a database that is fast than one that is tunable.
Windows IT Pro
—
Brian Moran
|
[April 3, 2000]
|
|
Learning Through Prototyping
Prototyping is essential to building any application.
Windows IT Pro
—
Ken Spencer
|
[March 30, 2000]
|
|
Should You Upgrade to SQL Server 7.0 SP2?
SP2 contains many fixes for miscellaneous performance and tuning problems as well as the patch for a recently discovered security hole.
Windows IT Pro
—
Brian Moran
|
[March 27, 2000]
|
|
Using SQL Server's GUID Feature
Before using globally unique IDs, make sure you fully understand how they work.
Windows IT Pro
—
Ken Spencer
|
[March 23, 2000]
|
|
Microsoft Patches SQL Server Security Hole
Without the patch, anyone can run a particular type of query using a particular form and gain sa rights.
Windows IT Pro
—
Brian Moran
|
[March 20, 2000]
|
|
Using Stored Procedures to Build HTML Option Lists
Let SQL Server stored procedures automatically generate part of the HTML you normally use in your ASP code.
Windows IT Pro
—
Ken Spencer
|
[March 16, 2000]
|
|
GHz's Bang for the Buck
Will the gigahertz boost drop through to the bottom line for SQL Server (and other database) benchmarks? You betcha!
Windows IT Pro
—
Brian Moran
|
[March 9, 2000]
|
|
Includes Boost Productivity, Code Performance
Improve both your productivity and your Web applications’ performance by judiciously using server Includes.
Windows IT Pro
—
Ken Spencer
|
|
Register
