SQL Server Service Broker (SSBS), introduced with SQL Server 2005 and enhanced in SQL Server 2008, allows you to write queuing/message based applications within the database itself. This article discusses creating an application in which Initiator and Target both are in the same database.
2010-08-30
2,117 reads
After a webinar for SQL Source Control, there were a large number of questions left unanswered. All have been listed here, along with answers from the Red Gate development team.
2010-08-27
3,863 reads
we normally do development on the development box; then during the build preparation we compare the development database with the QA/UAT/Production database to identify differences and generate schema objects for synchronization or incremental deployment scripts. How we can compare schema objects between databases and generate synchronization or incremental deployment scripts?
2010-08-27
4,519 reads
Error: 0xC001405C at SQL Log Status: A deadlock was detected while trying to lock variables "User::RowCount" for read/write access. A lock cannot be acquired after 16 attempts. The locks timed out. Have you ever considered variable locking when building your SSIS packages? I expect many people haven’t just because most of the time you never see an error like the one above. I’ll try and explain a few key concepts about variable locking and hopefully you never will see that error
2010-08-26
3,320 reads
Learn how the DTExec and DTExecUI utilities give you the ability to assign values to arbitrary properties of components within a SQL Server Integration Services package, when invoking its execution.
2010-08-24
3,224 reads
For security reasons many sites disable the extended stored procedure xp_cmdshell, which is used to run DOS commands or executables. When you really have to run a DOS command or an executable from a stored procedure how can you get around this limitation without a breakdown in security.
2010-08-23
5,335 reads
It's time to integrate social data, enterprise analytics and enterprise data for better social-media strategy.
2010-08-20
1,748 reads
This tool is excellent when investigating what is going on in your StreamInsight Streams. I was looking through the menu items recently and went to Query => Event Fields I found that there were a couple of columns not added by default to the event viewer (Reminds me of the fact that the Variables viewer in SSIS hides columns also) Latency NewEndTime EnqueueTime Here they all are together. This gives us even more information about what is going on
2010-08-19
1,579 reads
I understand that I can use Central Management Servers to run a T/SQL query against multiple instances at once - can I do this without CMS though?
2010-08-18
3,181 reads
Performing a LEFT OUTER JOIN in TSQL is easy. The same logic in StreamInsight requires a little more work. In this presentation I show exactly how you can perform a LEFT OUTER JOIN on your event streams. Your browser cannot play this video. Learn how to fix this.
2010-08-17
2,348 reads
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Pondok Bambu Center, Jl. Pahlawan Revolusi No.30 Blok A/5-6, RT.2/RW.2, Wil, Kec. Duren Sawit,...
Tlp/WA.(+62 821°3111°179 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota...
Tlpn/wa0853.7373-7551 Jl. Dewi Sartika No.189, RT.1/RW.5, Wil, Kec. Kramat jati, Kota Jakarta Timur, Daerah...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers