Resolving PolyBase Installation Errors in SQL Server 2016
One of the exciting new features you may want to explore in SQL Server 2016 is PolyBase. However, as I...
2016-07-15
1,394 reads
Blog Posts
Script to create demo database and load data for statistics and R
Make sure you have a working install of SQL Server 2016. The size of the database is only 8 MB.
USE...
2016-07-15
302 reads
Speaking at SQLSaturday Sacramento!
I’m proud to announce that I will be speaking at SQL Saturday Sacramento on July 23th 2016! This will be my third SQLSaturday event this year and I’m really excited...
2016-07-15
13 reads
Speaking at SQLSaturday Sacramento!
I’m proud to announce that I will be speaking at SQL Saturday Sacramento on July 23th 2016! This will be my...
2016-07-15
432 reads
SQL vs NoSQL
Introduction
Despite the traditional relational DB world, there’s also a trend for NoSQL. The NoSQL databases that enable storing unstructured and...
2016-07-15
4,646 reads
SQLServerZest is now DataGinger!
We are happy to announce the birth of DataGinger. Starting today we officially re-branded ourselves as DataGinger.com (previously SQLServerZest.com). The...
2016-07-15
400 reads
TGI Friday (Live Blog Day 4)
Its been long but productive week at Tree Tech
This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration in the...
2016-07-15
416 reads
Altering a column in a large table: A case study
Fair warning, this is a discussion piece. I had a task, I went through several possibilities and I’m going to...
2016-07-14
1,051 reads
Descriptive Statistics with SQL and R – 1
I started my re-discovery of statistics with an introduction here. This second post is about descriptive statistics – very basic, simple...
2016-07-14
1,117 reads
Get Your Email Out of my ETL
Question from someone in one my recent classes: “What tool do you use to send email from ETL processes?” My...
2016-07-14
678 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