Redgate Hub

  • Product articles
  • University
  • Events
  • Forums
  • Community
  • Simple Talk
  • Home
  • Cloud
  • DevOps
  • Sysadmin
  • Development
  • Databases
  • Opinion
  • Books
  • Blogs
  • Log in
  • Sign up
  • Home
  • Databases
  • SQL Server
Greg Larsen
21 October 2022
Greg Larsen
21 October 2022

The Basics of Updating Data in a SQL Server Table

0
2
  • Learn SQL Server
  • T-SQL Programming
Once data is inserted into a table, data typically needs to be maintained as time goes on. To make changes to an existing row or a number of rows, in a table, the UPDATE statement is used. This article shows how to use the UPDATE statement to modify data within a SQL Server table. Syntax … Read more
Greg Larsen
04 October 2022
Greg Larsen
04 October 2022

The Basics of Inserting Data into a SQL Server Table

0
9
  • Learn SQL Server
Before data can be read from of a SQL Server database table, the table needs to contain rows of data. One of the most typical ways to get data into a table is to use the INSERT statement. One row or multiple rows can be inserted with a single execution of an INSERT statement. You … Read more
Louis Davidson
30 September 2022
Louis Davidson
30 September 2022

Generating Repeatable Sets Of Test Rows

0
2
  • Blogs
  • T-SQL Programming
In order to test graph structures, I needed a large set of random data. In some ways, this data will resemble the IMDB database I will include later in this chapter, but to make it one, controllable in size and two, random, I created this random dataset. I loaded a set of values for an … Read more
Greg Larsen
27 May 2022
Greg Larsen
27 May 2022

Summarizing data using GROUP BY and HAVING clauses

0
13
  • Learn SQL Server
  • T-SQL Programming
You can summarize data to get counts, averages, sums, and more using GROUP BY in T-SQL queries. Greg Larsen shows you how.… Read more
Dennes Torres
25 May 2022
Dennes Torres
25 May 2022

Datamarts and exploratory analysis using Power BI

0
25
  • BI
During Build 2022, Microsoft announced a new feature, Datamarts for Power BI. MVP Dennes Torres explains this new feature and provides and example. … Read more
Dennes Torres
24 May 2022
Dennes Torres
24 May 2022

Azure Synapse Link for SQL: From production to a data warehouse in a few clicks

0
3
  • BI
Microsoft announced Azure Synapse Link for SQL. In this article, MVP Dennes Torres explains the new feature.… Read more
Edward Pollack
11 May 2022
Edward Pollack
11 May 2022

Insights from the SSRS database

0
18
  • BI
The SSRS database contains a wealth of undocumented information that can help administrators. In this article, Edward Pollack explains how to get to the data and ways to use it.… Read more
Edward Pollack
27 April 2022
Edward Pollack
27 April 2022

Getting results using less T-SQL

0
23
  • T-SQL Programming
There is usually more than one way to write a query. In this article, Edward Pollack explains a few ways to write simpler T-SQL code.… Read more
Greg Larsen
21 April 2022
Greg Larsen
21 April 2022

The ins and outs of joining tables in SQL Server

0
12
  • Learn SQL Server
Most database queries require joining tables. In this article, Greg Larsen explains the ins and outs of joining tables in SQL Server.… Read more
Priyanka Chouhan
21 April 2022
Priyanka Chouhan
21 April 2022

SQL Server vulnerabilities and assessment

0
3
  • Security
SQL Server has many features to keep the database secure, but you must implement them to benefit. In this article, Priyanka Chouhan describes how to do a vulnerability assessment of SQL Server.… Read more
Dennes Torres
18 April 2022
Dennes Torres
18 April 2022

How to automate table level refresh in Power BI

0
5
  • Azure
  • BI
You can automate Power BI table refreshes using PowerShell, an Automation Account, and Runbook. Dennes Torres explains how in this article.… Read more
Sanil Mhatre
06 April 2022
Sanil Mhatre
06 April 2022

Finding deeper insights with Topic Modeling

0
3
  • BI
  • Python
Topic modeling can be used to find more detailed insights into text than a word cloud can provide. Sanil Mhatre walks you through an example using Python.… Read more
Adam Aspin
22 March 2022
Adam Aspin
22 March 2022

Tips and tricks with DAX table functions in paginated reports

0
6
  • BI
There are several common challenges when creating paginated reports from Power BI datasets. In this article, Adam Aspin explains how to work around several of these issues.… Read more
Greg Larsen
18 March 2022
Greg Larsen
18 March 2022

Ordering a result set in SQL Server

0
13
  • Learn SQL Server
To guarantee the order of a result set, you must use an ORDER BY clause. In this article, Greg Larsen explains what you need to know about ORDER BY.… Read more
Greg Larsen
22 February 2022
Greg Larsen
22 February 2022

The basic T-SQL SELECT statement

0
5
  • Learn SQL Server
  • T-SQL Programming
The SQL language is used across many relational database platforms. Greg Larsen explains the basics of the SELECT statement for SQL Server.… Read more
Adam Aspin
15 February 2022
Adam Aspin
15 February 2022

DAX table functions for paginated reports: Part 2

0
9
  • BI
To return detail data using DAX, use the table functions. Adam Aspin covers UNION, EXCEPT, INTERSECT, and CALCULATETABLE in this article.… Read more
Dennes Torres
07 February 2022
Dennes Torres
07 February 2022

Eight Azure SQL configurations you may have missed

0
12
  • Azure
  • SQL Server
Azure SQL Database has been around for over ten years and is constantly evolving with new capabilities and options. Dennes Torres explains 8 features and best practices of Azure SQL Database.… Read more
Adam Aspin
21 January 2022
Adam Aspin
21 January 2022

DAX table functions for paginated reports: Part 1

0
7
  • BI
Several DAX table functions can be used for paginated reports when you want all the data, not a summary. Adam Aspin explains how to use DAX table functions for paginated reports.… Read more
Greg Larsen
20 January 2022
Greg Larsen
20 January 2022

When to use CHAR, VARCHAR, or VARCHAR(MAX)

0
43
  • Learn SQL Server
It’s important to choose the right datatypes when designing a database. Greg Larsen explains the differences between CHAR, VARCHAR and VARCHAR(MAX).… Read more
Edward Pollack
19 January 2022
Edward Pollack
19 January 2022

Vertipaq optimization and its impact on columnstore compression

0
4
  • BI
Vertipaq optimization is a critical component of the columnstore compression process. Edward Pollack explains how it works and what you need to know to manage it.… Read more
PreviousNext
  • 1
  • 2
  • 3
  • …
  • 57
  • BI
  • Database Administration
  • Learn SQL Server
  • Performance
  • Security
  • T-SQL Programming
  • Tools
Subscribe to the SQL Server RSS feed

Subscribe for more articles

Fortnightly newsletters help sharpen your skills and keep you ahead, with articles, ebooks and opinion to keep you informed.

Simple Talk

  • FAQ
  • Sitemap
  • About Simple Talk
  • Contact Us