The Azure SQL portfolio
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
Additional Articles
Flyway Without the Typing
How to use Flyway configuration files to minimize typing during ad-hoc development from PowerShell or DOS; you just type in the Flyway commands you need and hit "go" and the config files take care of all the tiresome connection, authentication and project details.
2021-09-17
Mount an Azure Data Lake Storage Gen2 Account in Databricks
In this article we will walk through a clear end-to-end process of securely mounting an ADLS gen2 account in Databricks.
2021-09-17
Text Mining and Sentiment Analysis: Oracle Text
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
Our Top Findings from The State of Database Monitoring Survey
Over 2500 global database professionals answered questions on their experiences with database monitoring in our annual survey earlier this year. We’re creating four reports from the findings and in our first, The real-world challenges of growing server estates, you’ll discover both insights and trends along with advice for how to tackle the most common challenges.
2021-09-13
SQL Server identity column
The SQL Server identity column is used to populate a column with incrementing numbers on insert. In this article, Greg Larsen explains how it works.
2021-09-13
Oracle sequences – 12c features including “identity”
Oracle added several enhancements to the sequence object in version 12c, including an “identity” column feature. Jonathan Lewis explains how to work with these new features.
2021-09-10
Register Now For PASS Data Community Summit 2021
Registration is now open for our free and online data platform conference. Join 1000s of your data peers at PASS Data Community Summit and get access to up to 5 days of training, sessions, networking activities, and events. This year's program has been carefully designed to help you achieve your goals, wherever you are in your data career.
2021-09-10 (first published: 2021-09-03)
Disable or Enable All SQL Server Agent Jobs
In this article we look at a PowerShell script that you can use to centrally enable and disable any SQL Server Agent Job on any instance of SQL Server.
2021-09-08
One Flyway Migration Script for Diverse Database Systems
How to create a single set of SQL migration scripts for Flyway that we can use across multiple database systems, or for all regional variants of a database.
2021-09-08
Blogs
Daily Coping 21 Sep 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
#PowershellBasics: Bulk insert.
In my last post I talked about invoke-sqlcmd. It’s a nice easy way to...
Lambda Architecture in data systems and possible meaning of this name
By Rayis Imayev
(2021-Sep-21) There is one scene in "The Core" movie that I really like when two geophysicists...
Forums
Can't attach MDF and LDF files
Hi All When I tried to attach my mdf and ldf file , I...
Social Media Link Aggrigator
Need a way to put all of your social media links and profiles into...
Issue with the format of calculation
Hello friends, This issue is a little hard to explain, but I hope you...
Ask SSC