Sites Microsoft


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

Publié le 8 février 2022 sur MS Tech Community
 

  Moved from: bobsql.com   The Grafana and Kibana interfaces default to the local browser time zone on a SQL Server BDC cluster.  Some of my machines are in the PST time zone and others the CST time zone and I find myself doing math cali …

SQL Server dbcc clonedatabase​​ -​​ Gotch

Publié le 8 février 2022 sur MS Tech Community
 

Moved from: bobsql.com   The dbcc clonedatabase is a​​ handy command to clone metadata and​​ information such as​​ query disk store.​​ ​​ Then​​  …

SQL Server BDC Hints and Tips: VDI Seeding for High Availability

Publié le 8 février 2022 sur MS Tech Community
 

  Moved from: bobsql.com   A high availability SQL Server BDC uses the Virtual Device Interface (VDI) to seed databases to secondary replicas. (https://docs.microsoft.com/en-us/sql/big-data-cluster/     deployment-high-availability? …

SQL Server BDC Hints and Tips: Contained AGs, Ports, containedag_msdb, logs, …

Publié le 7 février 2022 sur MS Tech Community
 

  Moved from: bobsql.com   This blog post focuses on connecting to the SQL Server BDC, some helpful log files and utility outputs.  Understanding a few basics about a SQL Server BDC and the Contained Availability Group (containedag) make …

How It Works: TSQL TRY/CATCH Behavior Fooled Me

Publié le 7 février 2022 sur MS Tech Community
 

Move from: bobsql.com   If I would have simply read the documentation (https://docs.microsoft.com/en-us/sql/t-sql/language-elements/try-catch-transact-sql?view=sql-server-ver15) the answer to my problem is answered.   Create the following pro …

SQL Server On Linux: Logger.ini Size and Rollover Additions to SQL Server 2019 CU4

Publié le 7 février 2022 sur MS Tech Community
 

  Moved from: bobsql.com   I can’t take credit for this post as Dylan added the code and provided the write-up to share with you.  All I did was a bit of editing and proof reading, enjoy.   For SQL Server on Linux, there are a …

How It Works: SQL Server Locking WAIT_WITH_LOW_PRIORITY

Publié le 6 février 2022 sur MS Tech Community
 

  Move from: bobsql.com   I received a question from Jonathan as he read over prior posts on locking and I cannot take credit for the question nor the answer, just being the middle man for this transaction.   Question: “The wa …

How It Works: Bulk Insert (BCP.exe) – Injecting a Sort Operation

Publié le 6 février 2022 sur MS Tech Community
 

  Move from: bobsql.com The customer reported that they could not BCP into a table using “keepidentity” and after more debugging I found that “keepidentity” was not the issue but the issue was the addition of a clustered in …

SQL Mysteries: Why am I​​ Still Seeing 17830​​ Errors?

Publié le 6 février 2022 sur MS Tech Community
 

  Moved from: bobsql.com   I was recently contacted by Christophe Laporte posing a very interesting question. « This is about the blog post you published a while ago, but I’ have questions regarding the error which is firing an XEvent al …

HOW IT WORKS: SQL Server Scheduler Affinity

Publié le 5 février 2022 sur MS Tech Community
 

Moved from: bobsql.com   SQL Server uses 3 types of affinity to control where the SQL Server worker threads execute.  Before explaining the different scheduler affinity types let me clarify some terminology.   Node Types SQL Server makes …

How It Works: SQL Server Stack Trace – COMDAT Elimination

Publié le 5 février 2022 sur MS Tech Community
 

Moved from: bobsql.com   Starting with​​ SQL Server ​​ 2019, SQL Server is​​ built with the​​ COMDAT, ICF linker option​​ enabled, reducing size/space usage. …

How It Works: XEvent String Comparison Performance Tip

Publié le 5 février 2022 sur MS Tech Community
 

Moved from: bobsql.com   I​​ ran across​​ a​​ check in the​​ XEvent​​ string comparison logic​​ which​​ can​​ b …

JDBC Driver 10.2 for SQL Server Released

Publié le 1 février 2022 sur MS Tech Community
 

Version 10.2 of the Microsoft JDBC Driver for SQL Server has been released. Version 10.2.0 brings several added features, changes, and fixed issues over the previous production release.   Added Java 17 support 1676 Idle Connection Resiliency …

Microsoft Drivers 5.10 for PHP for SQL Server Released

Publié le 31 janvier 2022 sur MS Tech Community
 

We have released Microsoft Drivers for PHP for SQL Server, version 5.10.0. This production release of the SQLSRV and PDO_SQLSRV drivers has been built with PHP 7.4, 8.0, and 8.1 and tested on all supported platforms.   Notable items about this rel …

Cumulative Update #15 for SQL Server 2019 Big Data Clusters

Publié le 28 janvier 2022 sur MS Tech Community
 

Today, we announce the release of the latest cumulative update, CU15, for SQL Server Big Data Clusters. Improvements in this update are highlighted below, along with resources for you to learn more and get started. Log4j vulnerability assessment and El …


Pages :