In this talk you’ll learn about enhancements to indexing (including both Columnstore and traditional b-tree indexes), DMVs, compression, string handling, encryption, configuration, and even timezone support.
Posts by Adam Machanic
Adam Machanic
1 post
Adam is an independent consultant in the Boston area. He enjoys working on data architecture, database development, and performance tuning projects. Adam is author and maintainer of the popular SQL Server monitoring script, sp_whoisactive. You can reach him at amachanic [at] gmail [dot] com.
Get New Sessions Free
Filter by Tag
azure
bi
business intelligence
case studies
ci
columnstore
containers
continuous integration
data science
dba
deployment
development
devops
docker
dynamic SQL
encryption
Europe
execution plans
functions
gitlab
Groupby Conference
hekaton
in-memory oltp
indexing
maintenance
North America
October
parameter sniffing
performance
PowerBI
powershell
query store
r
readyroll
security
setup
source control
sp_Blitz
SQL Cover
sql server 2016
ssdt
ssrs
t-sql
testing
tsqlt
Filter by Date
- 2017-01 Sessions (13)
- 2017-04 Sessions (10)
- 2017-06 Sessions (9)
- 2017-09 Sessions (9)
- 2017-12 Sessions (10)
- 2018-03 Sessions (5)
- 2018-06 Sessions (5)
- 2018-09 Sessions (5)
- 2018-12 Sessions (6)
- 2019-04 Sessions (6)
- 2019-10-09 Europe Sessions (15)
- 2019-10-10 North America Sessions (16)
- Abstracts (4)
- Archived Abstracts (43)
- Email Newsletter (18)
- Open Abstracts (53)
- Sessions (12)
- Site News (51)
- With Videos (78)