T-SQL Tuesday #80–Chris Yates’ Birthday
It’s the 80th version of T-SQL Tuesday. You can see all the parties from the past on my page, but...
2016-07-12
504 reads
Blog Posts
Finding, disabling and enabling foreign keys
Foreign keys are a classic method of enforcing RI (Referential Integrity). Unfortunately though, they can get in the way if...
2016-07-11 (first published: 2016-06-29)
1,962 reads
Monday Morning SQL Break – July 11, 2016
It’s Monday and time for this week’s blog and twitter round-up for last week. I spent the weekend with family...
2016-07-11
875 reads
Tips to Fix Database Consistency Errors – Reported By DBCC CHECKDB
Overview
While working on SQL Server, sometimes users get stuck in annoying situations when database become inaccessible. After executing DBCC CHECKDB...
2016-07-11
6,092 reads
Uninstalling SQL Server from the Command Line to Remove Unwanted Background Instances
I had a note (or ‘action item’) to make sure that people were informed regarding the ‘uninstall’ of SQL Server,...
2016-07-11 (first published: 2016-06-29)
88,421 reads
Basic Statistics with SQL – Introduction
I was a student of statistics in school and college. I didn’t get to use much of anything I learned...
2016-07-10
678 reads
SQL Server – String_Escape function in SQL Server 2016
Hi friends, in SQL server 2016 another string function that introduced is String_Escape. This function can escape special characters within...
2016-07-10
1,525 reads
AlwaysOn Availability Group Database Level Health Detection – SQL Server 2016
SQL Server 2016 AlwaysOn AG got many improvements, and I’m pretty impressed with the log throughput improvements and redo improvements...
2016-07-08 (first published: 2016-06-30)
7,208 reads
Converged virtual architectures and SQL Server licensing
Hyper-converged compute architectures, meaning clusters of physical servers with self-contained storage configured for a traditional SAN-less solution, are growing in...
2016-07-08
593 reads
Dallas, TX Fallen Officers Relief Fund
If you want to make a Donation to the Dallas, TX Fallen Officers Relief Fund, Please click this Link.
http://bluealert.us/
2016-07-08
401 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