Too many Foreign Keys
I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some couple of foreign keys and up to 20, 30 and similar....
2016-03-10
17 reads
Blog Posts
New developer build of SQL Code Guard released
Issues fixed since last developer build
[*] fixed incorrect binding of MI008 to MI007
[*] fixed xtra EI028 in case with named...
2016-03-09
1,001 reads
Notes from SQLSaturday Tampa 2016
Quick notes:
Speaker dinner at Spaghetti Warehouse. Good location, but just a little confined and a little noisy. Perfect location is...
2016-03-09
616 reads
Notes From the February 2016 OPASS Meeting
I gave my presentation on automating restores. Part philosophy (why you need it) and part tech (one way to do...
2016-03-09
640 reads
PowerShell – Backup Individual database and delete all it’s respective files by keeping a recent file
Problem Statement
The requirement is to backup individual database and after successful backup the script should retain the most recent file...
2016-03-09 (first published: 2016-02-29)
2,135 reads
Quick PS script to get SQL Server Configuration Aliases - Syndication – WaterOx Consulting
Aliases! They can be quite helpful, but they can also be a major pain when setting up new servers or...
2016-03-09
801 reads
SQL server on Linux
Microsoft accounted yesterday that SQL server will plan run in Linux, with early private preview available today along with full...
2016-03-09
2,262 reads
SSC Editorial: Lessons From Little Green Army Men
This one is about spending time with my daughter – she bought some army men as a toy after a visit...
2016-03-09
527 reads
SSC Editorial: Spousal Surcharges
I had to laugh as I write this, the “Spousal Surcharges” title is awfully close to clickbait. The topic is...
2016-03-09
482 reads
Tuga IT 2016 – Registrations are open
The registrations for Tuga IT 2016 are finally open: http://tugait2016.eventbrite.com, hurry up cause we are starting to promote it very...
2016-03-09
597 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