SQL Server database basics
So today I'll talk about some of the basic items for SQL server that helps to understand the reason of some performance recommendations. This first post will list and...
2017-09-16
18 reads
SQL Server database basics
So today I'll talk about some of the basic items for SQL server that helps to understand the reason of...
2017-09-16
144 reads
I want a new gadget with less features
Years ago I bought a Pebble smartwatch. I didn’t back the Kickstarter, but a few friends did and I liked...
2017-09-15
910 reads
PASS Summit 2017 Precon – Virtual SQL Servers: Right to Ludicrous Speed
PASS has continues to ramp up the plans for the PASS Summit in Seattle this October, and my precon session, “Virtual...
2017-09-15
165 reads
PASS Summit 2017 Precon – Virtual SQL Servers: Right to Ludicrous Speed
PASS has continues to ramp up the plans for the PASS Summit in Seattle this October, and my precon session, “Virtual...
2017-09-15
370 reads
The Code Coverage Report
I had someone that told me recently that they needed to find a way to get code coverage in T-SQL....
2017-09-15
868 reads
Friday Reading 2017-09-15
Excited for next week as I’m heading down to Cork to speak at the User Group there. Over 3 years...
2017-09-15
374 reads
Error Processing Tabular – Method Not Found
Very quick blog post today. While setting-up a development server at a client who is still using SQL Server 2012,...
2017-09-15
387 reads
Columnstore Indexes – part 112 (“Linked Servers”)
Continuation from the previous 111 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost is focusing on the Server...
2017-09-20 (first published: 2017-09-14)
1,722 reads
Multi Script Removes 25 Database Limit
I woke up to a Slack message that alerted me to a post in one of our channels. An engineer...
2017-09-22 (first published: 2017-09-14)
2,437 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