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

Content with tags Miscellaneous, Programming Rss

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

Security Enhancements in the .NET Framework 2.0

Security support in the .NET Framework got a lot of love in version 2.0, and this column is going to take you on a whirlwind tour of the goodies you'll find there. I won't be able to cover everything, but you'll know where to start looking to stay on top of the new changes. I'll take this a namespace at a time.  Read more...
By Additional Articles 2006/03/17 | Source: MSDN Communities | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,690 reads

SQL Server Alerts In C++ Builder

SQL Server has a great alerting mechanism for letting DBAs know when some event has occurred, but adding this notification to clients is a little more difficult. New author Stas Vasiljev brings us an extended stored procedure that has has used to allow clients to receive a broadcast when data has changed on a server.   Read more...
By Stas Vasiljev 2006/03/07 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 4,747 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,291 reads

Stop SQL Injection Attacks Before They Stop You

This article discusses: * How SQL injection attacks work * Testing for vulnerabilities * Validating user input * Using .NET features to prevent attacks * Importance of handling exceptions  Read more...
By Additional Articles 2006/02/08 | Source: MSDN Communities | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,995 reads

Encrypting Without Secrets

Do you have a Web site or other system that deals in secrets of any sort? It seems like every time I give a security talk, people ask how to deal with the sticky problem of storing secrets. Connection strings with passwords are an obvious problem. You're better off simply using integrated security to get rid of those secrets, at least with SQL Serverâ„¢, or an Oracle database. But what about credit card numbers and other financial or personal information? Can encryption help?  Read more...
By Additional Articles 2006/01/23 | Source: MSDN Communities | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,447 reads

How to Build Dynamic Stored Procedures

Robert is our expert on dynamic sql. This week he offers some good hints for planning the contruction of a proc that will use dynamic sql. He also adds some suggestions on how to format the code so that when you return to it later, you can figure out what you were doing!   Read more...
By Robert Marda 2005/12/16 (first published: 2003/04/25) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 49,003 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,638 reads

Calling COM From T-SQL

One of the lesser used features of SQL Server is the ability to access the functionality in various DLLs using a COM interface. Dinesh Asanka brings us a basic article with a few examples in how you can work with COM components from inside SQL Server 2000.   Read more...
By Dinesh Asanka 2005/10/31 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 11,055 reads

Use ISO Images Without Burning to Disk

Many downloads - especially from MS - are now coming as ISO images. Usually you burn these to CD or DVD and then use as normal, but there is a way to access the image directly saving the time/cost of burning. Not a SQL article, but you may find it useful anyway.   Read more...
By Andy Warren 2005/10/14 (first published: 2004/07/16) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 55,023 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,136 reads

Creating a PDF from a Stored Procedure

A short but interesting article, the author has figured out a way to create a PDF from a stored procedure without using a third party library.   Read more...
By Masar Ivica 2005/09/02 (first published: 2003/08/26) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 55,155 reads

Dynamic SQL or Stored Procedure

We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't.   Read more...
By Andy Warren 2005/08/26 (first published: 2003/04/23) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 47,244 reads

Where Logic Lives

We recently published an article about logic in the database about how you might structure the TSQL code in your SQL Server and decide what goes inside the database. New author Mike Dillon brings us a response to that article and some ideas about how you might make those decisions.   Read more...
By Mike Dillon 2005/08/23 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,013 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

The Basics of Cryptography Part 2

Encryption in SQL Server is difficult to implement and manage, but it is being required more and more often. However understanding what encryption means is as important as being able to manage and implement it. Michael Coles brings us part 2 in his series on explaining the mysteries behind cryptography.   Read more...
By Michael Coles 2005/08/17 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 10,506 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

Single Point of Administration

Whether you write TSQL code or front end VB code against your SQL Server, it pays to have some good development practices that make your life easier. Jonathan Stokes has written a good article showing some of the good practices you should use.   Read more...
By Jonathan Stokes 2005/08/15 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,912 reads

The Basics of Cryptology

After a fantastic reception to his SQL Server 2000 cryptography toolkit, Michael Coles brings us a basic look at cryptography so you can understand what you are getting into if you implement it.   Read more...
By Michael Coles 2005/08/10 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 13,897 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,291 reads

Agile Development with Scrum

We've all been there: the project that never ends and no light at the end of the tunnel. Nothing is more disheartening to a developer, DBA or anyone else that may be on a project than a finish line that has no end in sight or worse yet, one that keeps moving. Agile and Scrum development methodologies aim to fix this problem and others by applying what will appear to be common sense after you engage in the methodology for a few projects. This article will get you acquainted with my now-favorite d   Read more...
By Brian Knight 2005/05/18 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 17,022 reads
<< Newer    Items 21 to 40 of 169    Older >>
 
Tags
sql server 7 (45)    
t-sql (45)    
strategies (24)    
administration (23)    
visual basic 6 (22)    
database design (14)    
ado (13)    
stored procedures (12)    
configuring (11)    
performance tuning (10)    
.net (9)    
security (8)    
advanced querying (6)    
sql-dmo (6)    
basics (4)    
career (4)    
data warehousing (4)    
dts (4)    
naming standards (4)    
replication (4)    
reviews (4)    
xml (4)    
asp (3)    
backup / restore (3)    
best and worst practices (3)    
book reviews (3)    
certifications (3)    
indexing (3)    
monitoring (3)    
system development life cycle (3)    
worst practices (3)    
access (2)    
analysis services (ssas) (2)    
availability (2)    
olap server (2)    
sql puzzles (2)    
sql server 6.5 (2)    
advanced (1)    
c++ (1)    
disaster recovery (dr) (1)    
english query (1)    
installation (1)    
other (1)    
product reviews (1)    
rants (1)    
semaphore (1)    
state of the business (1)