Automating SSIS Design Pattern - Stage Delimited Flat File
How long does it take to create to 100 staging packages? The answer will shock you!
Trust People
Steve Jones thinks that we are not doing a great job of harnessing the brain power of our entire teams.
Knee-Jerk Wait Statistics : CXPACKET
With another entry in his knee-jerk series on wait statistics, Paul Randal (@PaulRandal) explains CXPACKET and why it may or may not be a problem.
Data Loss or Downtime
This Friday Steve Jones has a DR poll. He asks what might be more important to you in a disaster and why.
FORMAT() is nice and all, but…
Aaron Bertrand compares multiple date formatting techniques, demonstrating again that SQL Server's FORMAT() is not worth the convenience.
Data Mining Part 30: System Views
Sometimes we need to retrieve system information from our data mining models. In this chapter, we will show how to do it using system views.
Data Mining Part 30: System Views
Sometimes we need to retrieve system information from our data mining models. In this chapter, we will show how to do it using system views.
How to Unlock Your Team's Creative Power with SQL Prompt and a VCS
Extend SQL Prompt's functionality by connecting your snippets to version control
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
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 Kantor Resmi BCA KCU MANADO Tlp:08218154393
WA:08218154393 Jl. Sam Ratulangi No.17-19, Wenang Utara, Kec. Wenang, Kota Manado, Sulawesi Utara 95111
Alamat Kantor Resmi BCA KCU PANAKKUKANG Tlp:08218154393
WA:08218154393 Jl. Boulevard No.5 Blok F5, Masale, Kec. Panakkukang, Kota Makassar, Sulawesi Selatan 90231
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers