PASS Summit 2019 Takeaways
I attended my 16th PASS Summit this November 6th, 2019 at Seattle. It was a wonderful week of learning and networking. Below are my takeaways for key days. The...
2019-11-13
2 reads
Mala Mahadevan
PASS Summit 2019: Day 1 Keynote – my takeaways
I’ve been at the bloggers table for two years now. I felt honored to be selected this year too. The day has started a bit differently – bloggers were...
2019-11-07
2 reads
Geneology with SQL Graph – Part II
In the previous post I explored a query on how to construct a basic family tree with sql graph – including table set up and queries. In this post...
2019-10-24
7 reads
Geneology with SQL Graph – I
I have been working a lot of SQL Graph related queries and applications of the graph data concept to the extent possible within SQL Server’s graph capabilities. Genealogy, or...
2019-10-17 (first published: 2019-10-14)
1,183 reads
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)
514 reads
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)
728 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)
442 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
Protected: Vajrasara – An interview with Lashana Lewis – Part 2
There is no excerpt because this is a protected post.
2019-09-02
4 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)
831 reads
Blogs
Migrate datetime data to datetimeoffset with AT TIME ZONE
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
The Comprehensive Guide to Mastering Your SQL DBA Skills
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
Friday Basics: Authentication vs. Authorization
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Forums
The Backup File Extension
Comments posted to this topic are about the item The Backup File Extension
Ingest and Retrieve data from an ADX Cluster Using Python
Comments posted to this topic are about the item Ingest and Retrieve data from...
The DBAccountant
Comments posted to this topic are about the item The DBAccountant
Question of the Day
The Backup File Extension
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers