A few months after a major Windows 10 update, I started getting the most annoying notification ever: The message appeared randomly. No pattern. No clear cause. Just constant irritation. The Situation My system looked like this: Disk D: is removable. C: and E: live on the same HDD. Siblings. So my logical plan was simple: shrink C:, extend E:, silence the warning. Disk Management Reality I opened Disk Management and saw this: E: did not have the same options as other partitions. No “Extend Volume…” available. The “Smart” Attempt I shrank C: by 2GB using “Shrink Volume…”. Unallocated space appeared between C: and E:. Then began the classic “dance with tambourine around the campfire”: Move partition Merge attempt Allocate space Retry Nothing worked. Third-Party Tools Trial Search results pointed to third-party partition managers. I tested multiple vendors, including Paragon Hard Disk Manager and Macrium Reflect. None of th...

This post continues the previous article about connecting SQLite to SQL Server using an ODBC driver and a Linked Server. The script below retrieves table metadata from the SQLite linked server into a table variable and prepares a cursor over the table names. This can be used as a base for further automation or dynamic import logic. Retrieve Table Metadata declare @temp table ( col1 varchar(255), col2 varchar(255), [name] varchar(255), [type] varchar(255), col3 varchar(255) ) insert @temp exec sp_tables_ex 'Your_LinkedServer_Name' select * from @temp Create a Cursor Over Table Names DECLARE lstTables CURSOR FOR select [name] from @temp Important Notes The Linked Server must already be configured using the MSDASQL provider. The ODBC DSN must be created as a System DSN , not a User DSN. Make sure the DSN name matches the one used when creating the Linked Server. Do not use spaces in the DSN name to avoid query issues in SQL Server. Summ...

This guide explains how to connect a SQLite database file to Microsoft SQL Server using an ODBC driver and Linked Server configuration. The same ODBC DSN can also be used to open the database in MS Access. Overview The core requirement is creating a System DSN using a SQLite ODBC driver. Once configured, SQL Server can access the SQLite file through a Linked Server. Step 1 — Install SQLite ODBC Driver Download and install the appropriate version (match SQL Server bitness): http://www.ch-werner.de/sqliteodbc/ Step 2 — Create a System DSN Open ODBC Data Source Administrator: 64-bit: C:\Windows\System32\odbcad32.exe 32-bit: C:\Windows\SysWOW64\odbcad32.exe Create a System DSN and select “SQLite3 ODBC Driver”. Important: Do NOT use spaces in the DSN name. SQL queries against Linked Servers may fail if spaces are used. Step 3 — Create a Linked Server in SQL Server Run the following in SQL Server Management Studio: EXEC sp_addlinkedserver @server = 'SQ...

This is a first finished and published project today! :-) AliExpress Order Extractor

Company branded page was created today. Take a look! https://www.facebook.com/OxymoronTech

Today I did insertion of blog feed into the company site. That's how it looks: http://oxymoron-tech.oxy.co.il/Blog.aspx