T-SQL Tuesday: Changing my mind
This month’s T-SQL Tuesday is hosted by my friend across the pond – Alex Yates. Alex has a fantastic topic for us to blog about – he asks us...
2019-10-14 (first published: 2019-10-08)
515 reads
Mala's Data Blog
Graph – Shortest Path
‘Shortest path’ is by far the most feature of SQL Graph for now. What does this even mean? ‘Shortest path’ is the term accorded to the shortest distance between...
2019-10-08 (first published: 2019-09-22)
739 reads
Simple Graph Queries
In this post we saw how to create some graph tables with data. In this I will explore simple queries off of this data and how they compare with...
2019-10-01 (first published: 2019-09-21)
448 reads
Protected: Vajrasara – An interview with Lashana Lewis – Part 2
There is no excerpt because this is a protected post.
2019-09-02
4 reads
Protected: Vajrasara – an interview with Lashana Lewis – Part 1
There is no excerpt because this is a protected post.
2019-09-02
12 reads
Graph Databases – Introduction
I have been looking into this feature and also into understanding graph data in general. I believe introduction of graph database feature in SQL Server has many advantages –...
2019-08-22 (first published: 2019-08-09)
833 reads
PASS Summit 2019 – spending the time
The session line up for PASS Summit 2019 was announced today...there are so many good sessions to go to..managing time and what we do with our limited time there...
2019-08-08
21 reads
Pathways to Progress
One of the most significant and hardest challenges we face as data professionals (or generally anyone in IT) is how to keep up with learning. Most of us are...
2019-06-05 (first published: 2019-05-17)
216 reads
PASS turns 20
Its really hard to believe that its been 20 years since the start of the PASS organization – the volunteer run...
2019-03-19
833 reads
WIT Panel for Women’s History Month
I cannot write this without stating some history. I have been part of PASS community since 1999. That is 21...
2019-03-11
208 reads
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
What is the best index strategy for a table that gets truncated?
Hi everyone My SSIS package does a bulk insert of csv files into a...
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers