Find my git remote
I work on a few projects and have a bunch of demos setup, but I don’t work on them all...
2016-12-04
557 reads
Data Channel - Interview 01 - Andreas Wolter on Columnstore
Dear all,
Welcome to the first ever interview of DataChannel. I am honored to have Mr.Andreas Wolter, a German MVP, MCM, MCSM...
2016-12-03
734 reads
Moving Tasks with Copy-SqlJob
More dbatools experimentation for me. This is a great set of Powershell cmdlets that solve simple, handy problems. In this...
2016-12-02
1,021 reads
SSIS Naming Conventions 2.0
People who have been working for a while with Integration Services probably know the legendary blog post by SQL Server...
2016-12-13 (first published: 2016-12-02)
5,428 reads
Friday Reading 2016-12-02
Another week almost over so here’s a random selection of articles that I’ve been reading…
Changing the SQL Server port on...
2016-12-02
373 reads
I use Elastic database pools – for now
When you have many SQL databases that are required to run your environments and they show signs of specific usage...
2016-12-12 (first published: 2016-12-02)
1,444 reads
Hey Posh, Are My Services Running?–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-12-01
760 reads
Azure Advisor
Azure Advisor is a really cool personalized recommendation engine that provides you with proactive best practices guidance on High Availability,...
2016-12-01
322 reads
Documenting databases
Open any book or article about database development and administration, and I can all but guarantee that you will find...
2016-12-01
364 reads
CPU Spikes Caused by Periodic Scheduled Jobs
In this article I’ll show you how to eliminate periodic spikes in the CPU that are caused by the jobs that execute periodically. Figure 1 shows such a situation....
2016-12-01
12 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