SQL Server Alerts provide a great way for the server to notify a DBA that some event has occurred, usually something bad that they need to fix. However alerts can also be used to drive business logic processes and enable some types of actions to be safely performed without requiring extraordinary rights by a user. Author Leo Peysakhovich brings us some ideas on how we can use alerts to implement business logic processing.
2004-08-10
22,170 reads
Brian Knight has started a new series base on his impressions of SQL Server 2005, Beta 2, aka "Yukon". Read about his first impressions of the product as he starts down the path of learning about the next version of SQL Server.
2004-08-09
18,672 reads
2004-08-06
2,311 reads
2004-08-05
2,615 reads
2004-08-04
1,995 reads
2004-08-03
2,090 reads
2004-08-02
2,432 reads
Automating SQL Server tasks is the sign of an experienced DBA. One who doesn't waste time on repetitive tasks that can be easily setup in a job, task, or some other scheduling process to run when they need to run. Haidong Ji has written a number of articles on how to perform automation and brings us yet another technique. This time he looks at managing your backup files, something that we all need to do, but all too often forget to do.
2004-08-02
17,418 reads
2004-07-30
2,321 reads
2004-07-28
2,413 reads
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
BCA KCP C' One Plaza. Jl. Letjen Suprapto No.62, Cemp. Putih Bar., Kec. Cemp....
Jl. Mangga Raya No.20, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat, Daerah Khusus...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers