COUNT, DISTINCT, and NULLs
Watch this week's video on YouTube
One thing I see fairly often (and am occasionally guilty of myself) is using COUNT(DISTINCT) and DISTINCT interchangeably to get an idea of the...
2019-02-19
28 reads
Bert Wagner
COUNT, DISTINCT, and NULLs
Watch this week's video on YouTube
One thing I see fairly often (and am occasionally guilty of myself) is using COUNT(DISTINCT) and DISTINCT interchangeably to get an idea of the...
2019-02-19
25 reads
Parsing HTML in SQL Server
Watch this week's video on YouTube
Recently I was asked how to parse text out of an HTML fragment stored in SQL Server.
Over the next few seconds my brain processed...
2019-02-12
10 reads
Parsing HTML in SQL Server
Recently I was asked how to parse text out of an HTML fragment stored in SQL Server.
Over the next few...
2019-02-12
2,638 reads
Parsing HTML in SQL Server
Watch this week's video on YouTube
Recently I was asked how to parse text out of an HTML fragment stored in SQL Server.
Over the next few seconds my brain processed...
2019-02-12
11 reads
Why make?
This post is a response to this month's T-SQL Tuesday #111 prompt by Andy Leonard. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2019-02-12
10 reads
Why make?
This post is a response to this month's T-SQL Tuesday #111 prompt by Andy Leonard. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2019-02-12
23 reads
Optimizing for Ad Hoc Workloads
Watch this week’s episode on YouTube.
The execution plan cache is a great feature: after SQL Server goes through the effort...
2019-02-07 (first published: 2019-01-22)
2,225 reads
Automating Database Maintenance with Jess Pomfret and dbatools
dbatools is one of the coolest community projects I’ve seen – it is amazing how many commands are available to help...
2019-02-05
210 reads
Automating Database Maintenance with Jess Pomfret and dbatools
Watch this week's video on YouTube
dbatools is one of the coolest community projects I've seen - it is amazing how many commands are available to help make managing your...
2019-02-05
12 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
Telp BCA KCP Kemang Pratama Cs 0823-7497-7784
Wa:082374977784 Komplek, Ruko Kemang Pratama, Jl. Kemang Pratama Raya No.1A Blk AN, RT.004/RW.001, Bojong...
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
Alamat BCA KCP Modernland Telp:0821°7555°651
Telp/Wa 628217555651 Ruko Modern Walk, Jl. Hartono Raya No.063 MW No. 062, RT.001/RW.006, Klp....
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers