SQL

The Azure SQL portfolio

• by Additional Articles

• SimpleTalk

• Azure

• Article

Microsoft provides many ways to run SQL Server in Azure, but which do you choose? In this article, Robert Sheldon explains the Azure SQL options.

2021-09-20

Text Mining and Sentiment Analysis: Oracle Text

• by Additional Articles

• SimpleTalk

• BI

• Article

Oracle has built-in functionality to analyze text. Sanil Mhatre demonstrates how to perform a sentiment analysis on data stored in a table using Oracle Text.

2021-09-15

Improving performance with instant file initialization

• by Additional Articles

• SimpleTalk

• Database Administration

• Article

Instant file initialization can speed up database creation, file growth, and restores. Greg Larsen explains how to configure it and how it works.

2021-08-18

How to query private blob storage with SQL and Azure Synapse

• by Additional Articles

• SimpleTalk

• Azure

• Article

Azure storage can be marked Private to control access. Dennes Torres explains how to query private blob storage with SQL and Azure Synapse.

2021-08-13

SQL Features Explorer

• by Thirunavukkarasu

• SQLServerCentral

• Article

Working as a DBA or developer, one needs to check from time to time about the availability of a particular feature on different SQL Server versions and editions. Hence to avoid the complexity of the search process we have developed a tool that helps DBAs and developers to verify the selected features' availability on all […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (3)

Log in or register to rate

You rated this post out of 5. Change rating

2021-08-06

5,542 reads

• Discuss

How to Compare Two SQL Prompt Styles

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

A PowerShell function that will compare two SQL formatting styles, saved in JSON, and produce a report showing the differences between the options they use to lay out your SQL code.

2021-07-26

Introduction to generic Power BI themes

• by Additional Articles

• SimpleTalk

• Power BI

• Article

Formatting Power BI visuals can be tedious. In this article, Adam Aspin explains custom Power BI themes that will save you time when creating reports.

2021-07-02

Creating and Maintaining a SQL Code Snippet Library

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

How to save all your different types of SQL code snippets in a central library of JSON Snippet Collections, where you can search and edit each collection and then write them out as individual code snippets, for use in SQL Prompt, SSMS or your programmer's clipboard.

2021-06-28

Redgate Streamed: Embracing technology trends for database success

• by Additional Articles

• Redgate

• Conferences, Classes, Events, and Webinars

• Article

Innovating in the database is crucial for success, and we’re seeing new trends impact the database, like cloud migration, SRE, and the growing need for big data and tools to support growing estates. On 23 June, Redgate Streamed brings you organizations who have implemented these database technology trends, including speakers from Google, Microsoft, and AWS, who will share their success stories and tips for embracing technology changes.

2021-06-07

The changing landscape of continuous database integration

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

Considering introducing continuous database integration? Learn the principles in this ThoughtWorks webinar hosted by Pramod Sadalage, expert in this discipline and author of several books about database refactoring and development.

2021-06-04