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
124 reads
This article focuses on the use of OData Queries to integrate DevOps Analytics data to Power BI.
2021-01-21
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
In this post, Brent explains how to use a combination of two separate topics that he has blogged about recently.
2021-01-20
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
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
3,778 reads
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson continues his series surrounding the DAX financial functions. In this article, he exposes four functions that are popular in the calculation of depreciation and amortization. Those accustomed to these functions within Excel will find the syntax, uses and operation of the functions familiar within the Power BI environment.
2021-01-19
This article explains ten ways that SQL Monitor tackles the problem of scaling out the coverage of a single, lightweight monitoring system, and so allows your teams to maintain the health and performance of larger collections of databases and higher numbers of monitored SQL servers.
2021-01-19
The need to print doesn't seem to go away. Using RDL format report file you can print local reports in .net to PDF without having to connect to a Reporting Service Server.
2021-01-18
2,503 reads
In this article we present a PowerShell script that can help you monitor all of your SQL Server Availability Groups in your environment.
2021-01-18
If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Brian Kelley
Through high school and college, I carried deep wounds due to what was going...
I have the following tables as a example. Table 1 EmpID, LastName, FirstName 1,Smith,John...
I'm doing an update using a self-join, and just want to confirm something. If...
Comments posted to this topic are about the item Representative Data Challenges
Ask SSC