SQL Server Service Broker (SSBS) is a new architecture (introduced with SQL Server 2005 and enhanced further in SQL Server 2008 and later versions) that allows you to write asynchronous, decoupled, distributed, persistent, reliable, scalable and secure queuing/message-based applications within the database itself. Arshad Ali looks at how we can manage, monitor and troubleshoot Service Broker environments.
On Thursday July 20th, MCM Gaurav Aggarwal will provide an overview of the different options on MS platform for Hadoop
Steve Jones is your host introducing Grant Fritchey who'll present this webinar. This session explores the use of two Red Gate products, SQL Virtual Restore and SQL Source Control, in establishing a well-defined development process that allows for the use of known data sets and source code management of your database code. These tools work together to help you create a sandbox environment where you can test and develop your databases. Working with a development process is the best way to ensure a safe deployment process to protect your production systems.Developing software without establishing a good process can be a situation rife with the possibility of disaster.
Why don't employers want to fund training? Steve Jones has a few thoughts after a great piece that shows the lack of wisdom in withholding training.
This level covers the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored.
It is certainly possible to fake an Array in SQL, but there are only a few occasions when it would be the best design. Most often, the wish for an array in SQL is a sign of a forlorn struggle against poorly-normalised data. One of the worst sins against Codd is the repeating group, as Joe Celko explains.
Today we have a guest editorial from Andy Warren that talks about fitting in at work and conforming to the expectations of the group and that environment.
In the first part of this series, learn how to pinpoint missing indexes in your databases.
In order to gain better support for learning and training opportunities, the DBA needs to prove a direct link to productivity and results, in words and numbers the CEO will understand.
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...
Kantor BCA Finance pusat Telp/WA.0851°8812°0691 Jl. Metro Pondok Indah No.10 Lt 2, RT.3/RW.17, Pd....
Tlpn/wa0853.7373-7551 Jl. Pantai Indah Selatan Blok DF No.1 & 2, Kapuk Muara, Kecamatan Penjaringan,...
BCA KCU MENARA BIDAKARA Telp/WA0851•8812•0691 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers