2005-11-03
3,365 reads
Articles
SQL Server 2005 Adoption Rates
How many people are getting ready to upgrade to SQL Server 2005? Why are they upgrading? Why not? Edgewood Solutions conducted a survey and the results are in. Read on for the executive overview and learn how to get a complete copy of the results.
2005-11-02
5,275 reads
SSIS - Reusable Benchmark Harness
We all know testing is important, but face it, testing is not the highlight of anyone's daily work. And more important than testing your code the first time is regression testing after you have fixed a few bugs. Kristian Wedberg brings us a new article that uses SSIS to build a harness that allows repeatable testing of code and applying benchmarks to be sure that things are working as expected.
2005-11-02
8,255 reads
SQL Server 2000 SP3 and xp_cmdshell Woes
The problems caused by the SQL Sapphire Worm, also know as the SQL Slammer, have caused many sites to do a quick upgrade to SQL Server 2000 Service Pack 3 (SP3). It includes the fix that prevents infection by the worm. While moving to the latest service pack is usually a good thing, to do so without thorough testing risks breaking a working application. That is exactly what happened to one of my clients over the weekend.
2005-11-02
2,068 reads
New Survey: Why Upgrade MS SQL Server?
Take this survey for a chance at a $20 gift certificate from Amazon. Give your reasons to upgrade and your insight on performance issues.
2005-11-01
4,572 reads
SQL Rescue Review
Having a good tool to read your SQL Server transaction log can be a lifesaver, or a job saver. RegGate Software, maker of a number of useful SQL Server utilities has a log reader and Grany Fritchey takes a look at this product and how it might work in your environment.
2005-11-01
10,424 reads
Visual Defrag for SQL Server Discount
How often do you check your SQL Server tables for fragmentation? How often do you defragment them? This is one of those technologies that has been available for disks for a long time, but now is here for SQL Server. Norb Technologies is offering a discount to the SQLServerCentral.com community on this product.
2005-11-01
4,112 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.
2005-10-31
12,531 reads
Loving to Hate the Data Administrator
You can just hear it now: At the table down the hall, there’s a group of people having, (as it seems to you) yet another academic discussion on the merits of third-normal form and the structure of primary keys. You’ve heard many discussions like this before — it all seems so pointless. After all, doesn’t it just boil down to “create table” commands and a bunch of DDL? You mastered all that in your first DBA class. What could be so hard?
2005-10-31
3,688 reads
Microsoft SQL Server Cluster Vs Standby Server
Building a highly available system is hard. This short white paper from Sonasoft shows some of the differences between a cluster and their standby server product.
2005-10-28
10,579 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCU WISMA MILLENIA,Telp/Wa 0821.3111.159
Jalan Letjen M.T. Haryono No.Kav. 16 11, RT.11/RW.5, Tebet Bar., Kec. Tebet, akarta Selatan,...
BCA KCP Kas Cipayung. Tlp:(+62) 851-7373-7845
Jl. Bina Marga No.3, RT.6/RW.2, Cipayung, Kec. Cipayung, Kota Jakarta Timur, Daerah Khusus Ibukota...
BCA KCP Setiabudi Atrium,Telp/Wa 0821.3111.159
Setiabudi Atrium, Plaza Setiabudi, Jl. H. R. Rasuna Said No.Kave 62 Lt.l Ruang 101...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers