Windows 7 and More
A look back at the news of the past week including Windows 7, SSD performance, April Fools, and consistency in SQL Server.
Windows 7 and More
A look back at the news of the past week including Windows 7, SSD performance, April Fools, and consistency in SQL Server.
Gotcha! SQL Aggregate Functions and NULL
Working with NULL functions can be tricky in T-SQL and SQL Server 2000. If you add in aggregates, you need to be sure you understand what the behavior will be or you might report incorrect values to a user. Michael Coles has written a new article that talks about how NULL affects your results.
Automating SQL Server Profiler
This article details the steps to automate the generation of Sql profiler traces in a Testing environment. The facility is useful when an application is User Acceptance Testing phase where a bunch of test users logon to the Testing site and use the application.
CASE function in SQL Server – part II
Part I of this series illustrated how to use simple case functions in queries. This installment discusses how to use case functions in different types of scenarios.
Handling Data Integrity Issues in Analysis Services 2005
Learn about common data integrity issues, and see how Analysis Services 2005 gives you the tools to handle them.
Tame Your Software Dependencies for More Flexible Apps
Few would disagree that striving for a loosely coupled design is a bad thing. Unfortunately, the software we typically design is much more tightly coupled than we intend. How can you tell whether your design is tightly coupled?
Dynamic Connection Strings in Reporting Services 2005
Reporting Services is one of the most popular features of SQL Server 2005 and there have been a tremendous number of enhancements to this subsystem. New author Bilal Khawaja brings us a look at dynamic connection strings and how you can have one report pulling data from different servers.
Transactions in Transactional Replication
SQL Server MVP Paul Ibison takes a look at how transactions are handled in replicated environments and the implications of rollbacks.
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers