SQL Server Analysis Services (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications, such as Power BI, Excel, Reporting Services reports, and other data visualization tools. When paired with ADO.NET data providers, you can create cubes from external data […]
2019-04-30
3,590 reads
A basic introduction for developers (or anyone) about reading the metadata of a SQL Server database from a .Net application.
2018-06-14
3,424 reads
A basic introduction for developers about working with the DataSet object in ADO.Net to represent objects in a SQL Server database, and some of the options available.
2018-04-26
952 reads
Performance penalties for omitting SQL data types when using ADO.Net or light weight ORMs.
2015-06-22
6,262 reads
2009-06-03
3,640 reads
In Part 1 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.
2008-03-28
3,958 reads
The 3rd and final of the 3 Part Series discussing the implementation of a provider independent Data Access Layer in ADO.NET.
2008-02-15
2,789 reads
In Part 2 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.
2008-02-13
2,643 reads
In Part 1 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.
2008-02-11
3,554 reads
The Entity Framework is an exciting new technology being developed for ADO.NET. It allows developers to view data using a logical model instead of a physical model, offering more flexibility.
2008-02-01
3,492 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