One of the coolest new projects out there is Azure SQL Database Edge: – https://azure.microsoft.com/en-us/services/sql-database-edge/ This allows SQL Server to run on ARM devices which will expand the range...
2020-04-22
5,370 reads
Knowing your data is very important when it comes to writing code. Now I’ll admit that I am very far from being a developer, however as a DBA, I...
2020-04-21
5 reads
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
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
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
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
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
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
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
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
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Setting page visibility and the active page are often overlooked last steps when publishing...
Comments posted to this topic are about the item Password Guidance
Comments posted to this topic are about the item Using table variables in T-SQL
I am trying to check out elastic query between two test instances we have...
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