Free TempDB Training Class Next Monday
You’ve been working with Microsoft SQL Server for a couple of years, and you know a little bit about TempDB. You’ve heard that temp tables and table variables have different performance characteristics than regular user database tables, and …
Navigating Trees With CTE
Introduction This article shows how common table expressions (CTE) in SQL Server are naturally suited for navigating trees, such as finding its longest path, or diameter. Recall that a tree is an undirected graph where unique paths exist between any tw …
Tell us about how you monitor your databases
The post Tell us about how you monitor your databases appeared first on SQLServerCentral.
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 …