Fooling SQL Server
Today Steve Jones looks at the new release of restore technology from Red Gate software that allows you to "fool" SQL Server.
Creating packages in code - Workflow
This is just a quick one prompted by a question on the SSIS Forum, how to programmatically add a precedence constraint (aka workflow) between two tasks. To keep the code simple I’ve actually used two Sequence containers which are often used as anchor points for a constraint. Very often this is when you have task that you wish to conditionally execute based on an expression.
SQL Social in Kent
On Aug 18, 2010 there is a SQL Social meeting in Kent, UK. Read about the details and attend if you are in the area.
(Un)Common Speed Phreakery
Is there such a thing as too much attention to the performance of SQL? It isn’t only a question of time and inclination, but also of the resilience and flexibility of the code.
Going From Many Schemas To One Schema
A Technique to deal with moving data from multiple schemas into one table
Security Disclosure
Did your company lose data last year? It can be hard to know, especially when even laws designed to ensure breaches are reported have loopholes. Steve Jones thinks this is a bad idea.
TSQL Challenge 36 - Create a graph/Chart with TSQL
This challenge invites you to create a graph/chart using T-SQL
SQL Server restart validation checklist
Many times there is the need to restart the SQL Server services, this could be a reboot of the server after patching, service pack installation or due to some other reason. Sometimes we may face issues after the restart for example the SPN is not registered, a database is offline etc... For the solution you can use the below standard SQL Server validation checklist after you restart your SQL services.
Million Dollar Challenge, The Sequel
Red Gate Software is having another million dollar challenge. If you work for a small software company, or have a software product of your own, read about the challenge.
SQL Q&A: Shrinking, Growing and Redesigning Databases
SQL databases come in all shapes and sizes and schemas. This month, our SQL expert helps with condensing, growing and redesigning databases.
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
Alamat kantor resmi BCA KCU BOGOR Telp: 0817.82.5533
WhatsApp: 0817825533, Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor,...
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
BCA KCP RADEN SALEH TLP/WA 083800119009
Jl. Raden Saleh No. 13, 15, 17A, Daerah Khusus Ibukota Jakarta 10430
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