When designing your SQL Server 2005 Analysis Services (SSAS) dimensions and related attributes—appropriately called attribute relationships—you should consider how changes in your dimension data will affect the underlying dimension aggregations and, in turn, processing and query performance.
2007-10-22
951 reads
Connecting to SQL Server 2000 Analysis Services could lie in the memory settings. Get possible problems and solutions to connect to Analysis Services server.
2007-10-22
2,033 reads
As systems get bigger, servers consolidated, and SQL Server back ends more types of applications, the need for cross database queries for reports, updates, and more will continue to grow. Steve Jones looks at a few ways that you can design your linkages and talks about why he prefers one over the other.
2007-10-19 (first published: 2005-03-09)
32,450 reads
The Advanced Encryption Standard (AES) is a National Institute of Standards and Technology specification for the encryption of electronic data. It is expected to become the accepted means of encrypting digital information, including financial, telecommunications, and government data. This article presents an overview of AES and explains the algorithms it uses. Included is a complete C# implementation and examples of encrypting .NET data. After reading this article you will be able to encrypt data using AES, test AES-based software, and use AES encryption in your systems.
2007-10-19
2,427 reads
This installment of the series illustrates how to use PowerShell in conjunction with SMO to display SQL Server Objects.
2007-10-19
2,740 reads
PASS is the global users group for SQL Server DBAs, but there are a number of people who have never heard of it. Longtime author Andy Warren has a few suggestions for PASS and encourages you to submit your own.
2007-10-18
2,034 reads
In our new article, we will continue coverage of this topic by describing other activities that alter default connectivity settings applied during standard installation, focusing in particular on encryption.
2007-10-18
2,137 reads
SQL Server 2005 introduces the concept of schemas as opposed to object owners found in previous versions. This article will explain the differences between the two and, hopefully, clear up some of the confusion that still exists about schemas.
2007-10-18
5,547 reads
New author! Mahesh presents a solid overview of the replication architecture of SQL 2000.
2007-10-17 (first published: 2003-10-17)
45,487 reads
This is the 8th installment of my XML Workshop which aims at explaining the details of working with XML in TSQL.
2007-10-17
3,705 reads
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
By Steve Jones
Recently I had someone internally ask about whether SQL Source Control supports Git Hooks....
I'm running a group MSA for the database engine and SQL Agent in a...
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
Comments posted to this topic are about the item Encoding Strings
I have this code in SQL Server 2025. What is the result?
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(@message); SELECT @encoded AS EncodedResult;See possible answers