Power BI to Azure SQL and Google Analytics
In this demo, we will give an introduction from 0 about Power BI and how to connect to Azure SQL Databases and Google Analytics
The Bad Data Shutdown
Not more hacking, but rather a data error in some cars is disturbing to Steve Jones.
3 Built-In Technologies for Centralizing SQL Server Administration
DBAs can be more effective in managing their workload by centralizing their procedures. There are several features of SQL server that can be harnessed to this end: PowerShell is only part of the solution: there is also Central Management Server, Master /Target Agent and the Remote Server Administration Tools. It's time to work out your objectives and pick the most suitable technologies to meet them.
Difference between SQL Server Unique Indexes and Unique Constraints
Uniqueness of values in specific columns can be enforced in a SQL Server table by creating a unique constraint or a unique index on those columns. In this article, Sergey Gigoyan looks at what the differences between the two are, and how SQL Server handles them both.
An example of how networking netted a new job
Today we have a guest editorial as Steve is away on vacation. You often hear about how important it is to network. This is a story of how my network helped me get a new job.
SSIS Design Pattern - Staging Delimited Flat Files
Learn how to use SSIS to load Delimited Flat Files to staging tables.
The cmdlets Are Coming! The cmdlets Are Coming!
A number of new SQL Server PowerShell cmdlets have been released and the Microsoft is asking for feedback on what else you'd like to see.
Mutating Table Error In Oracle: Why It Happens And What You Can Do About It
David Fitzjarrell takes a look at why the mutating table error is thrown, why it's not going to create data problems, and how to possibly fix it.
Execute a data-driven SSRS subscription from SSIS to archive a report
This article demonstrates how to generate and save an SSRS report to a network folder when an SSIS package is executed.
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 Metro Jababeka Tlpn/wa:085373737551
Jababeka, Cikarang, Plaza JCBD Blok A 26, 27 dan 28, Pasirsari, Cikarang Sel., Kabupaten...
BCA KCP Bojong Indah,Telpon/Wa 0821-8200-239
Komp. Bojong Indah Cengkareng, Jl. Pakis Raya 88 H, Daerah Khusus Ibukota Jakarta 11740
BCALife KCU Denpasar. Tlp:08218168235
86R7+Q35, Jl. Hasanuddin, Dauh Puri Kangin, Kec. Denpasar Bar., Kota Denpasar, Bali 80232
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