SQL Servers

Getting Started in a SQL Server 2017 VM in Azure

You say you’re ready to dip your toes in the Azure ocean? Come on in, the water’s fine!<p>Oh, you want to really dip your toes. You’re starting with …

Databases

Manage databases in SharePoint 2013

The following articles about database management are available to view online. Writers update articles on a continuing basis as new information …

Databases

Steps in Creating Simple But Dynamic Powerful Web App using ASP.NET Core MVC connected to a Database

What is ASP.NET Core?<p>“ASP.NET Core is a cross-platform, high-performance, open-source framework for building modern, cloud-based, Internet-connected …

Software Development

Defining your multi-container application with docker

In this guide, the docker-compose.yml file was introduced in the section Step 4. Define your services in docker-compose.yml when building a …

DevOps

SqlBulkCopy.NotifyAfter Property

The following console application demonstrates how to bulk load data using a connection that is already open. The NotifyAfter property is set so that …

Databases

SQL Server 2017 and Dynamics NAV

SQL Server 2017 was released in October last year with many new and interesting capabilities. For further information, please take a look at the …

Microsoft Dynamics

Azure Function Apps: Trigger in Azure SQL /SQL Server to execute Azure Function

Ever thought of Azure SQL/ SQL Server Input Trigger for the Function app?<p>There is no predefined input trigger for SQL in Azure functions. Which means …

Databases

Creating a Microsoft Excel-Style Pivot Table With Grand Totals in SQL

This answer to a beautiful Stack Overflow question I've given recently needs further explanation in a blog post. When working with Microsoft Excel, …

Databases

Redgate acquires SQL Manager tool from SysKit for GDPR compliance

Redgate today acquired the SQL Manager tool from SharePoint and SQL Server solution provider SysKit. The tool will allow Redgate to provide the data …

Databases

On-premises data gateway - Power BI

The on-premises data gateway acts as a bridge, providing quick and secure data transfer between on-premises data (data that is not in the cloud) and …

Linux

SQL Server 2017 IDENTITY_CACHE feature

By: Rajendra Gupta | Read Comments | Related Tips: More > Identities<p>Problem<p>SQL Server 2017 provides many exciting features and enhancements over …

Databases

ASP.NET Core Logging with Serilog and SQL Server | Carl's Blog

Serilog is a great 3rd party library for structured logging in our ASP.NET core apps. Structured logging is key to producing easily readable and …

Software Development

Docker Windows SQL Server Containers and Database Clones

Microsoft’s adoption of Docker containers is a boon for continuous integration and DevOps initiatives, with .NET and Java application environments …

Databases

Microsoft

Join us as we explore how SQL Server 2017 brings the industry-leading Microsoft relational database engine to the enterprise Linux ecosystem with our …

Linux

An introduction to mssql-cli, a command-line client for SQL Server

Microsoft released SQL Server 2017 for Linux early this year. Now it is releasing mssql-cli, a cross-platform command-line client for SQL Server with …

Linux

Critical SQL Server Patches for Meltdown and Spectre

Everyone needs to learn about these hardware bugs and apply patches as soon as possible.

Databases

Monitoring MS SQL Server Performance with Wavefront Metrics-Driven Analytics

It’s always a challenge to optimize the performance of an application to be highly available and without customer-impacting latencies. For critical …

Databases

Looking into IT's crystal ball

So it is that time again when I try and gaze into the crystal ball and guess what 2018 will bring the IT world.<p>For an easy one, based on what …

Mobile

How Hotmail changed Microsoft (and email) forever | Ars Technica

Acquired December 1997, Hotmail was the gift that kept on giving—for good or ill.<p>Twenty years ago this week—on December 29, 1997— Bill Gates bought …

Microsoft

SQL Server DBA Morning Health Checks

Introduction: As a Microsoft Premier Field Engineer, I get to work with amazing colleagues who create incredible customer solutions. Patrick Keisler …

Databases

Execute and Track T-SQL Script Executions with PowerShell

Problem<p>We maintain an environment with thousands of databases for different applications and internal functions and have recently faced challenges …

Databases

Top stories from the VSTS community – 2017.12.29

Here are top stories we found in our streams this week related to DevOps, VSTS, TFS and other interesting topics.<p><b>TOP STORIES</b><p>My Top 5 Blog Posts of …

Software Development

Performing SQL Bulk Copy with Azure Automation/PowerShell while modifying source data

In this blog, I will be going over how to use AzureAutomation/PowerShell to perform bulk operations using bulk copy in SQL Server instances and as we …

SQL Server Stored Procedure to Calculate Database Backup Compression Ratio

By: Eli Leiba | Read Comments (4) | Related Tips: More > Compression<p>Problem<p>SQL Server offers the ability to create compressed backups, but it is hard …

Databases

Azure Log Analytics (OMS) Agent now collects SQL Server audit logs

We are happy to inform that the Azure Log Analytics (OMS) Agent is now capable of pushing SQL Server audit logs into Azure Log Analytics (OMS), …

Cloud Computing

Architecture overview for SQL Server Machine Learning Services

This topic describes the goals of the extensibility framework that supports execution of Python and R script in SQL Server.<p>It also provides an …

Databases

SQL Server Database Mail Health Check for all SQL Servers

By: Svetlana Golovko | Read Comments | Related Tips: More > Database Mail<p>Problem<p>Most of the SQL Server DBAs will agree that we rely on email alerts …

Databases

5 Big Microsoft Predictions for 2018

Like many other tech giants, Microsoft (MSFT) had a pretty good 2017. Its shares rose over 35% to new highs, and sales growth accelerated to a …

Tech Industry

DBCLI

PGCLI<p>Postgres Client<p>MYCLI<p>MySQL Client<p>MSSQL-CLI<p>MS SQL Server Client<p>VCLI<p>VerticaDB Client<p>pgspecial<p>Postgres meta commands.<p>cli_helpers<p>Common CLI helpers.

MS SQL

Troubleshoot Dynamics 365 for Finance and Operations, Enterprise edition on-premises - EE: Finance Operations, Dynamics 365

This topic provides troubleshooting information for on-premises deployments of Dynamics 365 for Finance and Operations, Enterprise edition.<p>Service …

Linux