How do I run code automatically when SQL Server starts?
The need to run a stored procedure or SQL Agent Job when SQL Server or SQL Agent starts is a common requirement in the world of SQL Server administration. This article gives an overview of the ways to execute SQL stored procedures or SQL Agent jobs on startup.
Powerful Geographical Visualisations made easy with SQL 2008 Spatial (Part 2)
This is the final article in a series on how to perform data visualisation with SQL Server 2008
Powering up DTS with PerlDTS
This article introduces the PerlDTS project that provides a Perl distribution to access and execute MS SQL Server 8 DTS packages.
The Set-Based Limit
An interesting post from Linchi Shea inspires Steve Jones to comment on procedural v set-based programming.
Powerful Geographical Visualisations made easy with SQL 2008 Spatial (Part 1)
This article is part one of a two part series on how to perform data visualisation with SQL Server 2008
Smart Teaching
Do computers help us learn quicker? Do we need to in today's wired world? Steve Jones talks a little about learning in today's editorial
Smart Teaching
Do computers help us learn quicker? Do we need to in today's wired world? Steve Jones talks a little about learning in today's editorial
Smart Teaching
Do computers help us learn quicker? Do we need to in today's wired world? Steve Jones talks a little about learning in today's editorial
SQL inner and outer joins: Basics for getting started
Learn the basics to create a SQL inner join and SQL outer join. Get examples on how to use them for a customized result set querying more than one table.
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
BCA KCP Reg.Tanah Abang Telpon/WA:087768193341
BCA KCP Reg.Tanah Abang Telpon/WA:087768193341.Ps. Regional Tanah Abang, Blok F, Lt. Dasar, Kp. Bali,...
BCA KCP Buluh Indah. Tlp:08218168235
<!--more-->Jl. Buluh Indah No.88, Pemecutan Kaja, Kec. Denpasar Bar., Kota Denpasar, Bali 80118
BCA KCP Roxy Mas Telpon/WA:087768193341
BCA KCP Roxy Mas Telpon/WA:087768193341.Jl. KH. Hasyim Ashari No.6 - 8 Blok C.5, Cideng,...
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