What to monitor for SQL Server security

• by Additional Articles

• SimpleTalk

• SQL Server security

Keeping databases secure is critical. In this article, Robert Sheldon explains what to monitor for SQL Server security.

Always Retry

• by Steve Jones

• SQLServerCentral

• software development

Retry logic is coming to the SqlClient driver.

Load Multiple Excel Files and Worksheets with SSIS

• by pramodh kumar tammana

• SQLServerCentral

I was asked to load multiple Excel files, each with multiple Excel worksheets. I found a very easy way to complete this in SSIS using a Script Task. This article will explain how I did this. For this example, I have two Excel files, File1.xlsx and File2.xlsx, as shown here: Each Excel File has three […]

Power Apps Canvas Apps Examples

• by Additional Articles

• MSSQLTips.com

• Microsoft

In this article we will focus on Power Apps canvas apps which are natively optimized for mobile devices and we will look at potential use cases for canvas apps.

SQL Monitor v11.1 now supports Azure SQL Managed Instances

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

Migration to the cloud and PaaS solutions has accelerated in the past years, and many organizations now manage hybrid estates. To reflect this, the latest release of SQL Monitor adds Azure SQL Managed Instances to its list of supported cloud platforms. This article explains how to monitor performance and activity for Azure SQL Managed Instances using SQL Monitor, with advice on monitoring hybrid estates and migrating from on-prem to Azure SQL Managed Instance.

Bug Management

• by Steve Jones

• SQLServerCentral

• software development

Google is sponsoring open source projects with development resources.

Stairway to Advanced T-SQL Level 4: Record Level Processing Using Transact-SQL Cursors

• by Gregory Larsen

• SQLServerCentral.com

Using a CURSOR is not normally the best way to process through a set of records. Yet when a seasoned programmer moves to writing TSQL for the first time they frequently look for ways to process a sets of records one row at a time. They do this because they are not used to thinking about processing records as a set. In order to process through a TSQL record set a row at a time you can use a cursor. A cursor is a record set that is defined with the DECLARE CURSOR statement. Cursors can be defined as either read-only or updatable. In this article I will introduce you to using cursors to do record level processing one row at a time.

Using Data Science And Machine Learning In Identifying Fraudulent Activities

• by siddharthray123

• SQLServerCentral

• Machine Learning (ML)
• R Language

A look at one way to detect fraud using R and a machine learning model.

Digital Event: Innovate Today with Azure SQL

• by Additional Articles

• Redgate

• Conferences, Classes, Events, and Webinars

Join Microsoft's Rohan Kumar, and a full team of Azure SQL experts, for Innovate Today with Azure SQL. This free digital event from Microsoft lets you choose the sessions and technical demos that are most interesting to you and focus on the capabilities and possibilities that you want to learn more about.

Oracle sequences: The basics

• by Additional Articles

• SimpleTalk

• Oracle

Oracle sequences can be used to create artificial IDs for a table. In this article, Jonathan Lewis explains how they work under-the-hood.