Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags SQL Server 7, Miscellaneous Rss

<< Newer    Items 21 to 40 of 145    Older >>
 

Free Encryption

Free SQL Server 2000 Encryption for your data!!! Author Michael Coles has put together a tolljit and some XPs that you can use to encrypt your data with the Blowfish algorithm. It is hard to write good applications that encrpyt data and manage the keys and security. This will give you a great headstart on protecting your data.   Read more...
By Michael Coles 2008/04/25 (first published: 2005/07/21) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 75,295 reads

Data Migration : Step by Step

This article by Chris Kempster covers a wide variety of areas concerned with data migration. Primarily, it focuses on process, standards and some of the many issues to consider when undertaking this role.   Read more...
By Chris Kempster 2005/11/25 (first published: 2004/03/24) | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 47,738 reads

Leveraging XP Excel , XML, and OPENXML for Data Imports

DTS is a fantastic ETL tool and it is often used to import Excel documents. However this can be a manual process in many cases in setting up the package. New author Sloan Holliday brings us a way that you can leverage Office XP's automation facilities and XML to import data into SQL Server.   Read more...
By Sloan Holliday 2005/11/22 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 10,639 reads

Conducting a SQL Server Operational Audit

Auditing, analyzing and documenting your SQL Server installation is becoming more important all the time, especially as more and more attention is being paid to the security of your environment. Chad Miller brings us a look at a framework and a sample document you can use in your environment to conduct an audit.   Read more...
By Chad Miller 2005/10/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,174 reads

Automatically Running a Process When SQL Server or SQL Agent Starts

Have you ever had a need to run a query or a process as soon as SQL Server starts? Or run some set of tasks when SQL Server Agent Starts? Possibly you want to run a cleanup routine, a copy process or have some task started each time SQL server or SQL Agent is started. Well if this is the case then this article will discuss a couple of options you might consider using to accomplish automatically running your process.  Read more...
By Additional Articles 2005/10/13 | Source: Database Journal | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,017 reads

Use SQL-DMO and Excel to Quickly Create Reports for Auditors

Auditing SQL Server, or any system, is not an easy task and with new regulations like Sarbanes-Oxley, it is becoming a full time job in some environments. Chad Miller brings us a way that he developed with Excel and some scripting to automate some of the security information for a large installation of SQL Servers.   Read more...
By Chad Miller 2005/10/04 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 11,137 reads

Getting Help on Query Analyzer

Query Analyzer has been a great tool in SQL Server 2000 and while it is superceeded in SQL Server 2005, lots of us will be using it for some time to come. New author Yakov Shlafman brings us some references and tricks for this essential DBA tool.   Read more...
By Yakov Shlafman 2005/09/20 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,059 reads

Adventures in Replication

SQL Server 2000 replication is the easiest so far to setup and work with. However there are some areas that you can get yourself into trouble with if you are not careful. New author Chris Rock brings us a few lessons learned in getting replication working with a remote office.   Read more...
By Chris Rock 2005/08/22 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 9,639 reads

Performance Monitoring by Internal Fragmentation Measurement

It has not been clear to what extent fragmentation, either internal or external, truly affects the performance of your SQL Server 2000 databases. New author Koby Biller discusses some of the impacts that it could have and has a free tool for download that can help you determine how fragmented your disk truly is.   Read more...
By Koby Biller 2005/08/16 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 8,399 reads

Worst Practices - Not Using Primary Keys and Clustered Indexes

Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!   Read more...
By Andy Warren 2008/05/09 (first published: 2003/11/10) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 65,896 reads

Free Encryption

Free SQL Server 2000 Encryption for your data!!! Author Michael Coles has put together a tolljit and some XPs that you can use to encrypt your data with the Blowfish algorithm. It is hard to write good applications that encrpyt data and manage the keys and security. This will give you a great headstart on protecting your data.   Read more...
By Michael Coles 2008/04/25 (first published: 2005/07/21) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 75,295 reads

Automate New Logins Creation

There are times when a new application or time period requires the creation of a number of logins for your clients. This can be a time consuming process, but Leo Peysakhovich brings us a way to make this go quickly.   Read more...
By Leo Peysakhovich 2005/07/19 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,809 reads

Query Analyzer Tricks

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.   Read more...
By Steve Jones 2005/05/06 (first published: 2003/01/07) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 69,915 reads

Using VBScript to Automate Tasks

This article discusses why VBScript should be one of the tools you use to manage your server. Sample scripts show how to remove files over x days old and how to FTP files.   Read more...
By Haidong Ji 2008/03/07 (first published: 2003/11/04) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 100,318 reads

Using the Table Data Type in SQL Server 2000

Performing routine database maintenance such as reindexing is important for keeping your databases running at peak performance. When you use INSERT, UPDATE, and DELETE statements to modify table data, indexes can become fragmented. Index fragmentation can happen when the logical sequence of pages is disrupted or when an index page contains less than its maximum amount of data, creating a gap in the data page or index. As indexes become fragmented, you get inefficient data reads when accessing tables and slower database performance.   Read more...
By Additional Articles 2005/03/10 | Source: developer.com | Category: administration
Rating:  Rate this |   Briefcase | 3,379 reads

SQL Maintenance Plans

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!   Read more...
By Andy Warren 2005/03/04 (first published: 2002/04/11) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 33,815 reads

SQL Server Data Structure

A look at the page, table, and index structures inside SQL Server.  Read more...
By Additional Articles 2005/03/03 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,963 reads

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first published: 2002/02/11) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 35,794 reads

Disaster in the Real World - Hurricane

Hurricane Charlie had a pretty substantial impact on residents and businesses in Central Florida. Andy lives in the Orlando area and wrote up some notes on the various challenges he ran into it. Out of it you might find a couple things worth thinking about adding into your DR plan.   Read more...
By Andy Warren 2004/08/24 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,253 reads

Stop SQL Injection Attacks Before They Stop You

A new article from MSDN magazine on stopping SQL Injection attacks by examining how the SQL can be exploited. It's a good basic article for developers as well as DBAs who might have to review code.  Read more...
By Additional Articles 2004/08/20 | Source: MSDN Communities | Category: security
Rating:  Rate this |   Briefcase | 2,399 reads
<< Newer    Items 21 to 40 of 145    Older >>
 
Tags
administration (52)    
programming (45)    
t-sql (44)    
strategies (29)    
configuring (21)    
performance tuning (19)    
security (13)    
visual basic 6 (12)    
indexing (10)    
backup / restore (9)    
dts (9)    
monitoring (9)    
database design (8)    
replication (8)    
stored procedures (8)    
ado (6)    
best and worst practices (5)    
sql-dmo (5)    
worst practices (5)    
.net (4)    
basics (4)    
installation (4)    
sql server 2005 (4)    
availability (3)    
career (3)    
disaster recovery (dr) (3)    
naming standards (3)    
user defined function (udf) (3)    
xml (3)    
asp (2)    
data warehousing (2)    
distributed queries (2)    
english query (2)    
news (2)    
openxml (2)    
triggers (2)    
updategrams (2)    
xsl (2)    
advanced (1)    
advanced querying (1)    
analysis services (ssas) (1)    
bugs (1)    
certifications (1)    
counter (1)    
development (1)    
nums (1)    
olap server (1)    
other (1)    
rants (1)    
schemas/dtds (1)    
scripts (1)    
sql server 6.5 (1)    
sqlinsider scripts (1)    
state of the business (1)    
system development life cycle (1)    
table (1)    
table of numbers (1)    
tally (1)