Running SSMS 2016 in Read Uncommitted Mode
Back in July when we received the first official release of SSMS not tied to an engine release we got...
2017-02-01 (first published: 2017-01-25)
2,045 reads
Transaction log shipping in SQL Server on Linux
SQL Server on Linux has been out for a bit now and I’ve played around a little (see here) but...
2017-01-30 (first published: 2017-01-25)
2,128 reads
Interactive query experience for SQL databases
This is a new feature where you can issue TSQL commands via a TSQL editor straight from the Azure portal,...
2017-01-25
618 reads
JSON Support Is The Best New Developer Feature in SQL 2016 — Overview Part 1: Parsing JSON
As a developer my favorite new feature of SQL Server 2016 is JSON support.
I love JSON in SQL because I already love JSON everywhere outside of SQL: it uses...
2017-01-24
23 reads
5 Characteristics Every Leader Should Practice
The word leadership has many synonyms attributed to it. Something that can be learned early on in one’s career is that...
2017-01-24
732 reads
Power BI Custom Visuals Class (Module 35 – Box and Whiskers (Jan Pieter))
In this module you will learn how to use the Box and Whiskers (Jan Pieter) Power BI Custom Visual. This...
2017-01-31 (first published: 2017-01-24)
1,754 reads
What Is Your Career Investment Portfolio?
Every year, financial advisors will recommend their clients to take a review of their investment portfolio and make necessary changes...
2017-01-23
735 reads
Useful #SQLPrompt Tips
One of the tools that Redgate write is SQL Prompt. This might be my favorite product, and I’m constantly impressed...
2017-01-23
710 reads
How to Exclude Entire Sections in VS Schema Compare
Right now I am so excited, and a little embarrassed. After using Visual Studio (VS) for database projects for the...
2017-01-23
6,233 reads
SQL Server 2016: JSON integration
Abstract
This article helps to explain the application of JSON data and the use of new SQL 2016 constructs that enable...
2017-01-23
5,408 reads
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers