Most of my blog is filled with posts related to PASS in some way. Events, various volunteering opportunities, keynote blogging, this or that…With the demise of the organization, I...
2020-12-31 (first published: 2020-12-22)
485 reads
This was the first year in 16 years for me that there has been a fall season without the PASS Summit to go to. Every year, during the fall,...
2020-11-25 (first published: 2020-11-15)
217 reads
This month’s T-SQL Tuesday is hosted by my good friend and data platform MVP Taiob Ali. Taiob’s challenge is very relevant to current season – he asks to blog...
2020-11-10
13 reads
This month’s TSQL2sday is hosted by one of my favorite presenters, Rob Volk. His challenge for us is to use analogies and explain a database concept like you would...
2020-10-19 (first published: 2020-10-13)
429 reads
There is no doubt that this is a time when we all have to be extra aware and work towards keeping our skills aligned with market needs. During this...
2020-10-13 (first published: 2020-10-07)
317 reads
As most people reading this would know…the PASS organization is in a state of crisis now following the decision to go virtual. We are in a place where we...
2020-07-03 (first published: 2020-06-20)
182 reads
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
3 reads
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)
898 reads
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)
311 reads
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)
447 reads
By kleegeek
We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...
By Steve Jones
Today’s coping tip is to connect with someone from a different generation. This tip...
By Arun Sirpal
This blog post is not about which User Interface is better, Classic or Snowsight...
I am learning non-clustered and clustered indexing. When reading this article https://www.sqlshack.com/what-is-the-difference-between-clustered-and-non-clustered-indexes-in-sql-server/#:~:text=Clustered%20indexes%20only%20sort%20tables,involve%20any%20extra%20lookup%20step. came across this...
Two competitions, KBC Sim Card Lucky Draw 2022–23 and KBC WhatsApp Number Lucky Draw...
I'm using this query to check if I have any unused indexes.. One of...
Ask SSC