Daily Coping 21 Oct 2020
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...
2020-10-21
27 reads
Blog Posts
How to Import Perfmon Data into a SQL Server for Analysis
If you followed the last video, I showed you how to set up windows perfmon for ongoing performance metric collection on all of your critical SQL Server machines. However,...
2020-10-21
125 reads
Shell to Script Shortcut
I’ve been meaning to write something this post for a while but the stars have aligned this week. Garry Bargsley (blog | twitter) published a post about making a...
2020-10-21
11 reads
The T-SQL Tuesday Corollary
T-SQL Tuesday is a fantastic series of blog posts derived from over 130 topics over the past 11 years, inviting bloggers to share their thoughts on a particular theme...
2020-10-21
26 reads
T-SQL Tuesday #131 – Database Analogies
This post is for the most recent #tsql2sday, a monthly exercise where a topic is proposed by a community member and everyone is invited to post their thoughts on...
2020-10-21 (first published: 2020-10-13)
269 reads
A table is like a library : T-SQL Tuesday #131
Rob Volk (blog|twitter) is our host for TSQL Tuesday this month and wants us to Explain a database subject like ... Continue reading
2020-10-20 (first published: 2020-10-13)
476 reads
Azure Databricks to Power BI
A very common approach is to query data straight from Databricks via Power BI. For this you need Databricks token and the JDBC address URL. This is found within...
2020-10-20
44 reads
Daily Coping 20 Oct 2020
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...
2020-10-20
22 reads
My 800th post!
It took me a little bit longer to get here than I expected but I finally made it. 800 posts. ... Continue reading
2020-10-20
15 reads
QDS Forced Plans - Gotchas and Limitations
Released with SQL Server 2016, Query Data Store was a game changer for performance tuning. Right from Microsoft’s website: The SQL Server Query Store feature provides you with...
2020-10-20 (first published: 2020-10-13)
640 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers