(Allan Hirt) I teased this blog post a little while back at SQLBits, but I’m finally getting a chance to finish this blog post. No stale, scheduled content here – it’s always hot off the presses.
Tag: sql server
Querying temp tables across a linked server.
(Kenneth Fisher) And if you are still reading you probably fit into one of the following categories.
Does index fragmentation matter?
(Tibor Karaszi) Short answer: probably not. Long answer: read on.
SQL Monitor 9 – Proactively Monitor Large SQL Server Estates
(Pinal Dave) Let me tell you about a real-world scenario which I often see at organizations I work with. In the perfect world, as organizations grow, their team should grow too. But often that isn’t the reality.
Attaching Manually-Created Common Data Model Folders In Power BI Dataflows
(Chris Webb) Most of the focus on Power BI dataflows so far has been on the use of Power Query Online to load data from external data sources.
Powershell script function for disk free
(Jack Vamvas) Question: I’m currently building a script to return all SQL Servers in the environment .
Compliance Ain’t Easy
(Grant Fritchey) I’m sure by now you’ve heard of the GDPR and some of the large scale data breaches that have occurred within it. If you haven’t heard of the GDPR, you’ve been under a rock, or, you’re like me, a United States citizen (it’s amazing how little we know about this oncoming train).
Azure NVMe Storage and Redundancy
(Denny Cherry) With Microsoft Azure now supporting Virtual Machines with NVMe storage; things get a little different when it comes to handling recoverability.
Configuring Azure SQL Databases Using Azure Resource Manager Templates
(Marcin Policht) In a recent article (Using Azure Resource Manager Templates To Provision Azure SQL Databases) published on this site, a sample Azure Resource Manager template was presented that provisions a new logical server hosting a single Azure SQL Database instance.
SQL SERVER – Priority Boost and SSMS 18
(Pinal Dave) Just the other day, I had a very interesting experience while using the latest SQL Server Management Studio 18.0 preview 7 (SSMS 18.0) during one of the Comprehensive Database Performance Health Check.
