Using SQL SERVER Database as Data Source
FOR MS Access VBA Switchboard and Data Entry Form. I am presenting, once again, a method of connecting and upgrading a SQL data source into a VBA presentation process.
2018-08-06
1,569 reads
I am presenting an MS Excel VBA project which automates the display of SQL Server data tables.
2018-05-17
2,962 reads
I created this article to demonstrate the use of derived columns inside a ForEachLoop Container for a client requirement for some auxiliary marketing reports. I found the Data Conversion tool useful to escape the problem of mismatched data types, which is an issue with versions of Microsoft SSIS.
2018-02-06
3,538 reads
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
By Steve Jones
The more I work with the Data API Builder (DAB), the more I lean...
By Steve Jones
It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...
I haven't used column level encryption because usually the vendors I deal with have...
Hi everybody, we got 2 entries in this table [myDatabase].[sys].[sysusers] Is there a possibility...
We are self hosting sql servers, we are not using Azure for sql servers....
When does a column declared as SPARSE use no storage?
See possible answers