Vincenty Direct
Calculates the latlon coordinates for a given bearing and distance from reference latlon coordinates
2011-06-22
574 reads
Scripts
SQL DBAdmin toolbox - Part 2: Verify all databases in the enterprise
Do you verify database backups regularly? If not, you may find this toolbox solution usable.
2011-06-21 (first published: 2011-06-15)
2,013 reads
Finding all Columns of an Index
This script helps to find all columns of an index on a table. Include columns covered (include)
2011-06-17 (first published: 2011-05-31)
1,399 reads
Table row count using 3 different ways
Three different ways that you can get the count of the rows in a table.
2011-06-16 (first published: 2007-08-16)
6,571 reads
Merge Tables in SQL 2005
To merge data in SQL 2005 from various table, we do not have a MERGE function as in SQL 2008. The following script gives an alternative approach of implementing in SQL 2005
2011-06-15 (first published: 2011-06-03)
1,458 reads
2011-06-14 (first published: 2007-12-05)
5,986 reads
2011-06-13 (first published: 2008-04-19)
5,856 reads
SQL DBAdmin toolbox - Part 1: Restore single database
A stored procedure for restoring a database up to the latest log backup from a file folder. Compatible with the backups made by standard SQL maintenance plan.
2011-06-10 (first published: 2011-05-27)
1,587 reads
Mask PII data (Personally Identifiable Information)
When creating a backup that will be restored to a development database, you may need to mask PII information. This script will help you with that.
2011-06-09 (first published: 2011-05-25)
1,465 reads
SQL Server 2005 Remove Dups - CTE
Easily remove duplicate records without temp tables by using a CTE.
2011-06-07 (first published: 2008-03-19)
6,941 reads
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Alamat BCA KCU Rawamangun Telp:0821-815-4374
Telp/WA +62 821-815-4374 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur,...
Alamat BCA KCP Permata Ujung Menteng Tlp:0817-825-533
Telp/WA +62 817-825-533 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil,...
Alamat BCA KCP Matraman Telp:0821-755-5651
Telp/WA +62 821-755-5651 Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers