2019-05-03 (first published: 2015-05-08)
1,133 reads
Scripts
Query to find the Job Output file location at each job step
Query to find the Job Output file location at each job step.
This helps if you want to find out the location of each output file of jobs to find out whether those are going to the right location.
2019-05-03 (first published: 2015-04-24)
3,337 reads
Read all trace file data and print the action performed
If you want to read trace file records from default trace location and want to print to see what are all the activities happened on SQL Server, the query will be helpful for you.
2019-05-03 (first published: 2014-11-12)
2,336 reads
READ Data from default Trace
READ Data from default Trace to know when the objects are altered. If no database name is provided, it will run through all the databases.
2019-05-03 (first published: 2015-04-08)
1,423 reads
2019-05-03 (first published: 2016-10-05)
23,020 reads
Report Alerts from SQL ErrorLog
Sends Back Critical Alerts from ErrorLog occurred in the last 24 Hrs. You can even modify the data [Check @start and change the value]
2019-05-03 (first published: 2015-05-15)
2,493 reads
Retrieving XML data to Table from dm_os_ring_buffers
Retrieving XML data to Table from dm_os_ring_buffers for better readable purpose
2019-05-03 (first published: 2015-08-03)
991 reads
Run a specific query across all servers using powershell
Run a specific query across all servers using powershell
2019-05-03 (first published: 2015-03-06)
3,264 reads
2019-05-03 (first published: 2010-12-15)
2,987 reads
Search a string in a text with number of occurrences
IF you have a long string and if you want to search a specific input string, and number of timeS the string has occurred then it's helps
2019-05-03 (first published: 2015-03-29)
1,434 reads
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat BCA KCU BEKASI | Tlp/WA:0817819444
Wa:0817819444 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, Jawa...
Alamat BCA KCU TUBAN | Tlp/WA:0817781222
Wa:0817819444 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314
Question of the Day
Multiple Values Inserted
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