SQL Server Interview Questions for Developers on Querying
In this article we look at some simple ways to test a SQL Server developers T-SQL skills with some query questions and answers.
2020-08-26
Articles
Configuring Availability Groups in Ubuntu
In this article, we will review how to configure Always On Availability Groups in Ubuntu Server using the Pacemaker cluster. The following are the high-level steps to configure Always On Availability Groups (AOAG) with an Ubuntu server. Install SQL Server on Ubuntu 16.04 Install Pacemaker agents and configure the cluster Create Always On Availability Groups Create […]
2020-08-25
3,620 reads
Redgate Streamed Returns
Our virtual community event is back with a global feel. Featuring speakers including Donovan Brown, Abel Wang, Kendra Little & Damian Brady, we have a full day of live content & networking opportunities, spanning world-wide time zones. So, wherever you are in the world, join us live on Wednesday August 26.
2020-08-25
Subset in R including List, Data Frame, Matrix and Vector
In this article we will examine the R Language subsetting operators, types of subsetting and differences in behavior for different R objects like vectors, lists, and data frames.
2020-08-25
An Introduction to Azure Synapse Analytics Workspace
Introduction The Azure Synapse workspace is in preview mode as of July 2020. The workspace brings together enterprise data warehousing and big data analytics. This workspace has the best of the SQL technologies used in enterprise data warehousing, Spark technologies used in big data analytics, and pipelines to orchestrate activities and data movement. Here, I […]
2020-08-24
12,825 reads
Clarifying Data Warehouse Design with Historical Dimensions
The standard data warehouse design from Kimball with facts and dimensions has been around for almost 25 years. In this article, Vince Iacoboni describes another way to design slowly changing dimensions.
2020-08-24
Deployment Suite for Oracle: What’s New? Git Integration in Redgate Change Control v3.0
In Redgate Change Control v3.0, you can now commit your database changes to your local Git repository and collaborate with your team by pushing and pulling changes from the remote Git repository. If you’re using branches, you can also create and switch Git branches from within Redgate Change Control.
2020-08-24
Native SQL Backups for Amazon RDS Databases
Use native SQL Server backups with Amazon RDS databases to easily import and export data between local server and the AWS cloud.
2020-08-21 (first published: 2018-12-13)
4,234 reads
Compare Artificial Intelligence Models Built with T-SQL
This tip looks at using artificial intelligence models with SQL Server to predict outcomes.
2020-08-21
Getting started with SQL Server stored procedures
In this article we look at different examples of creating SQL Server stored procedures.
2020-08-20
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers