Change the server name of the SQL Server Instance
How to change the server name of SQL Server Instance?
2018-03-27 (first published: 2018-03-19)
1,275 reads
Scripts
Statistics Outdated
Busca por todas as estatísticas que estão desatualizadas com base no threshold do TraceFlag 2371.
2018-03-21
209 reads
2018-03-19 (first published: 2018-03-15)
442 reads
Unused Indexes in your databases
This Script allows you to determine the list of unused indexes in your databases.
For sys.dm_db_indexes_usage_stats, make sure that the last rebbot of the service sql allows you to conclude
2018-03-06 (first published: 2011-02-10)
6,147 reads
2018-02-28 (first published: 2018-01-10)
3,097 reads
Custom Replication Status Record Latency Monitor
Monitors replicated tables for any publisher/subscriber for latency in record counts, alerts via email if latency exists beyond a specified threshold
2018-02-27 (first published: 2015-01-23)
563 reads
2018-02-23 (first published: 2018-02-19)
161 reads
2018-02-19 (first published: 2018-02-07)
1,010 reads
Compression estimates
The script estimate compression benefits per each object in the database for which the page compression has not been implemented.
2018-02-15 (first published: 2018-01-15)
2,050 reads
2018-02-12 (first published: 2018-01-24)
322 reads
Blogs
SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
Google Moves Up Post-Quantum Cryptography Timeline
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Forums
Dancing Robot Goes Rogue
Comments posted to this topic are about the item Dancing Robot Goes Rogue
advice as i migrate my winscp based ssis pkg to our prod server
Hi , i installed winscp on my pc, added it to GAC thru vs...
Identities and Sequences II
Comments posted to this topic are about the item Identities and Sequences II
Question of the Day
Identities and Sequences II
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers