SSMS 2016& Azure SQL DBs
When using the latest version of SSMS (SQL Server Management Studio) there is a small but handy little feature that...
2016-10-11 (first published: 2016-09-27)
1,507 reads
SQL Relay 2016
It less than week to SQL Relay - a week long SQL conference that is visiting Birmingham, Cardiff, Reading, Nottingham and...
2016-09-27
505 reads
Future DBA – Hive Big Data 2
In our last blog on Future DBA, we discussed on HADOOP -HDFS system. how as we know HDFS management is...
2016-09-27
412 reads
What will be the result of the query below? Explain your answer?
select case when null = null then 'True' else 'False' end as ResultSet;
2016-09-26
156 reads
Different types of ANSI standard joins
INNER JOIN (SIMPLE JOIN): This returns all rows for which there is at least one match in BOTH tables. This is...
2016-09-26
319 reads
What does UNION do or what result set UNION return ? What is the difference between UNION and UNION ALL?
UNION merges the contents of two structurally-compatible tables into a single combined table. This return unique records from all the...
2016-09-26
192 reads
Query Store and What Happened Earlier On Your Server
Here’s a great question I received: We had a problem at 9:02 AM this morning, but we’re not sure what...
2016-10-06 (first published: 2016-09-26)
1,878 reads
A Goal of Speaking at PASS Summit
Everyone has goals or at least they should have goals. As a young professional out of college, I had plenty...
2016-09-26
584 reads
Studying Failures
Over the weekend, I went to the local theater to watch Sully, the movie about the US Airways pilot who...
2016-10-05 (first published: 2016-09-26)
1,322 reads
Nil to Speaker: Improving your PowerPoint skills
As I work on my speaking skills one of my tasks is improve my PowerPoint presentations. To that end I’ve...
2016-09-26
613 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
Alamat BCA KCU BINTARO Telp:0821°8200°233
Telp/Wa 628218200233 Bintaro Jaya Blok A-5 No.12 & 15, Sektor 7, Pd. Jaya, Kec....
Alamat BCA KCP Labuan Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Raya Labuan - Pandeglang No.01, Labuan, Kec. Labuan, Kabupaten Pandeglang, Banten...
Alamat BCA KCP Cilegon II Telp:0821°7555°651
Telp/Wa 628217555651 Ruko Cilegon City Square, Jl. Pondok Cilegon Indah No.1 Blok A No....
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers