Power BI Advanced Q&A
What advanced features are available in the Power BI Q&A functionality? Also, how does the new Q&A visual work?
Export/Import Data using BCP - SQL Server on Linux
In this article you will learn how to use BCP for SQL Server on Linux to export and import data using the BCP command line utility.
Cloning all the Databases on a Server
Phil Factor shows uses SQL Clone and PowerShell to automatically create images of all databases on an instance, if they don't already exist, and then create or refresh clones of each one, on all your development servers.
SQL Server Attach and Detach Database Examples
In this article Dinesh Asanka looks at how to detach and attach a SQL Server database using the SSMS GUI and using T-SQL commands.
Creating a Logical SQL Server: Level 2 of the Stairway to Azure SQL Database
In this second level of the Stairway to Azure SQL Database, we cover the basics of building a logical server using the portal and PowerShell.
Why A Query May be Faster the Second Time it Runs
Today, Kendra Little explains why a query may run faster the second time you run it.
Removing the Square Bracket Decorations with SQL Prompt
If you avoid illegal characters and reserved words in your identifiers, you'll rarely need delimiters. Sadly, SSMS applies square bracket delimiters indiscriminately, as a precaution, when generating build scripts. Phil Factor provides a handy function that adds quoted delimiters only where they are really needed and then sits back and lets SQL Prompt strip out any extraneous square brackets, in a flash.
Running Database Console Commands (DBCCs) on Azure SQL Database
Practically every SQL Server Database Administrator operating in an on-premises environment is familiar with Transact-SQL DBCC statements that serve the role of Database Console Commands. However, there are some additional considerations that should be considered when using them in the context of Azure SQL Database deployments.
Do Not Set Trustworthy On for the SSISDB Catalog
Learn how to correctly fix your SSISDB without using Trustworthy.
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 Tmn. Harapan Indah. Tlp:085373737845
BCA KCP Tmn. Harapan Indah. Tlp:085373737845.Komp. Taman Harapan Indah Blok EE No.1, Jelambar Baru,...
BCA KCP Pluit Kencana Tlp (+62 821°3111°179
Jl. Taman Pluit Kencana Selatan No.1-3, RT.4/RW.6, Pluit, Kecamatan Penjaringan, Jkt Utara, Daerah Khusus...
Wisma BCA BSD Tlpn/wa:085373737551
Jl. Pahlawan Seribu No.8, Lengkong Gudang, Kec. Serpong, Kota Tangerang Selatan, Banten 15310
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