Data Manipulation with Word and Excel
Recently I had to go through some training that asked me to evaluate some text. I needed to tally some data up, and decided Word and Excel were quick...
2022-11-18 (first published: 2022-11-07)
403 reads
Blog Posts
Tales From The Field Weekly Wrap Up for the Week of 10-31-2022
Hello Dear Reader! Last week was Halloween and I hope you all had a fantastic time. Halloween has long been my favorite holiday. The cost of participation is imagination,...
2022-11-18 (first published: 2022-11-07)
112 reads
#PASSDataSummit – Keynote 2 Live Blogging
Happy to be chosen to live blog the keynote events out at the PASSDataSummit in Seattle, Washington this week. This page will be updated through the Keynotes, all you...
2022-11-17
10 reads
Daily Coping 17 Nov 2022
Today’s coping tip is to try out a new way of being physically active. My routine for physical activity is yoga 2-3 times a week, weight lifting a couple...
2022-11-17
10 reads
SQL Server 2022 is Here!
SQL Server 2022 becoming generally available was announced on Nov 16th 2022. This is the most Azure-enabled release of SQL Server yet, which is pretty exciting. A major Azure-enabled...
2022-11-17
13 reads
T-SQL Tuesday #156 - Wrap Up
Foreword
Thank you everyone for participating! There is a total of 15 submissions and thanks to them, I’ve widened my perspective.
The order of the posts is chosen at random.
Greg Moore
Contribution|Blog|Twitter
Greg...
2022-11-17
11 reads
#PASSDataSummit – Keynote 1 Live Blogging
Happy to be chosen to live blog the keynote events out at the PASSDataSummit in Seattle, Washington this week. This page will be updated through the Keynotes, all you...
2022-11-16
18 reads
Creating a STONITH resource for a pacemaker cluster on VMWare virtual machines
A while back I wrote a post about creating a pacemaker cluster to run SQL Server availability group using the new Ubuntu images in Azure. Recently I had to...
2022-11-16 (first published: 2022-11-03)
150 reads
Daily Coping 16 Nov 2022
Today’s coping tip is to change your normal routine today and notice how you feel. I am a person who likes a routine. While I travel a lot and...
2022-11-16
6 reads
Find the Hidden Lego Steve at the Summit
I’m part of a Redgate promotion at the PASS Data Community Summit. They ordered some Lego Steve’s, which will be available at the booth. You can post some photos...
2022-11-16
17 reads
Blogs
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
T-SQL Tuesday #190–Mastering a New Technical Skill
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Forums
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers