Data gateway confusion
Microsoft has created data gateways as a way that cloud products such as Power BI and Azure Machine Learning can...
2016-12-21
431 reads
Run Book, Run!!!
How many of you actually have a “Hit-by-the-Bus” handbook? What is that, you ask? It is a document that explains...
2016-12-21
1,240 reads
sp_helptext vs object_definition()
I’ve been using sp_helptext for years. Honestly I probably end up using it at least once a day. But I...
2016-12-21
1,917 reads
SQL Agent Permissions
Problem
I was contacted by a user asking if it was possible for his team to be able to execute specific...
2016-12-21
2,615 reads
SQL Server and Hyper-threading
This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation for them. Licensing is given at the end of...
2016-12-20
34 reads
SQL Server and Hyper-threading
This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation for them. Licensing is given at the end of...
2016-12-20
19 reads
SQL Server and Hyper-threading
This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation...
2016-12-20
279 reads
Implementing Fuzzy Sets in SQL Server, Part 6: Fuzzy Numbers and Linguistic Modifiers
By Steve Bolton
…………I’ve written several amateur tutorial series on this blog in order to more quickly absorb difficult data mining,...
2016-12-30 (first published: 2016-12-20)
2,229 reads
Database Configuration
It’s amazing just how much the landscape changed with the release of SQL Server 2016 SP1. For example, I just...
2016-12-20
466 reads
The New PASS Logo and More
Change is not always easy. In fact, change is hard.
“Change” is a word from which some people shy away, and...
2016-12-20
342 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