Security Queries: Server-level
A set of queries which attempt to gather as much security-related information on a server instance as possible.
2013-11-06 (first published: 2013-10-24)
3,166 reads
Scripts
An easy way to track the growth of your database
This query gives you an idea of the growth of your database over time.
2013-11-01 (first published: 2008-03-10)
14,389 reads
Performance Testing Script
Fourth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2013-10-31 (first published: 2009-02-17)
10,587 reads
PivotByDate clr stored procedure
This script pivots 1 to N numeric columns, grouping by 1 to N (N)(Var)char columns, pivoting by distinct date.
2013-10-30 (first published: 2013-10-15)
1,103 reads
Get record count for a specific database
This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.
2013-10-23 (first published: 2007-12-17)
19,853 reads
2013-10-22 (first published: 2007-10-10)
30,316 reads
Function to format a datetime variable by a mask
I have used the following function to convert dates according to desired textual formats that were not immediately available in the standard styles on offer.
2013-10-18 (first published: 2013-10-01)
2,017 reads
Unique Identifier as Clustered index
This script selects clustered indexes containing only a uniqueidentifier column
2013-10-17 (first published: 2013-10-02)
1,223 reads
Find the size of all Indexes in a database
This script finds the size of all indexes in a database along with the table and the filegroup on which the index resides.
2013-10-15 (first published: 2013-09-23)
1,878 reads
Find Top 5 expensive Queries from a Write IO perspective
Top 5 expensive Queries from a Write IO perspective
2013-10-03 (first published: 2013-09-09)
2,371 reads
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
ALAMAT KONTAK BCA KCP Katamso Telp:08218154393
WA:08218154393 Jl. Brigjen Katamso No.183, Keparakan, Kec. Mergangsan, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55121
ALAMAT BCA KCU SUBANG Telp:08218154393
WA:08218154393 Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa Barat 41211
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers