SQL Server MSDB Database Tutorial
In this tutorial we will cover common questions related to the SQL Server msdb database. This is one of the standard system databases that are part of every SQL Server installation.
2021-01-25
Articles
Import flat files to SQL Server on Linux using Azure Data Studio
Have you ever wonder how to import flat files to SQL Server on Linux? In this article, I will share my experience loading data to a Linux SQL Server instance using the new Azure Data Studio data import extension from macOS.
2021-01-22 (first published: 2018-11-05)
3,940 reads
Automating SQL Compare Snapshots using SQL Snapper
If you have SQL Compare, then the SQL Snapper utility is very valuable 'extra' for certain team activities, because it can be freely distributed. It means that any developer can create a SQL Compare snapshot from databases that are on their local workstation and store them on the network.
2021-01-22
Power BI Merge Queries and Append Queries
In this tip we will cover how to use merge and append in Power BI to add additional data to a dataset that can then be used in reports and visuals
2021-01-22
The CAST operator in PostgreSQL
Introduction Cast is a technique in PostgreSQL with which we can convert a value of one datatype into another. We can perform various cast operations in PostgreSQL for converting one datatype to another, such as the String datatype to the Integer datatype (or the Boolean datatype or datetime datatype) and vice versa. This article will […]
2021-01-21
75,230 reads
Create Azure DevOps Analytics Visuals with Power BI OData Queries
This article focuses on the use of OData Queries to integrate DevOps Analytics data to Power BI.
2021-01-21
Gitflow Workflow Feature Branching for SQL Database Projects
Learn how to use Gitflow workflow to meet the needs of developing new database related features and how to deploy these database changes.
2021-01-21
How to Batch Updates A Few Thousand Rows at a Time
In this post, Brent explains how to use a combination of two separate topics that he has blogged about recently.
2021-01-20
Multiple Regression Model Enhanced with Bagging
This article explains what bagging is relative to a basic decision tree model and demonstrates how to apply bagging for better multiple regression model fits to data from SQL Server.
2021-01-20
Mathematicians and SQL
Georg Ferdinand Ludwig Philipp Cantor is considered the creator of set theory, and his theories are the basis for the naïve set theory you learned in school. But there are lots of other mathematicians you should know, such as Hilbert, Frege, Russell, Zermelo and Dedekind. They made a lot of contributions, too. Hilbert Hilbert is […]
2021-01-19
5,603 reads
Blogs
Query to Email….Well Formatted Email
By SteveHood79
When I get alerts from SQL Server I want it to do three things...
Announcements from the Microsoft Fabric Community Conference
By James Serra
A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
Why Your SQL Server Backups Aren’t Enough
By Kevin3NF
SQL Server backups are database insurance – you don’t really appreciate them until disaster...
Forums
Upgrades to SQL Server 2022
Comments posted to this topic are about the item Upgrades to SQL Server 2022
Elements of the SQL Server Update Statement
Comments posted to this topic are about the item Elements of the SQL Server...
Data Type Names In Powershell - Identity Increment
I am working with a script to exclude certain data types, and I was...
Question of the Day
Upgrades to SQL Server 2022
What is the earliest version from which you can directly upgrade to SQL Server 2022?
See possible answers