Being seen and why PASS helped
One of my colleagues/friends read my earlier blog post on the future of PASS and said he was not aware that being seen as a minority person was among...
2020-06-22
8 reads
Mala Mahadevan
Deleting packages from SSIS Catalog
I was fortunate to attend a training on SSIS by my good friend and SSIS expert Andy Leonard(b|t). We already use the tool for ETL purposes where I work...
2020-05-18 (first published: 2020-05-04)
964 reads
Learning Postgres:Installation
I had the opportunity of working on a project converting a postgres database to a sql server based one at work. I used this opportunity to learn more of...
2020-04-13 (first published: 2020-04-06)
319 reads
Telecommute Resources
This is a summary of potential resources for any tech person who is interested in working from home – temporarily or full time. It came about from a twitter...
2020-03-18 (first published: 2020-03-09)
456 reads
T-SQL Tuesday 123: Life Hacks to make your day easier
This month’s T-SQL Tuesday is hosted by Jess Pomfret. Jess’s theme is ‘Life Hacks to make your day easier’. She talks of some things we do to make life...
2020-02-17 (first published: 2020-02-11)
812 reads
T-SQL Tuesday #122: Being authentic
This month’s T-SQL Tuesday is hosted by Jon Shaulis – the topic is an evergreen one, dealing with Imposter Syndrome. I learned of this word via Mindy Curnett a.k.a...
2020-01-15
10 reads
Epic Life Quest – 2020 Update
I started keeping a written record on bigger goals in life from the year 2018 – following the example set by Steve Jones and Brent Ozar. This method of...
2020-01-06
20 reads
T-SQL Tuesday 121 – Gifts received – Summary
I got several responses for the last T-SQL Tuesday of the year that am honored to host. My topic was to blog on whatever you considered to be a...
2019-12-27 (first published: 2019-12-12)
314 reads
Querying database schema using graph tables
SQL Server 2017 introduced the concept of graph data tables as part of the SQL Server database engine. With SQL Server 2019, there were some enhancements like ‘shortest path’ function and constraints on edge tables that make this feature more usable – although it is far from a full-fledged graph database. Graph tables are essentially […]
2019-12-23
15,408 reads
T-SQL Tuesday #121 Gifts received
I am hosting 2019’s last T-SQL Tuesday of the year. I chose to ask people to write on gifts they had received – by way of community, relationships, or...
2019-12-10
11 reads
Blogs
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers