SQLite and the Performance Implications of Indexes
Indexes make an enormous difference in the read speed of a databases. I have previously mentioned that adding proper indexes...
2017-02-05
508 reads
SQLWise
MS Access – Store a Different Value than Displayed in a Combo Box
It is occasionally usefully to display a different values in an Access combo box than what is actually stored in...
2016-10-13
440 reads
Python Distributions
Python Distributions Python is free and open source software. A programmer could download the executables for Python directly from the...
2016-07-01
576 reads
Pronouns in technical writing.
When doing technical writing, or for that matter most forms of writing , we need to be able to refer to...
2016-02-17
656 reads
New Publications and a Video
The people at Webucator were kind enough to make a video based on my article on dealing with SQL Server...
2015-11-17
392 reads
Making Changes to Many Forms In Access
Although generally I prefer to create custom interfaces for my databases using fully developed programming languages like Python or C#....
2015-07-03
486 reads
Keep it short
I have been thinking about resumes a great deal lately. Since I recently passed the Bar Exam, I have been...
2015-06-14
545 reads
Dealing with SQL Server LOCK resource errors.
I was recently doing some testing that required a fairly large table. I created the test table, and set it...
2014-05-26
804 reads
Order of a Result Set in SQL
I have seen people build procedures that rely on a result set being returned in a certain order. This is...
2013-09-14
747 reads
SQL Server Three Valued Logic and Ansi Nulls
SQL Server uses a three valued logic with True, False, and Unknown. And, normally, SQL Server Nulls are not comparable....
2013-08-21
1,283 reads
Blogs
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
Looking Back at the Redgate 2026 Company Kickoff
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
PASS Data Community Summit 2025 Recap
By alevyinroc
This is long overdue but life and distractions happened. It’s been a little over...
Forums
Microsoft no longer being supported?
The word is finally out that Microsoft is no longer supporting SSRS. I just...
SQL Agent job running gMSA cannot backup to NAS target
I'm running a group MSA for the database engine and SQL Agent in a...
sys.query_store_query question
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
Question of the Day
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
