Converting values with CAST can round in ways you don’t expect. A puzzle on Date Data Types: guess the output of each query before you run it.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Cannot initialize the data source object of OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server
Cannot initialize the data source object of OLE DB provider Microsoft.ACE.OLEDB.12.0 showed up only from the client machine. Here is why and the fix.
Create an Azure VM for SQL Server Using the Portal
To create an Azure VM for SQL Server, pick a SQL Server image in the portal, size the machine, and set the network and SQL options before you press Create. This post walks through each portal tab, explains which choices are hard to change later, and ends with three T-SQL checks to run once you are connected. It also covers the cost of leaving the machine running.
Why an Encrypted Column Shows NULL on a Subscriber
An encrypted column shows NULL on a subscriber when the subscriber’s symmetric key doesn’t match the publisher’s key. This post reproduces the symptom with two demo databases, compares key_guid in both and shows the fix. It also explains what replication copies and what it leaves behind.
Oracle to SQL SERVER Migration – Triggers Used While Migration
Moving from Oracle to SQL Server is like switching phones: old habits come along. A client tuning case about the triggers used during the migration.
query_store_query_text: Searching Query History by Statement Text
A LIKE search on Query Store text is a good first step, but one search found four statements, including itself. I show how to narrow it down to the real history.
SQL SERVER 2016 – Trace Flag 1117 is Discontinued. Use the Options Provided with ALTER DATABASE
SQL Server 2016 discontinued trace flag 1117 and 1118 for TempDB. Use the options in ALTER DATABASE instead, as I found on a client server.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.