SQL Window Functions in SQL Server, Oracle and PostgreSQL
The post SQL Window Functions in SQL Server, Oracle and PostgreSQL appeared first on SQLServerCentral.
Code Review & DevOps
The post Code Review & DevOps appeared first on SQLServerCentral.
Azure SQL DB Frequently Asked Questions
I’ve seen your search history. Let’s get you some answers. Is Azure SQL DB PaaS, IaaS, or SaaS? Azure SQL DB is platform-as-a-service (PaaS). Microsoft manages most common database tasks for you, and they act as your DBA. This also means th …
SQL Monitor v11.1 now supports Azure SQL Managed Instances
The post SQL Monitor v11.1 now supports Azure SQL Managed Instances appeared first on SQLServerCentral.
Load Multiple Excel Files and Worksheets with SSIS
I was asked to load multiple Excel files, each with multiple Excel worksheets. I found a very easy way to complete this in SSIS using a Script Task. This article will explain how I did this. For this example, I have two Excel files, File1.xlsx and File …
Power Apps Canvas Apps Examples
The post Power Apps Canvas Apps Examples appeared first on SQLServerCentral.
Using Data Science And Machine Learning In Identifying Fraudulent Activities
In continuation of our series in Data Science, we previously looked at A Data Science Approach in Product Analytics. One of the pressing tasks, especially at FinTech and e-commerce companies such as PayPal, Stripe, eBay, etc., is to recognize fraud bef …
How to choose between SQL and NoSQL databases
Organizations that support data-intensive applications must make many decisions about how to best implement and maintain them. One of the biggest decisions is to determine the best platforms to use for storing and delivering the application data. In th …
Your Top 10 Ideas for SQL Server
You’ve submitted thousands of bug reports and feature requests at feedback.azure.com, and here’s what you’ve voted as the top 10 requests right now: #10: MIN/MAX as non-aggregate functions. PostgreSQL and Oracle have the GREATEST/LEAS …
Have your say about PASS Summit 2021
The post Have your say about PASS Summit 2021 appeared first on SQLServerCentral.
Export SQL Server Data to Excel and Add New Columns with C#
The post Export SQL Server Data to Excel and Add New Columns with C# appeared first on SQLServerCentral.
PolyBase scale-out group in Azure for free
This article is complementary to the book, Hands-on Data Virtualization with Polybase, which you can find here and which contains additional information and tips to test Polybase for free, or at least at the lowest cost. One of the most impressive feat …
Digital Event: Innovate Today with Azure SQL
The post Digital Event: Innovate Today with Azure SQL appeared first on SQLServerCentral.
Missing Data
We don’t always have perfect knowledge of the reality we are trying to model in our database. The most general approaches to handling this missing data has been either ignore it, deduce it or impute it. Ignoring something explains itself. In SQL, we ve …
An Introduction To Kusto Query Language (KQL)
Introduction In my last article, An Introduction to Azure Data Explorer, I discussed the process of creating and using Azure Data Explorer. Azure Data Explorer is mainly used for storing and running interactive analytics on Big Data. First, I need to c …