Long time, no posts
I was working on two publisher contracts at the same time. I highly recommend never doing that. One is done, though, and it’s officially published as of September 2022....
2022-10-27
15 reads
How to “Rename” the Master Branch to Main in Git in Azure DevOps
I believe that language matters, and that it is worth our effort to move away from language associated with slavery and racism whenever possible. Azure DevOps doesn’t technically allow...
2020-06-26
384 reads
Create a Build with YAML for SQL Change Automation in Azure DevOps
I used to make fun of YAML because I was scared of it. I still make fun of YAML, but I’m not scared of it anymore now that Rob...
2020-06-25
106 reads
Learn TSQL for free online – starting today
Thanks to the support of Redgate, I’ve launched a new course which teaches you the basics of TSQL. The course is totally free, no logins required — we don’t...
2020-05-11
67 reads
Join the Best Worst Code Contest today at 5pm BST / Noon Eastern #BestWorstCode
I have an idea! Let’s have a “Worst Code Contest.” Why do this? Bad code is really fun — at least, when you write it on purpose. And other...
2020-04-24
23 reads
Your team can’t stop writing crappy code. Will Intelligent Query Processing fix it?
People have been writing about how evil scalar functions are in SQL Server for ten years. But people still use scalar functions in their code all the time. And...
2020-03-24
22 reads
Connecting to the SQL Server Community Online: Uplifting Folks
We’ve got a session coming up in the free Redgate Streamed virtual conference on, “How database DevOps levels up remote work.” When thinking about that session I began thinking...
2020-03-23
13 reads
Outlining My Session: Index Tuning in an Agile World
I’m giving a session on index tuning at the upcoming Redgate Streamed free online conference. The conference will be held April 1-3 2020, register here and join us! I...
2020-03-20
26 reads
Announcing Redgate Streamed, April 1-3 2020
We’re thrilled to announce Redgate Streamed: a 3 day online virtual community conference, to be held April 1-3, 2020. Register at Redgate.com/RedgateStreamed In this 9 minute livestream, I give...
2020-03-19
9 reads
The Learner’s Guide to SQL Server Performance Triage
I’m introducing a series of “learner’s guides” — overviews of a given topic, chock full of links and references. For this first post, the information is based on what...
2020-03-19
58 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
Laptop on Rent in Bangalore – Flexible & Affordable Solutions
Looking for a laptop on rent in Bangalore? Renting laptops is a smart choice...
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
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