Using OPENROWSET to read large files into SQL Server
OPENROWSET is a T-SQL function that allows for reading data from many sources including using the SQL Server’s BULK import capability.
The December 2008 Energy Update
Steve Jones gives one last update on energy issues in the US in 2008 with a look at the construction and building industries.
The December 2008 Energy Update
Steve Jones gives one last update on energy issues in the US in 2008 with a look at the construction and building industries.
The December 2008 Energy Update
Steve Jones gives one last update on energy issues in the US in 2008 with a look at the construction and building industries.
Changing Taxonomy
Steve Jones is considering changes to SQLServerCentral and presents a few ideas today.
Changing Taxonomy
Steve Jones is considering changes to SQLServerCentral and presents a few ideas today.
Changing Taxonomy
Steve Jones is considering changes to SQLServerCentral and presents a few ideas today.
How Would You Rate This? - Database Weekly (Dec 29, 2008)
Steve Jones wonders if Microsoft is doing a good job with their efforts to patch SQL Server security issues?
SSIS and Stored procedures using temp tables
SSIS has a problem with stored procedures that use temporary tables to generate output. This article describes a useful technique for working around this problem.
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 Kertopaten No.Telp 083831617937
Whatsapp.083831617937 Jl. Pegirian 114, Sidodadi, Kec. Simokerto, Kota SBY, Jawa Timur Surabaya, Jawa Timur,...
BCA KCP Kertopaten No. Telp 083138716609
Whatsapp: 083138716609 Jl. Pegirian 114, Sidodadi, Kec. Simokerto, Kota SBY, Jawa Timur Surabaya, Jawa...
BCA KCP Kertajaya Indah No.Telp 083831617937
Whatsapp.083831617937 Jl. Manyar Kertoardjo 95,Mojo, Kec. Gubeng, Kota SBY, Jawa Timur Surabaya, Jawa Timur,...
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