|
|
|
|
|
| | Total Hits: 161 | Today: 0 | Author: SqlServerCentral | Rating:  |
| | 
SQL Server 2000 does not have the best or most secure password mechanism. In fact it does a pretty poor job of managing passwords and forcing changes. From the very knowledgable web team over at Orcsweb, a short article on how you change passwords in code.... |
| | Total Hits: 155 | Today: 0 | Author: Brad M. McGehee | Rating: |
| |
If you want to automatically synch one database’s objects with another, you can do this automatically through SQL Compare.In this review, learn how you can use SQL Compare to compare and synchronize SQL Server database objects.
... |
| | Total Hits: 389 | Today: 0 | Author: Brad M. McGehee | Rating: |
| |
The purpose of this article is to introduce you to SQL Server clustering, along with its pros and cons. If you are considering clustering SQL Server to help reduce potential downtime, this article is a good place to start.... |
| | Total Hits: 141 | Today: 0 | Author: Brian Knight | Rating: |
| |
Clustering a SQL Server machine was one of the most frustrating tasks a DBA and Windows administrator had to accomplish in SQL Server 7.0 and Windows NT 4.0. With the maturity of both the OS and the DBMS in Windows 2000 and SQL Server 2000,... |
| | Total Hits: 219 | Today: 0 | Author: Jason Mauss | Rating: |
| |
Have you ever been told that an upgrade would be "easy", only to step right into a maelstrom? Here is a war story for the record books.... |
| | Total Hits: 197 | Today: 0 | Author: Michael Aubert | Rating: |
| |
Welcome to the second article in my series SQL Server Administration in 15 Minutes a Week.In this article we will look at how to perform a basic installation of SQL Server 2000. The topics for this article include:
- Before the Installation
- Installation Overview... |
| | Total Hits: 293 | Today: 0 | Author: Brian Knight | Rating: |
| |
Among the least understood and most often misused SQL Server settings are those for configuring the server and database. You might have experienced confusion about these settings when a vendor's tech support representative asked you to adjust a setting one way after another representative asked you to tweak the same setting in the other direction. The documentation about these options is lacking or—at the very least—confusing. In SQL Server 2000, Microsoft has eliminated some of this confusion b... |
| | Total Hits: 184 | Today: 0 | Author: Steve Jones | Rating: |
| |
I have been gathering lots of information about my SQL Servers and then using this to generate a daily report. As I began to gather this information, I have chronicled my efforts in this series and the last couple columns have dealt with the reporting of this information. I am now ready to expand the types of information begin gathered with another set of stored procedures.
... |
| | Total Hits: 292 | Today: 0 | Author: Brad M. McGehee | Rating: |
| |
If you are seriously considering implementing SQL Server 7.0 or 2000 under Windows 2000 Advanced Server or Windows 2000 Data Center, then I highly recommend that you review these web links before you begin. SQL Server clustering has many gochas, and the best way to breeze past them is to know about them before you begin.... |
| | Total Hits: 179 | Today: 0 | Author: Edgewood Solutions Engineers | Rating:  |
| |
The principal of least privileges is a cornerstone to most security implementations. The premise behind the principal is to only grant users, developers, DBAs, network administrators, etc. the needed rights and nothing more. If additional rights are required, evaluate the rights and grant the access accordingly. With SQL Server 2000 and 2005 one area that does not seem to follow this principal is related to the default rights for the BUILTIN\Administrators group. By default this group has SQL... |
| | Total Hits: 23 | Today: 0 | Author: Robin Schumacher | Rating: |
| |
n Part 1 of this article series, we looked at how the Falcon transactional storage engine was architected and how it compared to some of the other MySQL storage engines. In this article, I’ll focus on how Falcon performs transaction management, including some special points on where Falcon differs from some of MySQL’s other transactional engines.... |
| | Total Hits: 32 | Today: 0 | Author: Robin Schumacher | Rating: |
| |
Every now and then I get a big reminder of how great it is to be a part of the open source way of doing things. Having a strong community of MySQL lovers who use the free and open source MySQL database server and pay MySQL AB with code contributions and bug reports is truly a great way to develop rock solid and innovative software. Some contributions that come back to MySQL are small, but others are very large indeed. What would be large, you ask? How about a new, powerful transactional storage ... |
| | Total Hits: 191 | Today: 0 | Author: Steve Jones | Rating: |
| |
Query Analyzer is a great tool for developing SQL code. There are a number of little tricks that can greatly increase the amount of work you can do with very little effort. This article starts looking at some of the features of this tool.... |
| | Total Hits: 151 | Today: 0 | Author: Santveer Singh | Rating: |
| |
SQL Server has this concept of an owner of an object. Similar to the concept of schema, but not quite the same. Best practice dictates that all objects in SQL Server be owned by dbo, but that does not always happen. Tracking those objects down might be a pain.In this article the author will show how can we get the list of all the objects (table, Procedure, view or user defined function) owned by non DBO users.... |
| | Total Hits: 198 | Today: 0 | Author: Andy Warren | Rating: |
| |
Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit!... |
| | Total Hits: 155 | Today: 0 | Author: SqlServerCentral | Rating: |
| |
SQL Server 2000 trace flags can dramatically alter the behavior and functionality of the server. This article describes how to set the status of trace flags in SQL Server 2000 to on or off. It also describes what effects setting the status of a trace flag has (and what effects it does not have). Most of the information can be found in Books Online1, though the information contained there is not complete and even confusing in some parts. In this article I have tried to present the complete inform... |
| | Total Hits: 208 | Today: 0 | Author: SQLServerCentral | Rating: |
| |
Scripting out your SQL Server 2000 objects is useful in any number of ways. You can save off the scripts for version control, generate the scripts needed to migrate to new hardware or a new environment, or just package up your application for deployment. Jon Reade brings us a look at the SCPTXFR utility, which can prove very valuable in managing your scripts.... |
| | Total Hits: 188 | Today: 0 | Author: sqlservercentral | Rating: |
| |
It is not recommended, but there is quite a bit of valuable information stored in the SQL Server 2000 system tables. the author of this article brings us a look at some of the information that you can get by directly querying the system tables and explains what is stored in a number of them, including gathering information about computed columns.... |
| | Total Hits: 95 | Today: 0 | Author: Michael Kaplan | Rating: |
| |
This article introduces Microsoft SQL Server developers to the international features of SQL Server 2000. Topics covered include an explanation of Unicode, SQL Server international data types, and key issues regarding implementation.... |
| | Total Hits: 210 | Today: 0 | Author: K. Brian Kelley | Rating: |
| |
In Part I, we looked briefly at the two main SQL Server services: MSSQLServer and SQLServerAgent. We also examined the user contexts each service could run in and the differences that occur when we’re using named instances with SQL Server 2000. In this article we’re going to consider various factors that’ll help us decide which user context to use for each service, as well as managing these services from tools other than SQL Server Enterprise Manager and Service Manager.
... |
|
|
|
|
|
|
|
|
|
|
|
|
|