2010-04-01 (first published: 2010-03-31)
4,401 reads
Scripts
View to obtain Failed Jobs from SQL Server Agent
With this view you can obtain last failed job steps without using visual interface.
2010-03-30 (first published: 2010-03-19)
2,393 reads
2010-03-29 (first published: 2010-03-24)
1,852 reads
Finding rows count in a table without Select...
Here is a one more very quick way to find row count for a table.
2010-03-26 (first published: 2010-03-23)
5,410 reads
Credit Card Number Validation Escalar Function
Evaluate credit card numbers based on ISO 2894 algorithm.
2010-03-24 (first published: 2010-03-17)
1,945 reads
Script to get Phonetic Pronunciation of a given password
This script displays Phonetic Pronunciation of a given password
2010-03-22 (first published: 2010-03-12)
1,409 reads
2010-03-17 (first published: 2010-03-04)
1,548 reads
EXECute SQL Commands over entire sets of parameters!
A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.
2010-03-16 (first published: 2010-03-04)
2,977 reads
Unused Objects in the Server
This Script is used to List out the objects lying in the box which were un used from the day of the sql server recycled.
2010-03-09 (first published: 2010-02-18)
1,945 reads
ServerProperty query with case function
Returns all properties from ServerProperty, also has a case function for EditionID and EngineEdition.
2010-03-08 (first published: 2010-02-18)
1,409 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
Alamat Telp BCA KCP Palur +62 838-4945-0961
Wa:083849450961 Jl. Raya Palur No.Km 5, Jurug, Ngringo, Kec. Jaten, Kabupaten Karanganyar, Jawa Tengah...
Telp BCA KCP Utan Kayu +62 838-4945-0961
Wa:083849450961 Jl. Utan Kayu Raya No.94, RT.12/RW.10, Utan Kayu Utara, Kec. Matraman, Kota Jakarta...
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers