Exploring Your SQL Server Databases with T-SQL
Scott Swanberg shares 38 scripts he uses time and time again for discovering more about database objects.
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.
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCP Bintaro Hubungi Cs.0851•8812•0691
BCA KCP Bintaro Hubungi Cs.0851•8812•0691 Jl. RC. Veteran. 9, dan No.9A, Daerah Khusus Ibukota...
BCA KCP Pluit Raya TLP/WA 08216977749
Jl. Pluit Raya No.200, Penjaringan, Kecamatan Penjaringan, Jkt Utara, Daerah Khusus Ibukota Jakarta 14440
BCA KCP Mal Taman Anggrek TLP/WA 08218573837
By Quay thu XSMN hôm nay - quay thu MN - KETQUA.TV
Jl. Letjen S. Parman No.Kav. 21 Lower Ground Lot. C 07, Slipi, Kec. Grogol...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers