Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
Content with tags
SQL Server 7
,
Miscellaneous
<< 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,469 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,880 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,661 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,238 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,197 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,171 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,065 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,647 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,413 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
|
66,031 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,469 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,825 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,926 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,391 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,772 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,837 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
|
3,167 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,855 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,254 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,695 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 and 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)
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.