Daily Coping 21 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-21
4 reads
Blog Posts
DAX and Power BI Stairway Live
As part of the Redgate Community Circle, I’m going to be running a live class on DAX and Power BI, every Thursday, from 12MDT for about 30-45 minutes. We’ll...
2020-04-21
145 reads
New Article: Understanding SQL Server Ownership Chaining
Back in January I gave a presentation to a small group of folks on foundational SQL Server security items. The last thing I covered was the concept of ownership...
2020-04-21
38 reads
Remote Work Resources
We’re at least five weeks into this thing here in New York and while there are some encouraging signs, it’s more likely than not that “non-essential” workers aren’t at...
2020-04-21
1 reads
SQL Server and CPU Hyper-Threading in Virtual Environments
I recommend leaving the hyper-threaded logical cores enabled in the host BIOS, but not depending on them for performance gains. Hyperthreaded CPU cores, or logical cores, should not be...
2020-04-21 (first published: 2020-04-10)
1,489 reads
Switching between different Azure Data Factory environments
When working with Azure Data Factory, it’s possible you have multiple ADF environments. For example, you can have one for dev, one for test and one for production. Unfortunately,...
2020-04-21 (first published: 2020-04-08)
347 reads
T-SQL Tuesday Live 21 Apr 2020
I’ll be hosting T-SQL Tuesday live again today, at 1:00pm MDT/3:00pmEDT/8:00pmGMT If you’re interested in taking a break, chatting, touching base with others, bring your comments, questions, thoughts, and...
2020-04-21
6 reads
Audit Logons with Extended Events
This article shows how to audit the logon events for SQL Server 2012 and beyond through the use of XEvents.
Related Posts:
Life Support 2008 - Audit Logons July 17, 2019...
2020-04-20
2 reads
Audit Logons with Extended Events
This article shows how to audit the logon events for SQL Server 2012 and beyond through the use of XEvents.
Related Posts:
Life Support 2008 - Audit Logons July 17, 2019...
2020-04-20
48 reads
Audit Logons with Extended Events
This article shows how to audit the logon events for SQL Server 2012 and beyond through the use of XEvents.
Related Posts:
Life Support 2008 - Audit Logons July 17, 2019...
2020-04-20
8 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