Version Control for Stored Procedures
Version control for stored procedures isn't always popular and certainly isn't easy. Or can it be? Andy discusses a technique he used on a recent project that you might find interesting.
2002-05-10
13,443 reads
Andy Warren
Review of SQL Server 2000 Performance Tuning
This book from Microsoft Press has a lot of good information that will help you do capacity planning and performance tuning. Is it worth buying though? Andy just finishing reading it and writing the review, see what he thinks!
2002-05-03
8,330 reads
Review of SQLZip
Running short of disk space? One way to solve that is to keep fewer backups on disk, or write a routine that will compress them to conserve space. Or you could try SQLZip, an add in that creates compressed backups. Read the review, see if it's something you should consider!
2002-04-16
5,721 reads
Non-Continous Replicaton and The LogReader
Last year Andy wrote about turning off the log reader as a way to reduce the overhead on a server, primarily when you have many logreaders running. In this follow up article he talks about the downside of using this technique and how the behavior of the logreader can be "tweaked" to make using non-continuous replication a little less of a headache.
2002-03-28
5,050 reads
The Intel Philanthropic Peer-to-Peer Program
Similar to Seti@Home, Intel has a program set up to support research for several diseases including Anthrax and Alzheimer's. It's free, it's useful, and it might make a difference. Read the notes Andy has put together and then decide for yourself.
2002-03-15
5,868 reads
Reducing Round Trips - Part 3
This week Andy continues his series on how to reduce the number of round trips to the server by looking at some things you can easily add to your applications without a lot of rearchitecting.
2002-03-11
7,966 reads
Review of Debugging the Development Process
Andy read this book recently and gave it a great review. Even though it's not a SQL book! Seriously, take a look at the review. It's a good book that is fun to read.
2002-02-26
3,261 reads
Adding a Column using SQL_DMO
One of our readers needed some help with altering a table with DMO, so Andy has a code sample and some comments in general about how to add objects using DMO. It's good code and a very quick introduction to how objects work. Worth reading!
2002-02-14
4,734 reads
Reducing Round Trips - Part 2
Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it!
2002-02-06
9,321 reads
Review of SQL Comparison and Synchronization Toolkit
This week Andy takes a look at a new product from Red-Gate that gives you even more options than you get with their SQL Compare and SQL Data Compare tools - now you can build your own. Add the features you always wanted. Build automated processes instead of using the GUI. It's an interesting product - read the review and then maybe even enter the contest to win a free copy.
2002-01-16
5,396 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers