Technology Flows Downstream
The technologies that we see in other data platform products sometimes flow to SQL Server.
Using VMware VMDKs for SQL Server Database Cloning
Learn how you can clone a database with a VMDK virtual disk to store your data.
Creating Your First SQL Server Docker Container in macOS
The use of macOS by developers and IT professionals has gained popularity the past few years. Running a sandboxed SQL Server, however, has been difficult. That changed when Microsoft made SQL Server images on Docker available. In this article, Carlos Robles explains how to get started with Docker when running macOS.
An Alert Philosophy
Many of you reading this will be responsible in some way for managing a system. This might be a test/development system or a production one, but often you want to know how well the system is working. Or maybe you want to know if the system is working at all. Even developers care if their […]
SandDance in Azure Data Studio
In this tip we look at how to use SandDance a powerful data visualization tool that is an extension to Azure Data Studio.
SQL Server Agent for SQL Express on Linux
This article will show you how to use crontab to schedule tasks that you want to run on a SQL Server on Linux instance when no Agent is configured.
Resolving could not open a connection to SQL Server errors
Sometimes you may have issues connecting to SQL Server and you may get messages such as could not open a connection to SQL Server. In this tip we look at different things you can check to resolve this issue.
SSMS or SSDT
The question this week deals with tools. Steve Jones is looking to see which tools are preferred by most database developers.
SQL For Cosmos DB – Handling Complex JSON Structures
The JSON documents that are part of Cosmos DB document collections can be complex with arrays and nesting. In this article, Adam Aspin shows you how to query them with SQL.
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
TempDB Facts I
Comments posted to this topic are about the item TempDB Facts I
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers