I hope you’re all enjoying the latest rev of the Microsoft Ignite conference as much as I am. I was going through the content catalog for this year’s conference...
2021-03-08 (first published: 2021-03-02)
159 reads
My updated course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right...
2021-03-08 (first published: 2021-03-01)
179 reads
Tomorrow, March 9, 2020, at 3 PM EST, I will be giving a presentation on how to build a database security model in SQL Server. We’ll primarily focus on...
2021-03-08
68 reads
Presenting is difficult, and you already know that. It is also incredibly rewarding and beneficial to your career, but that’s not important for this post. As difficult as it...
2021-03-05 (first published: 2021-02-28)
184 reads
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-03-05
16 reads
I sometimes get asked from customers if they should use a star schema or should they use one large single table/flatfile for their dataset in Power BI. The answer...
2021-03-05 (first published: 2021-03-01)
1,010 reads
In my previous blog post I talked about how to read from an XML Webervice and use xpath to query the XML on the expressions side of things. You...
2021-03-04 (first published: 2021-02-26)
442 reads
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-03-04
12 reads
Say you have a temp table and you want to see the columns names.
For example, I was trying to convert a query from using a #temp table to a...
2021-03-04 (first published: 2021-02-26)
432 reads
Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform and...
2021-03-04
7 reads
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Efficient query performance in Amazon Redshift often comes down to how well you manage...
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Recently, our dev teams approach me for advice on improving their huge heap table...
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Comments posted to this topic are about the item Why Your Index Isn't Being...
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers