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,503 reads
SQL Server service account information is stored in Windows Registry database. You can get this information from Services Console or...
2013-08-20
2,503 reads
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
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
735 reads
To SELECT only top N rows from a table we can use TOP clause in SELECT statement. Using TOP clause...
2013-07-15
862 reads
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,723 reads
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,173 reads
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
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,156 reads
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,273 reads
To move a database from one location to other you fist need to detach the database from server. In this...
2013-06-03
1,145 reads
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WhatsApp:0818-751-777 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu Sel., Kec....
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers