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
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
5
  • 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
7
  • 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
4
  • 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
33
  • 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
3
  • 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
Greg Larsen
04 January 2022
Greg Larsen
04 January 2022

How to replace an identity column with a sequence number

0
8
  • Learn SQL Server
  • Theory and design
SQL Server provides two ways to include an incrementing number in a table. Greg Larsen explains how to replace an identity column with a sequence number.… Read more
Joe Celko
27 December 2021
Joe Celko
27 December 2021

Quantifier predicates

0
3
  • T-SQL Programming
Predicates in SQL are often complex and difficult to understand. In this article, Joe Celko explains the logic behind a few of the predicates: EXISTS, SOME, ANY and ALL.… Read more
Adam Aspin
17 December 2021
Adam Aspin
17 December 2021

How to filter DAX for paginated reports

0
5
  • BI
DAX is unlike SQL when filtering. In this article, Adam Aspin demonstrates how to filter DAX for paginated reports.… Read more
Greg Larsen
30 November 2021
Greg Larsen
30 November 2021

How to return multiple sequence numbers with sp_sequence_get_range

0
4
  • Learn SQL Server
Developers can work with multiple range values at once using sp_sequence_get_range. Greg Larsen explains how to return multiple sequence numbers with sp_sequence_get_range.… Read more
Adam Aspin
15 November 2021
Adam Aspin
15 November 2021

Introduction to DAX for paginated reports

0
11
  • BI
SSRS reports can be built using DAX. In this article, Adam Aspin explains how to get started using DAX to build the reports.… Read more
Joe Celko
15 November 2021
Joe Celko
15 November 2021

BETWEEN the two of us

0
13
  • T-SQL Programming
BETWEEN can be used in a SQL WHERE clause to filter on a range. Joe Celko explains the history of BETWEEN and also could be implemented.… Read more
Greg Larsen
15 November 2021
Greg Larsen
15 November 2021

Using SQL Server sequence objects

0
6
  • Learn SQL Server
SQL Server sequence objects have several properties that control how they behave. Greg Larson explains the options of using SQL Server sequence objects.… Read more
Robert Sheldon
01 November 2021
Robert Sheldon
01 November 2021

Ransomware: A world under threat

0
5
  • Security
Ransomware has threatened many organizations over the past few years. In this article, Robert Sheldon explains the history of ransomware and what needs to be done to protect against it.… Read more
Greg Larsen
25 October 2021
Greg Larsen
25 October 2021

Introduction to SQL Server sequence objects

0
7
  • Learn SQL Server
SQL Server sequence objects can be used in place of identity columns. In this article, Greg Larsen explains how to set up and use sequence objects.… Read more
Sanil Mhatre
18 October 2021
Sanil Mhatre
18 October 2021

Text Mining and Sentiment Analysis: Data Visualization in Tableau

0
2
  • BI
Tableau is a popular visualization tool used by organizations around the world. In this article Sanil Mhatre demonstrates sentiment analysis with Tableau and Oracle data. … Read more
Edward Pollack
04 October 2021
Edward Pollack
04 October 2021

Automating Extended Events data collection

0
4
  • Performance
It’s not difficult to set up an extended event session, but reviewing and saving the data can be complex. In this article, Edward Pollack demonstrates how to collect extended event data.… Read more
PreviousNext
  • 1
  • 2
  • 3
  • …
  • 56
  • BI
  • Database Administration
  • Learn SQL Server
  • Performance
  • Security
  • T-SQL Programming
  • Tools

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