Topic

Bitwise operators

In honor of Lothar Collatz

sqrt() and int()

For loops

String Methods

break and continue

sleep()

Assignment Operators

while i and for i in range ()

Multi-line printing

Compact while()

int()

float() and round()

if-elif-else instructions

Time evaluation

end=, sep=, +, *, and /

Assignment (Shortcut) operators

Binary <==> Decimal Conversion

Data scientists vs analysts

Performance, error and warning events

Inner Join (vs Inline TVF)

Query performance

exec_query_stats

REORGANIZE vs REBUILD

Data Collector vs Activity Monitor

Database recovery

Version Store

Activity Monitor

Data change recording

Indexed v.s. Partitioned Views

Database Snapshot

Baseline performance

Common Table Expressions (CTEs)

#temp table v.s. @table

The backstage architecture

With Check Option

SQL Server Profiler

Memory-Optimized Tables -- Non-durable v.s. variable

Azure Portal

Service Editions and Tiers

Extreme Transaction Processing (XTP)

Lock Events Category

GRANT Object Permissions

Identify missing indexes

Query Store properties

SQL Syntax

Resource Pool

Stored procedure with OUTPUT and READONLY

Statistics updates

Extended Event

exec_query_stats

You can also review the statistics collection at the query level by executing a query against the sys.dm_exec_query_stats DMV, which...

Data Collector vs Activity Monitor

The data collector is a core component of the data collection platform for SQL Server 2019 (15.x) and the tools that are provided by SQL...

Activity Monitor

Overview The goal of monitoring databases is to assess how a server is performing. Effective monitoring involves taking periodic...

Baseline performance

There are four tools that we can use to check performance metrics for the operating system and SQL Server: Dynamic management objects...

Resource Pool

You distribute the amount of memory, CPU, and IO available to SQL Server among resource pools as a means of reducing contention between...

Database Throughput Unit (DTU)

A DTU is a single metric to represent CPU, memory, and IO thresholds. In other words, Queries' performance levels are measured as DTUs...

Elastic Scale -- Sharding

By using Elastic Scale for Azure SQL Database, you can manage your data in separate shards for which resource requirements can...

Topic

Bitwise operators

In honor of Lothar Collatz

sqrt() and int()

For loops

String Methods

break and continue

sleep()

Assignment Operators

while i and for i in range ()

Multi-line printing

Compact while()

int()

float() and round()

if-elif-else instructions

Time evaluation

end=, sep=, +, *, and /

Assignment (Shortcut) operators

Binary <==> Decimal Conversion

Data scientists vs analysts

Performance, error and warning events

Inner Join (vs Inline TVF)

Query performance

exec_query_stats

REORGANIZE vs REBUILD

Data Collector vs Activity Monitor

Database recovery

Version Store

Activity Monitor

Data change recording

Indexed v.s. Partitioned Views

Database Snapshot

Baseline performance

Common Table Expressions (CTEs)

#temp table v.s. @table

The backstage architecture

With Check Option

SQL Server Profiler

Memory-Optimized Tables -- Non-durable v.s. variable

Azure Portal

Service Editions and Tiers

Extreme Transaction Processing (XTP)

Lock Events Category

GRANT Object Permissions

Identify missing indexes

Query Store properties

SQL Syntax

Resource Pool

Stored procedure with OUTPUT and READONLY

Statistics updates

Extended Event

exec_query_stats

Data Collector vs Activity Monitor

Activity Monitor

Baseline performance

Resource Pool

Database Throughput Unit (DTU)

Elastic Scale -- Sharding

aboutME