top of page
This site was designed with the
.com
website builder. Create your website today.
Start Now
John's data story
More
Use tab to navigate through the menu items.
Topic
All Posts
(108)
108 posts
No categories yet.
SQL
(84)
84 posts
No categories yet.
Visualization
(5)
5 posts
No categories yet.
Data
(1)
1 post
No categories yet.
Python
(17)
17 posts
No categories yet.
Recent Posts
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
Archive
June 2020
(18)
18 posts
May 2020
(9)
9 posts
April 2020
(22)
22 posts
March 2020
(31)
31 posts
February 2020
(23)
23 posts
November 2016
(2)
2 posts
October 2016
(3)
3 posts
Tags
No tags yet.
Which American city offers the best protection from zombies
Click the above picture to listen A RECENT study by CareerBuilder, a recruitment firm, has ranked the 53 largest metropolitan areas in...
Where do Canada’s immigrants come from?
Click the picture to listen ANGER about immigration is on the rise in many rich countries. Not so in Canada (see ourbriefing). A fifth of...
The value of gun-toting film stars
click picture to listen OLD habits may well die hard. In 2000 Bruce Willis—true to his characters perhaps—argued that restricting...
bottom of page
