SQL Server DBA specializing in performance tuning and disaster recovery. Bad code rarely begins the cascade of most SQL Server performance problems. Typically, it begins with something that is much ...

Power Query caches metadata (file lists, folder structures) from SharePoint to improve performance. When you connect via From SharePoint Folder, Power Query stores a local snapshot of the library’s ...

Google Cloud is not the only provider offering options to query distributed data with a single SQL statement. For example, AWS provides cross-region data sharing for Amazon Redshift, and Athena can ...

The thick client is making a comeback. Here’s how next-generation local databases like PGlite and RxDB are bringing feature-rich data storage to the browser. Once upon a time, we had mainframes with ...

Altman dismissed claims that ChatGPT used gallons of water per query. He acknowledged that total AI energy use was rising and urged cleaner power. However, Altman argued that humans also consume ...

New laptops with ARM processors (such as some Surface models) run older software through an emulation layer, which can cause Power Query to crash. Installing the native ARM64 version of Office allows ...

Microsoft has announced the release of SQL Server Management Studio Preview 3, which brings many features, including "initial" support for ARM64. SQL Server Management Studio (SSMS) is the tool of ...

Google released energy and water consumption estimates for its Gemini AI apps. It is the first major tech company to publish this information. Estimates are lower than public calculations, but ...