Leading-Edge NoSQL Drivers for NoSQL Analytics and Integration
NoSQL databases, such as MongoDB, are an increasingly important component of enterprise data strategy, handling high-volume, scalable, and agile data management. As organizations adopt emerging NoSQL solutions, there is high demand to integrate these data sources with existing infrastructure and familiar tools. Standards-based data access facilitates your expansion into MongoDB by leveraging existing skills using […]
Monitoring Your Hybrid Environment with Redgate
Join this Microsoft hosted webinar to hear from Microsoft MVP and Redgate Advocate, Grant Fritchey to learn more about monitoring hybrid database environments, as part of their Azure Series.
What is Power Query?
In this tip we'll introduce you to Power Query, the self-service data preparation tool from the Power BI family
It's All About the Gratitude
I'm writing this the day after the US holiday of Thanksgiving. Lots of things are said about Thanksgiving, positive, negative, in between. The core concept of the holiday is to take a moment to take stock of what you have. It's a good idea. Every so often, look around and acknowledge, depending on anyone's situation, […]
CData AWS Glue Connector for Salesforce Deployment Guide
AWS Glue is an ETL service from Amazon that enables you to prepare and load your data for storage and analytics. With Glue Studio, you can create no-code and low-code ETL jobs that work with data through CData Glue Connectors. In this article, we walk through configuring the CData Glue Connector for Salesforce to create and […]
How to filter non-existing records in SQL
Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]
A Q&A with Troy Hunt: What will you learn?
We really enjoyed the insightful, intelligent answers Troy gave to Steve Jones’s questions and invite you to enjoy the fascinating conversation in the webinar which is now available on-demand.
Power BI CONCATENATE Function: How and When to Use it
In this article we cover various ways join and concatenate data in Power BI by using the DAX CONCATENATE function.
Blogs
Dec 8 Webinar with Pavilion – Boost SQL Server on VMware Performance 400% with 2-Step Tuning
By kleegeek
Join us on December 8th at 10am Pacific time for an exciting new webinar!...
Daily Coping 3 Dec 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 2 Dec 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Foreign key in the column values of another table
I have trouble in writing a SQL query. I have a data table with...
How to increase performance to load a factless date-date-interval table
Hi all, I am currently having performance issues by populating one of my factless...
Linked Server Error
Hi Experts, I am getting the following error when i am trying to test...
Ask SSC