Moving Databases into Azure SQL Elastic Pools
Quite a simple requirement (when I needed it a few months ago). Study my Azure SQL database environment below. As you can see I have a standard elastic pool...
2019-07-22
32 reads
What does the Machine Learning process look like?
This is the second article in the Machine Learning area. I have explained a bit more about the steps the Machine Learning process is built of. You will be...
2019-07-21
301 reads
Azure Cosmos DB: real-time data movement using Change Feed and Azure Functions
In this article, we will focus on creating a data pipeline to ETL (Extract, Transform and Load) Cosmos DB container changes to a SQL Server database. Note that this...
2019-07-21
141 reads
Azure Cosmos DB: real-time data movement using Change Feed and Azure Functions
In this article, we will focus on creating a data pipeline to ETL (Extract, Transform and Load) Cosmos DB container changes to a SQL Server database. Note that this...
2019-07-21
2,850 reads
SQL Saturday Albany Slides & Demo Code
Thanks to everyone who came out to see dbatools for the Uninitiated at SQL Saturday Albany on July 20th, 2019. I had a lot of fun sharing dbatools with...
2019-07-20
15 reads
Quick 6 month check – how are those learning goals going…?
So in January I wrote a blog post on some goals I had this year: Some of my goals for 2019 It’s now July – how are things going?...
2019-07-19
17 reads
“An installation package for the product Microsoft SQL Server 2012 Native Client cannot be found” – during SQL Server 2017 install
This blog post is about a situation that initially perplexed me – I was installing SQL Server 2017 onto a new DEMO machine – running Windows Server 2019. This...
2019-07-19
28,336 reads
How to Persuade Your Company to Change
Like a lot of developers and database administrators, I do a fair amount of short-term problem solving during the course of my normal work week. I get to join...
2019-07-19
15 reads
Power BI Monthly Digest – July 2019
In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I will again guide you through some of our favorite Power BI
2019-07-19
31 reads
One Way to Find Broken Code on Your Server
Before we approached our last major SQL Server upgrade, I was curious about what might break. Yes, I had used the DEA to check our code against deprecated or...
2019-07-19
51 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers