What is Database Continuous Integration?
This is an introductory article to explain what Continuous Integration (CI) is and how it can be used in database development.
2015-04-07
6,547 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
2015-04-07
1,910 reads
The Devil's in the Details
This week Steve Jones notes that the little details can sometimes have a big impact in your code.
2015-04-06
151 reads
2015-04-06
1,983 reads
Large Chunks of Data
This Friday Steve Jones talks reporting. Specifically he wonders how long can a report be before it's just wasting space.
2015-04-03 (first published: 2010-09-17)
363 reads
tSQLt with TRY..CATCH
Someone asked me the question recently about how tSQLt works with TRY..CATCH blocks and the exceptions that we might test...
2015-04-03 (first published: 2015-03-25)
8,288 reads
New Blogger Challenge 1 – Adding a Primary Key
The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to...
2015-04-02
808 reads
Check if SQL Server is running
This script will check if the SQL Server you are connected to is actually running.
2015-04-01 (first published: 2015-03-27)
1,793 reads
Get Your Service Broker Messages in Order. Always.
Learn how you can guarantee the ordering of all messages in a Service Broker queue, regardless of conversations.
2015-04-01
3,145 reads
Microservices and Databases
I ran across a post on microservices recently and was intrigued. I always like the idea of loosely coupled, independent...
2015-03-31
2,777 reads
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 KAS RANCAEKEK TLP/WA 083800209966
Jl. Raya Bandung - Garut No.KM 21, RW.5, Mekargalih, Kec. Jatinangor, Kabupaten Bandung, Jawa...
Cara Penghapusan Iuran Tahunan Kartu Kredit DBS
Untuk menghapus iuran tahunan (annual fee) kartu kredit DBS, hubungi DBS Customer Center di...
BCA KCP Pasar Minggu Center HUB/WA 0821•697•7701
Jl. Lenteng Agung Raya No.26 E-F, Ps. Minggu, Kota Jakarta Selatan, Daerah Khusus Ibukota...
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