Additional Articles

New release: SQL Prompt 10

by Additional Articles

Redgate

SQL PROMPT

In the latest version of SQL Prompt, we’ve made improvements to all the most popular features. Our new ranked suggestions algorithm prioritizes the suggestions most relevant to you, tab history improvements let you find old tabs easily and star favorites, and new auto-fixes help you resolve code issues quickly. With support for key features of SQL Server 2019, which was made available this week at Microsoft Ignite, SQL Prompt 10 gives you the latest tools to develop faster, improve code quality, and boost team productivity.

2019-11-15

Power BI Workbooks

by Additional Articles

MSSQLTips.com

Power BI

Power BI Workbooks | Step by Step - In this tip we look at how to work with Power BI workbooks and in the previous tip we looked at working with Power BI datasets.

2019-11-14

Unwrapping, Unboxing and Installing SQL Clone

by Additional Articles

Redgate

SQL Clone

If you are evaluating a tool such as a text editor or spreadsheet, it is easy: you just install it, you run it, you decide whether you need it. Job done. However, a similar 'unboxing' or 'unwrapping' of SQL Clone, and installing across a network, is not so quick and easy. Phil Factor's solution is to install and run a complete installation of SQL Clone on a single box. This allows you to try everything out, creating images and deploying clones, while isolated from the network. It can then be extended across a network, subsequently, when it's been fully tested.

2019-11-14

Free Solution Brief – Dedicated Database Environments for Dev, Test and CI

by Additional Articles

Redgate

SQL Provision

Developers and testers can be blocked from having a local, private database to work in because of disk space, refresh times, and data privacy. Download this free solution brief to learn how SQL Provision removes these blockers and enables production-like data to be delivered at speed. Download now.

2019-11-13

Hosting a Machine Learning Model in ASP.NET Core 3.0

by Additional Articles

SimpleTalk

Data Science

Microsoft introduced the ML.NET framework which can be used by developers to include machine learning models in their applications. In this article, Dino Esposito discusses hosting a machine learning model in ASP.NET Core 3.0.

2019-11-13

ASP.NET Core with GitOps: Dockerizing an API on AWS EC2

by Additional Articles

SimpleTalk

Containers

As more shops begin automating build and deployment pipelines, it’s critical to learn about containerization. In this article, Mircea Oprea walks you through deploying an ASP.NET Core API in a Docker container.

2019-11-12

Compare SQL Server Results of Two Queries

by Additional Articles

MSSQLTips.com

Comparison

Code Tuning | Data Comparison | T-SQL Samples - In this tip we look at a simple way to compare the output from two different queries that are supposed to provide the same output to make sure the query results are exactly the same for both.

2019-11-11

Discuss

Why you should include the database in your 2020 IT strategy

by Additional Articles

Redgate

DevOps and Continuous Delivery (CI/CD)

With 2020 just around the corner, organizations of all shapes and sizes are considering what the next 12 months plans should look like. Here is what you need to know about including the database in your plans.

2019-11-11

What’s New in SQL Server 2019

by Additional Articles

Brent Ozar Blog

SQL Server 2019

In this video Brent takes a 40-minute look at some of his favorite new features: deferred compilation for table variables, adaptive memory grants, adaptive joins, and air_quote_actual plans

2019-11-08

How Fiducia & GAD scaled with SQL Monitor

by Additional Articles

Redgate

When growth was expected on the horizon for Fiducia & GAD, hiring more DBAs was not an option. With SQL Monitor they were able to scale at an unprecedented rate- 150 new servers and 70+ applications in one year.

2019-11-07

All authors

Additional Articles

New release: SQL Prompt 10

Power BI Workbooks

Unwrapping, Unboxing and Installing SQL Clone

Free Solution Brief – Dedicated Database Environments for Dev, Test and CI

Hosting a Machine Learning Model in ASP.NET Core 3.0

ASP.NET Core with GitOps: Dockerizing an API on AWS EC2

Compare SQL Server Results of Two Queries

Why you should include the database in your 2020 IT strategy

What’s New in SQL Server 2019

How Fiducia & GAD scaled with SQL Monitor

Blogs

In Memory of Andrew Clarke, AKA Phil Factor

Leading Through the Noise: Harnessing Data in the Age of Digital Overload

A New Word: Anderance

Forums

taking the rcsi dive

Parameter Sensitive Plan Optimization in SQL Server 2022

Minimum Change Tracking Retention

Question of the Day

Minimum Change Tracking Retention