Common SQL Server Mistakes - Shrinking Databases
I don’t like there being an easy command to shrink databases, and I especially don’t like seeing the shrink option...
2010-09-14
5,641 reads
SQL Bloggers – Build Your Brand And Sponsor SQLSaturday #49
As you may know we like to try new stuff here in Orlando, and this is another new thing. I’ve...
2010-09-13
612 reads
Quote of the Day
I do not usually post a quote of the day but since this is my own quote I decided to...
2010-09-13
360 reads
Tip: Use System Views to Compare Column Datatypes
Let’s say that you have a staging table, that then loads to a destination table in the same database. If...
2010-09-13
555 reads
T-12d till SQL Saturday #52 (CO)
SQL Saturday: All the COOL kids are doing it!
It’s only twelve days until SQL Saturday #52 in Colorado! I’ll be...
2010-09-13
712 reads
Space Coast User Group Recap
I had the pleasure of making my second annual September visit to the Space Coast SQL Server User Group in...
2010-09-13
342 reads
SQL Saturday #52 - Colorado
I will be speaking at SQL Saturday #52 - Colorado in a little less than two weeks. I am giving my...
2010-09-13
1,082 reads
Technical People Should Blog
I ran across a great blog titled: Post 300 or why all developers should be blogging. The reasons given in...
2010-09-13
1,226 reads
24 (28) Hours of PASS on Sep 15, 2010
It’s back with a slightly different format this time, 28 hours of seminars delivered over two days, and it’s all...
2010-09-13
575 reads
Getting Drive Info, Part 4, the SSIS Script Component
In this installment of the Getting Drive Info series (Part 1, Part 2, Part 3), SSIS will be used to collect and save the drive information. SSIS provides multiple...
2010-09-13
16 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