2020 Year In Review
TL;DR – It was great and not great I think we can all pretty much agree that in some regards 2020 was horrible, globally. So lets move on… Good...
2021-01-01
22 reads
Blog Posts
Basic Cursors in T-SQL–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Cursors are not efficient, and not recommended for...
2021-01-01 (first published: 2020-12-23)
540 reads
Daily Coping 1 Jan 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-01-01
21 reads
DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Announced last week is a major new feature for Power BI: you can now use DirectQuery to connect to Azure Analysis Services or Power BI Datasets and combine it...
2021-01-01 (first published: 2020-12-23)
790 reads
Easy Monitoring: Application Timeouts in SQL Server with XEvents
Application timeouts can be surprising little problems causing grey hairs. Never fear, this article with the XEvents session I shared are the perfect solution.
The post Easy Monitoring: Application Timeouts...
2021-01-01
549 reads
Easy Monitoring: Application Timeouts in SQL Server with XEvents
Application timeouts can be surprising little problems causing grey hairs. Never fear, this article with the XEvents session I shared are the perfect solution.
The post Easy Monitoring: Application Timeouts...
2021-01-01
13 reads
Easy Monitoring: Application Timeouts in SQL Server with XEvents
Application timeouts can be surprising little problems causing grey hairs. Never fear, this article with the XEvents session I shared are the perfect solution.
The post Easy Monitoring: Application Timeouts...
2021-01-01
14 reads
Easy Monitoring: Application Timeouts in SQL Server with XEvents
Application timeouts can be surprising little problems causing grey hairs. Never fear, this article with the XEvents session I shared are the perfect solution.
The post Easy Monitoring: Application Timeouts...
2021-01-01
15 reads
Easy Monitoring: Application Timeouts in SQL Server with XEvents
Application timeouts can be surprising little problems causing grey hairs. Never fear, this article with the XEvents session I shared are the perfect solution.
The post Easy Monitoring: Application Timeouts...
2021-01-01
7 reads
Easy Monitoring: Application Timeouts in SQL Server with XEvents
Application timeouts can be surprising little problems causing grey hairs. Never fear, this article with the XEvents session I shared are the perfect solution.
The post Easy Monitoring: Application Timeouts...
2021-01-01
8 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Alamat Kantor BCA KCU KALIMALANG Tlp/Wa:0817839777
Tlp/Cs: 0817839777 Jl. Tarum Barat Blk. E No.5, RT.4/RW.10, Wil. Kota, Kec. Duren Sawit,...
Alamat Kantor BCA KCU SITUBONDO Telp:0817839777
WhatsApp: 0817839777 Jl. Diponegoro No.68, Palraman, Dawuhan, Kec. Situbondo, Kabupaten Situbondo, Jawa Timur 68311
Alamat Kantor BCA KCU TUBAN Telp:0817839777
WhatsApp: 0817839777 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers