Asynchronous Procesing with Service Broker
Service Broker is a great feature that allows you to defer processing in SQL Server. Learn how you can have processes work together, but in an asynchronous fashion in this piece from Gary Strange.
Working Long or Working Hard?
Would you rather work longer hours or tackle harder work? Steve Jones comments today on a recent post by Seth Godin. The answer as to what most people prefer might surprise you.
SQL Server Replication: Providing High Availability using Database Mirroring
This white paper describes how to use database mirroring to increase the availability of the replication stream in a transactional environment. The document covers setting up replication in a mirrored environment, the effect of mirroring partnership state changes, and the effect of mirroring failovers on replication. In addition, it describes how to use LSN-based initialization to recover from the failover of a mirrored Subscriber database.
A story of corrupted Master database in SQL Server 2008
This is a real-time production issue I faced with one of our clients
Competing with an MBA
If you are looking to move into management, do you need an MBA? It's nice, but Steve Jones notes that many people are realizing that an MBA doesn't necessarily prepare you to manage other people or lead them in a company.
TSQL Challenge 56 - Create a Sierpinski carpet using TSQL
This challnge invites you to generate a Sierpinsky carpet using TSQL
Wish you were here?
As it gets easier to attend events virtually, it's worth considering what the literal, financial value is of physical attendance.
Space Impact of Replication Snapshot Agent Job in SQL Server
I have noticed that available disk space on my SQL Server is getting low and I see a number of files getting generated in the replication snapshot folder. Because of these files there is a space issue on my server. Why are these files here and what can I do to resolve this problem?
Loading Data With Powershell
Moving data in and out of SQL Server is a fundamental task for any developer or DBA. Chad Miller brings us a new way that we can load Powershell output into a SQL Server database.
How to handle empty values in a line chart in SSRS
When continuous data is displayed on a chart, such as a line chart, data is displayed very smoothly. But when non-continuous data is displayed on such a chart, the chart behavior is different. The continuous data is displayed correctly, but the non-continuous data is ignored on the chart. In such cases, handling of empty points in the dataset is required to make the data continuous and displayed correctly on the chart. In this tip we will look at how to implement a solution for this problem.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Ruko Kalimas Lyn Cs 083835110341
Ruko Kalimas, Blk. B Jl. Chairil Anwar No.6, RT.004/RW.012, Margahayu, Kec. Bekasi Tim., Kota...
BCA KCP BATAM CENTER 2 TLP/WA 081717899866
Komplek Pertokoan Grand Niaga Mas Blok A No. 21-22, Kota Batam, Kepulauan Riau 29461
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers