SQL Server According to Bob

Two guys who work on SQL Server

Month: January 2020

SQL Server BDC Hints and Tips: Changing Grafana/Kibana Display Time

The Grafana and Kibana interfaces default to the local browser time zone on a SQL Server BDC cluster … how to adjust the time zone for Grafana and Kibana.

Read More

SQL Server BDC Hints and Tips: TEMPDB Disk Usage

How TEMPDB can impact the pod, evictions and disk space usage.

Read More

SQL Server BDC Hints and Tips: The node’s Journal can be your best friend

If you are new to Kubernetes (K8’s), like I am, you quickly learn that the servicing node’s journal holds a wealth of information.

Read More

Using SQL Server’s SNITrace to Troubleshoot Networking Issues

Learn how to troubleshoot SQL Server networking issues using network, XEvent and SNITracing.

Read More

SQL Server I/O Basics Chapter #2

Additional details of SQL Server I/O patterns and capabilities.

Read More

SQL Server I/O Basics Chapter #1

Fundamental SQL Server I/O patterns and capabilities.

Read More

Using SQLBCP Native/Format File vs Text File and the BOM

BCP fundamentals when using format file and UNICODE data.

Read More