Slides and Files: A PowerShell Primer
Here are the slides and scripts from last night's presentation at Midlands PASS Chapter. The presentation was intended to introduce...
2010-09-15
1,029 reads
Blog Posts
2010-09-15
909 reads
TSQL Tuesday Indexes and Blobs
Woohoo – chugga chugga chugga chugga – woo woo. The train is pulling into town once again for another installment in the...
2010-09-15
1,755 reads
Using Excel As A Reporting Services Datasource
It’s been said that Excel is the poor man’s database. I don’t know about that, but I can tell you...
2010-09-15
915 reads
An Index on Indexing #TSQL2sDay
Here we are with another T-SQL Tuesday and time for my entry into the fray. This month we are talking...
2010-09-14
729 reads
Brief Intro to Indexes and INCLUDE – TSQL Tuesday #10!
Content rating: Beginner
This blog was originally posted on December 17, 2009. I’ve pulled it out of the closet for...
2010-09-14
694 reads
Broken or Just Bent? #passvotes
Though things have died down a bit since the initial backlash, the recent development in the PASS board election process...
2010-09-14
708 reads
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
Failing Fast
I’ll have a longer post next week about my own risk strategy, but I wanted to write this first, both...
2010-09-14
621 reads
How is Fill Factor Impacting My Indexes?
The theme for this month's T-SQL Tuesday is indexes so it seemed like the perfect excuse to blog about a script that I have written to see what choices...
2010-09-14
9 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