SQL Homework – January 2017 – Inspect an Execution Plan
It’s a new year and yet education never ends. So this month let’s take a look at an important part...
2018-01-10 (first published: 2018-01-03)
2,501 reads
What is the oldest version of SQL Server you are running?
I have a twitter poll running asking "What is the oldest version of SQL Server you are running?", to use...
2018-01-03
426 reads
How to fix Orphaned Users easily
What are Orphaned Users
“Orphaned Users” is a common issue in SQL Server where a Database User is no longer associated...
2018-01-11 (first published: 2018-01-03)
24,405 reads
Dynamics AX Event Session
There are many many uses for Extended Events. In this article I show a quick session setup that can be useful in the troubleshooting of various different problems (most...
2018-01-03
15 reads
Dynamics AX Event Session
Many moons ago, I wrote about how to enable the context info for Dynamics AX. Having the context info enabled...
2018-01-10 (first published: 2018-01-03)
1,144 reads
Power BI Custom Visuals Class (Module 84 – ChartAccent – BarChart)
In this module you will learn how to use the ChartAccent BarChart Custom Visual. This visual is a custom bar...
2018-01-09 (first published: 2018-01-03)
1,578 reads
Absolute computer fundamentals: the command line!
So I’ve spoken to more than one DBA who is not familiar with using the command prompt (aka command line)...
2018-01-02
401 reads
Implementing Smart Transaction Log Backups Using Ola Hallengren’s Backup Scripts in SQL Server 2017
This is part 1 of 2 part series on taking smart backups. Part 1 will be taking smart transaction logs...
2018-01-02
183 reads
Split Screens (Day 2)
Have you ever wanted to see different parts of the same query window at the same time? Well, in SSMS,...
2018-01-15 (first published: 2018-01-02)
2,327 reads
Upcoming SQLSaturdays
I have the priveledge of speaking at two SQLSaturday events coming up in the near future. This is the first...
2018-01-02
121 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers