Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

2017-02-22

1,138 reads

Automating DBCC PAGE – Part 3 (Is a Clustered Index physically sorted on disk?)

by Wayne Sheffield

A Discussion of SQL Server-Related Topics

In several of my last few blog posts, I’ve shared several methods of getting internal information from a database by...

2017-02-22

428 reads

Reminder – SQL Saturday Chicago Precon

by kleegeek

Technobabble by Klee from @kleegeek

I just wanted to remind everyone that the SQL Saturday in Chicago is coming up, and that both Adam Machanic...

2017-02-22

349 reads

What’s in my backup file?

by Kenneth Fisher

SQLStudies

Restoring a backup file is pretty easy right?
RESTORE DATABASE [Test] FROM DISK = 'C:\backups\backup.bak';Ok, but what if more than one database...

2017-02-22

949 reads

SSMS Presenter Mode

by Arun Sirpal

All About SQL

SQL Server Management Studio (SSMS) release candidate 17.0 RC2 works side-by-side with generally available releases (16.x), but it is not...

2017-02-22

570 reads

Remotely Administering the Docker Engine on Windows Server 2016

by Andrew Pruski

The DBA Who Came In From The Cold

Continuing on my series in working with Docker on Windows, I noticed that I always open up a remote powershell...

2017-02-22

704 reads

Read Statistics Histogram using DMV

by Dharmendra Keshari

SQL Geek

DMV: sys.dm_db_stats_histogram (object_id, stats_id)
For a long time, the DBCC SHOW_STATISTICS command was the only way to get information about statistics....

2017-02-22

1,012 reads

JSON Support Is The Best New Developer Feature in SQL 2016 — Part 4: Performance Comparisons

by Bert Wagner

Bert Wagner

This is the fourth article in my series about learning how to use SQL Server 2016's new JSON functions. If you haven't already, you can read Part 1?—?Parsing JSON,...

2017-02-21

31 reads