Installing dbatools on WS2012 R2
This is actually a simple, short post, but writing helps me remember things, and since I had to learn this,...
2017-01-20
928 reads
Retrieve a List of Files from FTP using SSIS
The FTP protocol is one of the oldest methods for sharing and moving files. Although frequently considered to be an “old-school”...
2017-01-27 (first published: 2017-01-20)
1,515 reads
Friday Reading 2017-01-20
Been an interesting week! My site has had the most views ever (so chuffed) and during all that I’ve been...
2017-01-20
520 reads
MVPs
I was having a conversation with Oracle professionals the other day and they started to discuss the Oracle ACE program...
2017-01-20
663 reads
Adding Application Name to Invoke-SqlCmd2
In a previous post, I expressed some frustration over Invoke-SqlCmd not setting an Application Name for its ODBC connection, leaving us with the generic .NET SqlClient Library when looking at active sessions...
2017-01-20
64 reads
What is a Database Master Key?
The encryption mechanisms in SQL Server are interesting, and they work well, but they are somewhat poorly named. I ran...
2017-01-19
17,090 reads
Webinar: Introducing Minion CheckDB!
Minion CheckDB is available for download as of February 1, 2017! In celebration, we’re having a Minion CheckDB webinar on two...
2017-01-19
833 reads
Help me raise money for cancer research #tourneeminerale
In Belgium, a national campaign is launched to raise money for cancer research: #TourneeMinerale. In this campaign, people can be...
2017-01-19
562 reads
SQL Server - Monitoring Table Size
There are many situations when we want to know the size of our database tables or just need a list...
2017-01-19
699 reads
Speaking at PowerShell Virtual Group of PASS
This month I’ll be speaking to the PowerShell Virtual Chapter of PASS. The session is on Linux OS Fundamentals for the SQL Admin. At the core of the session...
2017-01-19
10 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