[Video] Office Hours: Ask Me Anything About SQL Server at the Volcano Hekla
I drove up the volcano Hekla in central Iceland – also known as the Gateway to Hell – and parked the Defender here: While my travel companions hiked up higher (and took that photo), I set up the tripod and camera, then went through your hig …
SQL Server VM Best Practices
The post SQL Server VM Best Practices appeared first on SQLServerCentral.
Working with the Delete Activity in Azure Data Factory
Introduction We can use the delete activity in Azure Data Factory to delete files from both on-premises and cloud storage. In this article, we will discuss the delete activity with the various options available for the file deletion. I will show the fo …
Why pay for open-source software?
The post Why pay for open-source software? appeared first on SQLServerCentral.
How LAG compares to other techniques
The post How LAG compares to other techniques appeared first on SQLServerCentral.
Create an RPA Flow that Connects to Oracle Data in UiPath Studio
If your company uses legacy technology systems, you can use the UiPath RPA platform to extend your process automation capabilities to these systems and eliminate repetitive, error-prone tasks of manually updating them. By …
[Video] Office Hours: Ask Me Anything About SQL Server at Vestrahorn
The beach at Vestrahorn mountain looks different every time we’ve visited: high tide, low tide, sun, clouds. Always a fun side trip when we’re out in the southeast of Iceland. I took a break to answer the questions you upvoted here. Questio …
What Is a Cost-Based Optimizer?
When you execute a query, the database server has to figure out things like: Which table to process first Which index to use on that table Whether to seek on that index or scan it Which table to process next How to join the data between those two table …
PostgreSQL Date And Time Part 2
Overview In this article, we will cover the most commonly used PostgreSQL date and time functions: LOCALTIMESTAMP(), LOCALTIME(), TO_DATE(), TO_TIMESTAMP(). If you are not yet familiar with any date and time functionality my suggestion would be to go t …
What’s the real story behind the explosive growth of data?
The post What’s the real story behind the explosive growth of data? appeared first on SQLServerCentral.
Real-Time Streaming using Power BI Streaming Dataset
The post Real-Time Streaming using Power BI Streaming Dataset appeared first on SQLServerCentral.
Use SQLAlchemy ORMs to Access MongoDB Data in Python
The wide ecosystem of Python modules enables you get to work fast and effectively integrate your systems. You can use the CData Python Connector for MongoDB and the SQLAlchemy toolki …
Free Training Classes for Those Who Give Back: Announcing our 2021 Scholarships
You work at a charity or non-profit, helping them make a difference with data. Maybe you write reports to help fundraisers do a better job of raising money to find a cure for a disease. Or maybe you’re a developer at a non-government organization …
Azure SQL Migrations using Azure Data Studio
Database migrations to the cloud can be a daunting proposition for many database administrators and data stewards. A new extension available in the Azure Data Studio marketplace, called Azure SQL Migration, aims to simplify and streamline the process o …
Author Power BI Reports on Real-Time ServiceNow Data
As more businesses move toward data-driven digital transformation initiatives, lines of business are increasingly demanding access to their data to acquire actionable insights into performance and business health. Organizations …