Log Analytics with Dedicated SQL Pools (Formerly SQL DW)
There are a lot of services in Azure. Way more than a few. What is something you want to do with all your services and applications? You want to...
2021-11-01
17 reads
Log Analytics with Dedicated SQL Pools (Formerly SQL DW)
There are a lot of services in Azure. Way more than a few. What is something you want to do with all your services and applications? You want to...
2021-11-29 (first published: 2021-11-01)
868 reads
Daily Coping 1 Nov 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-11-01
12 reads
Log Analytics with Azure Synapse Analytics
There are a lot of services in Azure. Way more than a few. What is something you want to do with all your services and applications? You want to...
2021-11-01
28 reads
Log Analytics with Dedicated SQL Pools (Formerly SQL DW)
There are a lot of services in Azure. Way more than a few. What is something you want to do with all your services and applications? You want to...
2021-11-01
20 reads
Azure SQL Managed Instance CPU and RAM
With SQL Managed Instance you will need to consider your configuration requirements in terms of core count for the CPU and memory, which we all know that the MIN/MAX...
2021-11-01
116 reads
Error [IM002] [Microsoft][ODBC Driver Manager] "Data source name not found and no default driver specified" and who do you trust?
(2021-Oct-31) A very short blog post, just a reminder to myself, but if you have ever tried to connect to a PostgreSQL database using ODBC interface (I know, it already...
2021-11-10 (first published: 2021-11-01)
9,668 reads
The First Live SQL Saturday in 2021
I’m getting ready to board a plane now, heading to Orlando for the first live SQL Saturday in 2021. I’m excited and looking forward to seeing friends that I’ve...
2021-10-29
27 reads
Daily Coping 29 Oct 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-10-29
24 reads
Daily Coping 28 Oct 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-10-28
18 reads
Blogs
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...