2014-03-13 (first published: 2014-02-25)
1,122 reads
Scripts
Calendar Table by Year
Populate a calendar table with user set interval start and end datetime values.
2014-03-11 (first published: 2014-02-21)
2,233 reads
Find Size of files used in Database
This script will help in identifying file size of primary file, log file and all partition files. This include free space available and space used for each file in a database.
2014-03-03 (first published: 2014-02-20)
1,274 reads
How much space could you get shrinking all databases
This is script is useful when you are short of space on a drive and you need to know how much space can you get shrinking your databases
2014-02-28 (first published: 2012-11-08)
2,785 reads
2014-02-27 (first published: 2014-02-11)
1,941 reads
Get the all the tables on the server which do not have Clustered index
Get the list of the tables on the server which dont have the clustered index.
2014-02-24 (first published: 2014-02-17)
1,410 reads
retrieve SSRS report schedule info through SQL
Grabs information about what reports in SSRS are scheduled, when are they due to be sent out, report parameters and any errors in the last run etc.
2014-02-21 (first published: 2010-08-18)
2,620 reads
Find Job Names that Contain SSIS Packages and their Location
This will give you a list of jobs that contain SSIS Packages should you have a project in which you may need to review changes to Packages.
2014-02-17 (first published: 2011-07-28)
1,779 reads
Kimball ETL (subsystem 1) – Data Profiling via TSQL
This script will generate a report providing all normally expected statistics for data Profiling .(ie.. Min, Max, Unique Count, Pattern etc....)
2014-02-12 (first published: 2012-05-21)
4,144 reads
Find List of Columns Updated inside Trigger
This will list the columns used by the update statement inside a trigger. More generic and useful for columns > 32.
2014-02-10 (first published: 2012-06-06)
1,592 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Alamat BCA KCP Atrium Telp:08218520154
WhatsApp CS 628218520154 Ruko Atrium Blok E. 12-13, RT.5/RW.18, Sunter Agung, Kec. Tj. Priok,...
Alamat BCA KCP Bungur Telp:08218520154
WhatsApp CS 628218520154 Jl. Bungur Besar Raya No.32 & 32A, RT.3/RW.1, Gn. Sahari Sel.,...
Alamat BCA KCP Cempaka Putih Raya Telp:08218520154
WhatsApp CS 628218520154 Jl. Cempaka Putih Raya No.118 B,C,D, RT.16/RW.3, Cemp. Putih Tim., Kec....
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers