Transfer data from SQL Server to MySQL
In this article we look at how to use PowerShell to transfer data from SQL Server to MySQL.
2020-09-04
SQL Server
Installing PostgreSQL 11 on Windows with Step-by-step Instructions
PostgreSQL is a free database management system (DBMS). PostgreSQL 11 is the new version of this DBMS. We will take a look at how to install PostgreSQL 11 on Windows. This article covers where to download PostgreSQL 11, how the installation process looks like, and how to connect to the PostgreSQL server. Step-by-Step Installation on Windows […]
2020-09-03
21,417 reads
How do You Identify Object Dependencies in SQL Server
In this article we look at different ways to determine if one SQL Server database object is dependent on another database object.
2020-09-03
Database Modeling - Relationships
A proper relationship between two people, places or things improves the communication between them. In every real-world based application, this logic holds and a database is no different. This article discusses the different relationship types possible between database objects. The designing of these relationships between them is called modeling, and the three types of relationships […]
2020-08-31
7,584 reads
SQL Server Problems We Don’t Have Anymore
There are a whole slew of problems that we had to worry about ten years ago, and they just hardly ever come up today.
2020-08-28
SQL Server Interview Questions for Developers on Querying
In this article we look at some simple ways to test a SQL Server developers T-SQL skills with some query questions and answers.
2020-08-26
Getting started with SQL Server stored procedures
In this article we look at different examples of creating SQL Server stored procedures.
2020-08-20
Maximize View of SQL Server Query Plans with Full Screen Option
In this tip we look at how to save an execution plan for future review as well as using the full screen mode to see more of a query plan at one time.
2020-08-18
Using Simple Linear Regression to Make Predictions
The first part of this article focuses on using an R program to find a linear regression equation and the second part is devoted to simple linear regression analysis.
2020-08-13
SQL Server Agent Job Monitoring for Last Execution
In this article we continue our series of using PowerShell to monitor SQL Server by collecting the last run information for SQL Server Agent Jobs.
2020-08-12
Blogs
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers