Moving dates to a weekending date
In publishing, and Im sure many other industries, we get data at both the daily level and the weekly level. To properly tie these two pieces of data you...
2022-11-16 (first published: 2022-11-05)
307 reads
Blog Posts
Optimized Plan Forcing in SQL Server 2022
I’ve been reading Bob Ward’s book “SQL Server 2022 Revealed” and one of the new features in Intelligent Query Processing (IQP) jumped out at me. Not because it’s going...
2022-11-16
76 reads
PASS Summit 2022 - Pre-Cons Were Amazing!
It's that time again...TUESDAY!
https://www.mememaker.net/static/images/memes/4791280.jpg
I mean...NOVEMBER!
https://tinyurl.com/33hezsje
OK fine...SUMMIT!
https://img.memegenerator.net/images/10802365.jpg
I have very much missed in-person events and I am glad that Redgate (@Redgate) has managed to continue the @PASSDataSummit framework - virtual presentations...
2022-11-16
48 reads
Daily Coping 15 Nov 2022
Today’s coping tip is to sign up to try a new activity, course, or community. I somewhat did this early in the fall by choosing to go through the...
2022-11-15
8 reads
SQL Server 2022 is Coming
We still don’t have an exact release date for SQL Server 2022 but at this stage we can have strong confidence that it will be with us before the...
2022-11-15
86 reads
Daily Coping 14 Nov 2022
Today’s coping tip is to get outside and observe the changes in nature around you . Nature is changing in Colorado as winter approaches. It’s been a dry year,...
2022-11-14
11 reads
Getting Started Speaking – #NewStarNovember
My journey might be somewhat unusual, but perhaps not. I started writing articles on the Internet at a few different places before I started SQL Server Central. There were...
2022-11-14 (first published: 2022-11-01)
83 reads
SQL Homework – July 2022 – Getting ready for the next time you have to look for a job.
Back in July I suggested that you get your resume up to date. It’s something I’d wish I’d kept up ... Continue reading
2022-11-14 (first published: 2022-11-01)
253 reads
Tales From The Field Weekly Wrap Up for the Week of 11-07-2022 Run Disney, Gareth, & Veteran's Day
Hello Dear Reader! Last week I was fresh off of finishing the Run Dinsey 5K, 10K, & Food and Wine Half Marathon. My good friend Josh Luedeman (@JoshLuedeman |...
2022-11-14
58 reads
The Importance of New Speakers–#NewStarNovember
Many of us have learned how to research and get new information online. I certainly think the written word, whether from formal articles at places like SQL Server Central...
2022-11-14
4 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