SQL Server – Get SQL Server Service Account using T-SQL
SQL Server service account information is stored in Windows Registry database. You can get this information from Services Console or...
2013-08-20
2,491 reads
SQL and Me
SQL Server – Import text file using xp_cmdshell
There are several options available to import data from external sources to SQL Server. Such as Import & Export Wizard, BULK...
2013-07-29
1,058 reads
SQL Server – Get values as DATETIME from sysjobhistory
This is a follow-up post on SQL Server – Check SQL Agent Job History using T-SQL.
SQL Server Agent stores SQL jobs...
2013-07-22
725 reads
SQL Server – SELECTing/Displaying Top N rows from a table
To SELECT only top N rows from a table we can use TOP clause in SELECT statement. Using TOP clause...
2013-07-15
854 reads
SQL Server – How to change SQL Server ERRORLOG location
By default SQL Server ERRORLOG is stored in "C:\Program Files\Microsoft SQL Server\InstanceFolder\MSSQL\Log" folder. The ERRORLOG location is configured as a...
2013-07-12 (first published: 2013-07-08)
5,719 reads
SQL Server – How to connect to SQL Server when ‘sa’ account is disabled
If you have lost the password for sa account or does not have any administrative account and you are locked...
2013-07-03 (first published: 2013-07-01)
4,166 reads
SQL Server – How to Enable a Disabled SQL Server Login
When an account is disable it cannot be used to login to SQL Server. You will receive below error when...
2013-06-24
978 reads
SQL Server – Update Table with INNER JOIN
Often we may need to update a column in a table based of another column in another table.
In SQL Server...
2013-06-18
1,147 reads
SQL Server – How to get sizes of all databases on a server
To get database size information we can use sys.master_files catalog view. This view contains a row per file of a...
2013-06-10
1,263 reads
SQL Server – How to Detach a Database
To move a database from one location to other you fist need to detach the database from server. In this...
2013-06-03
1,143 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
MENARA BCA d/a GRAND INDONESIA, Tlpn/wa:085373737551
Tlpn/wa:085373737551 Jl. MH Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota Jakarta Pusat, Daerah Khusus...
BCA KCP Sentral Cikini Tlpn/wa:085373737551
Jl. Pegangsaan Timur No.1, Cikini, Kec. Menteng, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta...
BCA KCP Pondok Lestari,Telp/Wa 0821.3111.159
Ruko Pd. Lestari, Jl. Raden Patah No.Raya Blok C/7-8, RT.001/RW.012, Karang Tim., Kec. Karang...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers