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...
2017-01-19
355 reads
Find and fix SQL Server databases with empty owner property using dbatools PowerShell module
A few days ago I came across with a error that says “Property Owner is not available for database [XXXXXXX].”....
2017-01-19
1,132 reads
SQL Server 2016 Bug in R Integration?
I am studying the latest R integration with SQL Server 2016, and I believe I encounter a bug when using...
2017-01-26 (first published: 2017-01-19)
1,451 reads
Attending VTUG at Gillette Stadium Tomorrow
If you’re in the Boston area tomorrow, I urge you to go to this year’s Virtualization Technology Users Group (VTUG)Winter...
2017-01-18
349 reads
Automating DBCC PAGE, part 2 – determining object names on pages
In a prior blog post, I demonstrated how using DBCC PAGE can be automated by using the “WITH TABLERESULTS” option....
2017-01-18
420 reads
Why Use Red Gate’s SQL Multi Script?
Someone once told me at the shop that we have plenty of software utilities laying around that could be very...
2017-01-18
528 reads
Microsoft Products vs Hadoop/OSS Products
Microsoft’s end goal is for Azure to become the best cloud platform for customers to run their data workloads. This...
2017-01-18
360 reads
Using Out-GridView To Pick Parameters–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-01-18
666 reads
Scheduling Statistics Maintenance in Azure SQL Data Warehouse
The power and capabilities of Azure SQL Data Warehouse are pretty amazing. However, it’s still basically SQL Server under the...
2017-01-25 (first published: 2017-01-18)
1,112 reads
PowerShell Virtual Group of PASS January Newsletter
We spend way too much time each month drafting the newsletters for the PowerShell Group of PASS. But hey, we’re database people, not email mavens, and the newsletter does...
2017-01-18
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