Determine if Directory Exists using xp_cmdshell
Recently, I came across a forum post from a user trying to determine if a directory existed in the file...
2010-10-06
14,382 reads
Blog Posts
One Meel-ee-yon Posts
We crossed the 1,000,000 post mark on SQLServerCentral today and that’s very cool to me. A few others as well...
2010-10-06
430 reads
PASSMN Board of Directors Nominations
It’s that time of the year again. Time to get in some nominations for the 2011 PASSMN Board of Directors. ...
2010-10-06
1,101 reads
Return of Index Analysis Part 2
Let’s Anaylze An Index!Time for part two of my continued Index Analysis query. The previous posts in this series are:
Analyze...
2010-10-06
1,043 reads
So I Got Promoted, Now What? Get To Know Your Peers
[This is part four in a series of posts about how to effectively transition to your new role after being...
2010-10-06
804 reads
Speaking Ideas - Plan to End
Over the years I’ve seen probably hundreds of technical presentations. I’ve seen good ones, bad ones, on all sorts of...
2010-10-06
335 reads
SQL Saturday 58 Schedule Released
We technically released it on Monday but I didn’t want to blog about it for a couple days since we...
2010-10-06
746 reads
SQLSaturday #49 (Orlando) Is Right Around The Corner - Have You Registered?
As I write this SQLSaturday #49 in Orlando is right around the corner - October 16, to be exact. My friends...
2010-10-06
465 reads
Stop Forgetting the DAC
From time to time I hear of DBAs that had to restart the SQL Server service on a 2005 or...
2010-10-06
967 reads
Upcoming October Events
During October I’ll be presenting at several online and in-person events
LocationDateSessionSQL Saturday #49 Orlando 2010Oct 16th ETL with PowerShellPASS PowerShell...
2010-10-06
861 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