Sites Microsoft


ODBC Driver 18.0 for SQL Server Released

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

Version 18.0 of the Microsoft ODBC Driver 18 for SQL Server has been released. Version 18.0 brings several changes, new features, and fixes to the driver.   Features Added compatibility with OpenSSL 3.0 Ability to send long types as max types …

Meet us at SQLBits 2022 and level up as a data professional

Publié le 10 février 2022 sur SQL Server Blog
 

It has been over two years since we have had the opportunity to meet face-to-face with our data community at a large event and we miss it. From hallway conversations to the energy that comes from solving problems and helping people understand complex c …

フェールオーバークラスターマネージャーでSQL Server Always On 可用性グループのリソースを操作する際の注意事項

Publié le 10 février 2022 sur SQL Server Support Blog
 

こんにちは、 SQL Server サポートチームです。  本記事では SQL Server Always On 可用 …

Using SQL Server’s SNITrace to Troubleshoot Networking Issues

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

Moved from: bobsql.com   SNITrace, formally BIDTrace, is an deeper level of tracing for the Microsoft SQL Server TDS consumers and providers.   Terms and Brief History Before I dive into the details here is a brief history and related termino …

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

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

Move from: bobsql.com   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. In the lab I was encountering evictions due to memory, disk space and other reso …

SQL Server BDC Hints and Tips:​​ TEMPDB​​ Disk Usage

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

Move from: bobsql.com   I was troubleshooting​​ a​​ master-0 pod eviction​​ due to​​ disk pressure. ​​  The pod was​​ shutdown Ephemeral spa …

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 …


Pages :