Dynamically process SSAS Cube from SSIS package
Learn how you can modify an SSIS package to dynamically process SSAS cubes.
Insert and Delete SQL Server Data with Views
In this tip we look at how to insert and delete data via SQL Server views.
Obsoleting Unused SSRS Reports
Learn about programmatically obsoleting unused SSRS reports from your Report Server.
Translating a SQL Server Schema into a Cassandra Table: Part I Problem Space and Cassandra Primary Key
As many companies consider moving data to NoSQL, Cassandra may be the choice. In this series, Shel Burkow discusses design considerations for porting a SQL Server schema to Cassandra. The first article explains the Cassandra primary key.
Use Polybase to consume Oracle data from SQL Server on Linux 2019
Learn how to set up Polybase in containers to access an Oracle database.
Replace Model SQL Server Database with a User Database
In this tip we look at what happens if we replace the SQL Server model database with a regular user database
A Problem with Cowboy Coding
Cowboy coding can be a problem, and in a case Steve talks about, a temptation for someone to get more work.
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 Kas Pasar Bengkok Telpon. 08388331767
WhatsApp 08388331767 Jl. KH Hasyim Ashari No 9J, RT.001/RW.005, Pedurenan, Pinang, Tangerang City, Jawa...
BCA KCP Kayu Tangi Telp:Cs.WA:0831•7943•7466
WhatsApp 0831•7943•7466 Jl. Brigjen H Jl. Brigjend H. Hasan Basri No.26 E, Alalak Utara,...
BCA KCP Sulawesi No. Telpon 087781685658
WHATSAPP 087781685658 Jl. Sulawesi No.34, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan 90174
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