Rastreando SysAdmin Habilitado
Script tem o objetivo de encontrar login com a role SysAdmin e informar seu status.
2011-08-22
229 reads
Scripts
2011-08-18 (first published: 2011-08-04)
1,132 reads
Change Time Zone on Server without Logging on to Box
Sometimes logging onto a box for a simple change like this is not possible for the business. This allows you to change this directly from T-SQL without having to log on or RDP into the box.
2011-08-17 (first published: 2011-07-28)
471 reads
Tracking processes
This script quick tip for those who will accurately monitor sessions on SQL Server.
2011-08-16 (first published: 2011-08-02)
1,682 reads
Allow distributed transactions
SQL Script to Open DTC for distributed transactions and also configure SQL Server for Distributed Transactions.
2011-08-12 (first published: 2011-08-03)
804 reads
Activity Monitor Script- Head Blocker
This gives you info about blocking, head blocker,wait_type, duration of the queries that are currently running
2011-08-11 (first published: 2011-08-04)
2,399 reads
Reindex - Reorganize or Rebuild
In the first time you execute this procedure, might take a long time, but not in the next time. Later you can execute this procedure daily.
2011-08-10 (first published: 2011-07-06)
2,420 reads
Status de Replicação via E-Mail
Script que envia um relatorio para o seu email com o status de sincronismo de sua replicação.
2011-08-10
335 reads
NetApp Dynamic Backup Script
TSQL Script to backup selected databases. Use this to override the script generated by snapmanager for sql in a sql job which doesn't cater for new or deleted databases
2011-08-09 (first published: 2011-07-27)
822 reads
Modify All Database Data and Logfile Names
This script modifies all dtabase .mdf and .ldf to have a standardized name of DatabaseName_Data and DatabaseName_Log.
2011-08-08 (first published: 2011-07-28)
967 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Alamat BCA KCP Metro Tanah Abang Telp:0821°7555°651
Hub Cs 08217555651 Pusat Grosir Metro Tanah Abang 2 Lt. 7. 10, Jl. K.H....
BCA KCU MENARA BCA Telp/Wa:08218200203
Hub Cs 08218200203 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1 Lt. 28, RT.1/RW.5,...
Alamat BCA KCP Raden Saleh Telp/Wa:08218200233
Hub Cs 08218200233 Jl. Raden Saleh Raya No.17A No. 13, 15, RT.1/RW.2, Kenari, Kec....