Use PowerShell to automate your Azure DB creation
Why create your databases manually if you don’t have to? If there is one thing that I hate to do...
2016-07-20
849 reads
Blog Posts
Want to be able to read your database between restores?
When restoring a database there are times when it would nice to restore a bit, check what’s been restored so...
2016-07-20
775 reads
Adding the ReadyRoll Extension in VSTS
As I’m doing a little development with ReadyRoll, I’m documenting some of the things I learn about the product.
A few...
2016-07-19
702 reads
Extended Event Help Queries
Enjoy this article re-publication from my original work at SQL Solutions Group.
When working with Extended Events, there are times when...
2016-07-19
669 reads
Extended Event Help Queries
When working with Extended Events, there are times when a little more information is, well, helpful. You know you want to use extended events to try and monitor...
2016-07-19
11 reads
Improvements with SSMS 2016
The staple of every SQL Server developer's world, SSMS has been impossible to usurp for the majority of us. However,...
2016-07-19 (first published: 2016-07-11)
3,622 reads
Same Query, Different Servers, Different Performance. Now What?
Based on the number of times I see this question on forums, it must be occurring all the time. You...
2016-07-19 (first published: 2016-07-11)
2,430 reads
SQL – MultiServer SQL Inventory – PowerShell
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2016-07-19
761 reads
T-SQL Tuesday #080–Round Up
The roundup is finally here, and cheers to all of you who participated. We had a great turnout this month...
2016-07-19
359 reads
Using Power BI to list Enterprise Only SQL Features
Someone recently asked me if there was a list of all the SQL Server “Enterprise Only” features available on the...
2016-07-19
648 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