Building Better Software
Steve Jones discusses the idea of building software better, and why that's a challenge for many of us.
2016-03-10
114 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
Find a String in a String in SQL Server
Learn how you can find data in a string and extract it, no matter where it's located.
2016-03-10
42,071 reads
The Slack Integration
Slack has become a popular phenomenon in the technical world, especially for software developers. Should we join in?
2016-03-09
231 reads
2016-03-09
1,177 reads
Converting SQL Backup Files to MTF
I got a copy of some backup files recently and needed to restore them. However, I don’t have SQL Backup...
2016-03-08
1,359 reads
The Data Driven Event
In a couple of days, Microsoft is holding Data Driven, an event that will highlight SQL Server 2016.
2016-03-08
111 reads
2016-03-08
1,148 reads
Restoring a Striped Backup–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-03-07
1,598 reads
2016-03-07
314 reads
PowerShell–Don’t Use Write-Host
I’ve written a few scripts and programs lately, mostly just for fun. In those scripts, I’ve used Write-Host to return...
2016-03-04
1,638 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Alamat BCA KCP Cilandak KKO I Telp/Wa:0821-8200-233
Telp/Wa 62 821-8200-233 Jl. Raya Cilandak KKO No.9, RT.1/RW.5, Ragunan, Ps. Minggu, Kota Jakarta...
Alamat BCA KCP Arkadia Telp/Wa:0821-8200-203
Telp/Wa 62 821-8200-203 Gedung Perkantoran Hijau Arkadia, Tower C - Ground Floor, unit C103,...
BCA KCU KUNINGAN Telp/Wa:0821-8200-174
Telp/Wa 62 821-8200-174 Menara Karya, Jl. H. R. Rasuna Said Ground floor, RT.1/RW.2, Kuningan,...
Question of the Day
Adding new column with DEFAULT
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers