Essential Steps for the Integrated Enterprise Data Warehouse, Part 2
This article describes what the dimension manager and fact provider do, and how to configure business intelligence tools to use the integrated EDW.
Modifying Microsoft Access Linked Tables from SQL Server
In a previous tip we saw how easy it was to link to SQL Server tables from Microsoft Access. As is the case with all systems, how does Access manage the changes? What happens when you modify the structure of the underlying SQL Server table? What happens to the SQL Server table if you delete the linked table in Access? We will look at each of these situations in this tip.
The CLR
The CLR was one of the highly touted additions to SQL Server 2005, and one of the reasons for its long development cycle. Steve Jones comments on why it hasn't been that widely used.
Encrypting Data
Encrypting data is the easy part of dealing with encryption and databases. Steve Jones talks about some of the other, more difficult, issues you must handle.
Encrypting Data
Encrypting data is the easy part of dealing with encryption and databases. Steve Jones talks about some of the other, more difficult, issues you must handle.
Encrypting Data
Encrypting data is the easy part of dealing with encryption and databases. Steve Jones talks about some of the other, more difficult, issues you must handle.
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 KCU RAWAMANGUN Telpon/WA:08213111185
BCA KCU RAWAMANGUN Telpon/WA:08213111185 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta...
Cs Lion Air Tower Tlp/ Chat 083843888827
Cs Lion WhatsApp 083843888827 Sunset Road 100 C,Simpang Siur Kuta, Jimbaran, Kec. Kuta Sel.,...
BCA KCU KALIMALANG Telpon/WA:08213111185
BCA KCU KALIMALANG Telpon/WA:08213111185 Jl. Tarum Barat Blk. E No.5, Wil. Kota, Kec. Duren...
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