I diverge a little from the typical coding-based/oriented best practice to one that is focused on governance within public or government organisations with respect to the security of the data in databases used for annual reports. Internal controls fall...
2009-02-19
1,166 reads
Continuing with his discussion of how to implement a date dimension in SQL Server Analysis services, expert warehousing expert Vincent Rainardi discusses how to use this dimension as a reference dimension as well as other advanced topics.
2009-02-18
13,597 reads
When reviewing an issue through the Replication Monitor, the error messaging was leaving me wanting more detail to find out why the replication process was failing. So my question is, is there a way to garner more information from the replication agents running via SQL Server Agent?
2009-02-18
2,346 reads
In which Phil illustrates an old trick using STUFF to intert a number of substrings from a table into a string, and explains why the technique might speed up your code...
2009-02-18
1,631 reads
This article is part 2 of a 4 part series that explores the internals of SQL Server Integration Services. This article looks at SSIS Transformations and Execution Trees.
2009-02-18
3,157 reads
These days more and more systems gather data all the time, but are we using that data? Steve Jones comments on the glut of information and some of the problems that creates.
2009-02-18
82 reads
These days more and more systems gather data all the time, but are we using that data? Steve Jones comments on the glut of information and some of the problems that creates.
2009-02-18
542 reads
These days more and more systems gather data all the time, but are we using that data? Steve Jones comments on the glut of information and some of the problems that creates.
2009-02-18
540 reads
Dynamic management views measure the effectiveness of indexes and discover fragmented indexes that may slow down SQL Server.
2009-02-18
3,072 reads
In this SQLSchool video, MVP Brian Knight shows us how to create a simple data mining model in Analysis Services.
2009-02-17
2,878 reads
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
Comments posted to this topic are about the item 25 Years of SQL Server...
Comments posted to this topic are about the item The Decoded Value
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers