The Cost of Support
Microsoft is not planning on releasing Service Pack 3, but what is the best model for supporting software? Steve Jones gives a few thoughts.
2008-04-06
29 reads
Articles
The Cost of Support
Microsoft is not planning on releasing Service Pack 3, but what is the best model for supporting software? Steve Jones gives a few thoughts.
2008-04-06
43 reads
No XP, but Look Forward To 7
A look back at the news of the past week including Windows 7, SSD performance, April Fools, and consistency in SQL Server.
2008-04-05
191 reads
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.
2008-04-05
229 reads
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.
2008-04-05
279 reads
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.
2008-04-04 (first published: 2005-07-05)
106,294 reads
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.
2008-04-04
5,619 reads
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.
2008-04-04 (first published: 2007-04-12)
10,572 reads
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.
2008-04-04
1,985 reads
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?
2008-04-04
1,816 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers