Survey on SSDT and Database Projects
Red Gate are developing new tools for users of SSDT and Database Projects in Visual Studio. If you use these technologies, help us make our tools ingeniously simple by completing this 10 minute survey.
SQLintersection & DEVintersection Conference Descends On Las Vegas November 10-13
DevIntersection and SQLIntersection conference will bring together experts from Microsoft, SQLSkills, .NET Rocks, and 90 industry gurus.
What To Do When the Import and Export Wizard Fails - Part I Imports
My “Success” story describes the import process when it works without a hitch, while my “Challenge” story highlights a common difficulty encountered when using the Microsoft Import and Export Wizard, and then offers a solution.
Why Would You Move?
Most people prefer to work with the platforms that they are familiar with, but there is always pressure to try new, exciting technologies when others have success. Steve Jones explores the idea of switching platforms.
Starting as a SQL Server Business Intelligence Developer
Besides the technical skills required to be a proficient SQL Server business intelligence developer, there are numerous "soft" skills that can contribute to your success.
It's about Perception
What's the most important thing about your application? The code? The accuracy of its calculations? The layout of the reports? Steve Jones has another opinion.
Drop and Re-Create All Foreign Key Constraints in SQL Server
Aaron Bertrand supplies a script which generates two separate sets of commands: one to drop all foreign key constraints, and one to create them again. These scripts are stored in a table so that, if you drop the constraints and then disaster of some kind strikes during the create, you still have everything handy and can troubleshoot if needed.
Troubleshoot SQL P2P replication doesn't replicate DDL schema change.
This article shows a problem with P2P replication doesn't replicate DDL schema changes and something you might want to check.
Who Watches the Watchers?
Who checks on those who manage our systems? Is there auditing in place for those accidental DBAs?
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 Balai Pustaka Tlpn/wa:085373737551
Jl. Balai Pustaka Timur, Blok J No. 225, C, RT.4/RW.3, Wil, Kec. Pulo Gadung,...
Pt BCAFinance Bontang,Telp/Wa 0821.3111.159
Jl. R. Suprapto No.81, Api-Api, Kec. Bontang Utara, Kota Bontang, Kalimantan Timur 75313
BCA Multifinance,Telp/Wa 0821.3111.159
5X88+8MH, Sampit, Kec. Delta Pawan, Kabupaten Ketapang, Kalimantan Barat 78811
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