2011-06-13 (first published: 2008-04-19)
5,848 reads
Scripts
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,576 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,454 reads
Numero de Registros y espacio usado en disco
Generacion de numero de registros y espacio usado en disco todas las tablas de la base de datos
2011-06-08 (first published: 2008-06-24)
535 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,933 reads
2011-06-03 (first published: 2008-08-18)
1,089 reads
2011-06-02 (first published: 2008-04-24)
9,282 reads
2011-06-01 (first published: 2007-09-02)
10,474 reads
Point in time restore to a new DB from files of a Full Recovery Model
Script generator to restore to a new DB. Designed on Ola Hallengren's backup solution.
2011-05-31 (first published: 2011-05-20)
962 reads
2011-05-30 (first published: 2011-05-23)
2,416 reads
Blogs
T-SQL Tuesday #199 Invitation: Back to on-prem?
It’s time for T-SQL Tuesday again! And we’re almost to number 200! T-SQL Tuesday...
Data Skew in Data Engineering: What It Is and How to Fix It
You kick off a distributed job expecting it to finish in minutes — but...
Error Deploying GraphQL in Fabric: dm_exec_describe_first_result_set
A while ago we suddenly had an error while trying to deploy one Fabric...
Forums
BCA KCU VETERAN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Veteran No.18-24, Krembangan Sel., Kec. Krembangan, Surabaya, Jawa Timur 60175 @BCA KCU...
BCA KCU SALATIGA | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Jend. Sudirman Jl. Diponegoro No.15, Salatiga, Kec. Sidorejo, Kota Salatiga, Jawa Tengah...
BCA KCP Iskandar Muda | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec. Kebayoran Lama,...
Question of the Day
Representing Money
Which types of currency does the money data type represent?
See possible answers