Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
I'm using distributed partitioned views to issue a simple query that sums sales data across two partitions. I've partitioned the data across two tables on two separate remote servers (Server1 and Server2). However, query performance remains the...
When I copy two columns—approximately 5MB in disk size and containing fewer than 400,000 rows—from one table to another, the copying process seems to enlarge the transaction log by about 100MB, even when I drop the indexes from the destination...
Here's a list of the resources that I describe in this article (plus a couple of extras). When you're looking for online resources, remember that SQL Server is now classified as a Microsoft .NET Enterprise Server. I've tried to include the most r...
If you've read this column for the past 2 years, you know that I'm a fan of education and training—and not just formal classroom training. To me, technical education includes almost anything that helps you do your job better. Many of my columns...
Congratulations to Kirby Richter, senior consultant at Magenic Technologies in Golden Valley, Minnesota, and Francis Apel, data warehouse and database administrator at Madison, Wisconsin-based Promega. Kirby won first prize of $100 for the best...
For a long time, C and C++ developers deeply envied their Visual Basic (VB) colleagues for VB's On Error Goto and On Error Resume Next features. At a certain point, the notion of structured exception handling surfaced in C++ applications, but many...
A few months ago, I highlighted the SQL Server 2000 Operations Guide, a handy document designed to help operations teams that are responsible for managing SQL Server's day-to-day operations. The guide offers a wealth of valuable SQL Server...