#TribalSQL: A new book by new voices in SQL Server
Two years ago, we were talking about how cool it would be to get a bunch of unpublished authors to...
2013-09-17
529 reads
Understanding SQL Query Optimization – (Part 1)
Most of the activity of the database server is related to queries. Because of this, query optimization is often a...
2013-09-17
992 reads
PowerShell – Script to Monitor a Service on a Group of servers – HTML Formatted Email Output
This post explains how to monitor a given service on a group of servers. The function Get-ServiceStatusReport comprises of various cmdLets...
2013-09-19 (first published: 2013-09-17)
3,258 reads
Guide to SQL Server Table Indexes – (Part 4)
Checkout the part-4 of my five part article series on Guide to SQL Server Table Indexeshere, in which you will learn...
2013-09-17
522 reads
Great Idea: Tribal SQL
Writing books, even just a chapter, is not easy. Yet, people are desperate to do it for some reason. But,...
2013-09-17
844 reads
Planning for Recovery
A database server is generally a mission critical component. Having a recovery plan is essential to ensure the business can...
2013-09-17
430 reads
Understanding SSIS Package Configurations
Managing changes to environment dependent variables is common and critical in any ETL application, especially during deployment of SSIS packages....
2013-09-17
768 reads
Understanding SQL Server Full-text Indexing – (Part 2)
Checkout the final part of this two part article series here, in which I discussed how to create full-text index...
2013-09-17
551 reads
Understanding SQL Server Full-text Indexing – (Part 1)
SQL Server allows applications and users to execute full- text search queries against character based data in SQL Server tables....
2013-09-17
641 reads
Geometry in the Cloud - where geospatial data meets the cloud.
Mount Olympus: Stratosphere: It was inevitable that two innovative technologies would merge to create a world of potential in the...
2013-09-17
1,561 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