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.
2006-10-13 (first published: 2005-04-14)
38,834 reads
This article examines a variety of ways in which you can execute all the SSIS packages in a folder.
2006-10-13
1,958 reads
In this presentation, Brian talks about the good, the bad, and the ugly of DTS migrations. Then, he shows you how to migrate a simple DTS package to SSIS and some of the challenges you will see.
2006-10-13
2,839 reads
We've been profiling quite a few members of the SQL Server development team and this time we get a few minutes with Ian Jose, one of the query processing team.
2006-10-12
3,175 reads
Arthur Fuller advises DBAs to try to break their software in order to make sure their SQL Server databases can withstand potential attacks. See if your code can hold up to his suggested tests.
2006-10-12
3,499 reads
In this second part video from Kathi, she covers how to write T-SQL in much more indepth. She covers how to handle NULLs and many more items in this video.
2006-10-12
2,787 reads
Continuing with his series on different aspects of Reporting Services, Asif Sayed examines the next installment with a step by step tutorial demonstrating the power of locally processed Reporting Services with the ASP.NET Web Client.
2006-10-11
11,451 reads
Database concurrency conflicts are somewhat of a plague in software development because they're hard to predict and handle. Unfortunately, they're also hard to prevent.
2006-10-11
2,638 reads
Properly sizing your SQL Server hardware and testing application loads against them is a complex and difficult topic. Anthony Bressi brings us a great new article that gives you a systematic approach to performing your own stress test.
2006-10-10
24,353 reads
This tip shows you how to execute and use the results of prediction queries in multiple ways within the SQL Server relational database engine.
2006-10-10
2,466 reads
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
WhatsApp:0817866887 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa Timur 60189
WhatsApp:0817866887 Jl. Pantai Indah Kapuk Utara I Blok F, Kamal Muara, Kecamatan Penjaringan, Jkt...
Jl. Cibinong City Center No.5 Ruko Blok A, Pakansari, Kec. Cibinong, Kabupaten Bogor, Jawa...
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers