2019-02-27 (first published: 2019-02-20)
949 reads
Scripts
Disable or rebuild all nonclustered indexes on a table
Can be useful when inserting a lot of data into a table.
2019-02-26 (first published: 2019-02-14)
5,342 reads
Files with larger disk consumption
This script features as we can through the CTE Top10FilesWithLargerDiskConsumption the top ten data files that are showing greater consumption of hard drive related data-reading activities.
2019-01-15 (first published: 2019-01-08)
1,064 reads
Alert DBA - High SQL Server CPU Usage
Collect CPU % for a time period and alert if Average CPU usage is high
2019-01-14 (first published: 2019-01-08)
1,780 reads
Quick SQL connection and process details with current SQL - Version2
Quick check SQL connection and process details with current SQL text
2018-12-19 (first published: 2018-11-27)
980 reads
2018-11-30 (first published: 2017-04-01)
1,110 reads
2018-11-29 (first published: 2018-11-23)
454 reads
2018-11-15 (first published: 2018-11-08)
1,590 reads
Automatically Failover (Enable or Disable) Jobs Based on HADR Role
If you have a SQL Server with a High Availability solution (AlwaysOn Availability Groups, Database Mirroring, etc.), and you also have a bunch of jobs which you need to be run on the Primary server only. You need to be able to "failover" the jobs in case the Primary server is no longer Primary.
2018-11-14 (first published: 2018-11-12)
6,010 reads
Detect and Repair Non Trusted Foreign Keys
Create the code to detect and repair non trusted foreign keys
2018-11-13 (first published: 2018-09-27)
710 reads
Blogs
T-SQL Tuesday #199 Invitation: Back to on-prem?
It’s time for T-SQL Tuesday again! And we’re almost to number 200! T-SQL Tuesday...
Data Skew in Data Engineering: What It Is and How to Fix It
You kick off a distributed job expecting it to finish in minutes — but...
Error Deploying GraphQL in Fabric: dm_exec_describe_first_result_set
A while ago we suddenly had an error while trying to deploy one Fabric...
Forums
BCA KCP Industri | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Industri II No.14, Muktiharjo Lor, Kec. Genuk, Kota Semarang, Jawa Tengah 50197...
BCA KCP Sidareja | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Jenderal Ahmad Yani No.40, Cikalong, Sidareja, Kec. Sidareja, Kabupaten Cilacap, Jawa Tengah...
BCA KCP Siliwangi | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Jenderal Sudirman No.39, Krobokan, Kec. Semarang Barat, Kota Semarang, Jawa Tengah 50141...
Question of the Day
Secure Cached Plans
The DMV, sys.dm_exec_cached_plans, contains rows for each cached plan on an instance. In Azure SQL Database, not every used has rights to every database, as there does exist an instance behind each database. How is security handled for this DMV in Azure?
See possible answers