We don't test software well enough. Obviously we don't write high enough quality software, but testing should catch more issues. Steve Jones talks about how you can perform better T-SQL testing.
2016-12-20 (first published: 2013-11-12)
272 reads
The way we write code impacts our users, but it can also impact our wallet, especially in cloud computing. Steve Jones wonders how many people bother to profile and test their code.
2016-12-19 (first published: 2013-05-13)
389 reads
2016-12-19
933 reads
With the holiday season here, Steve Jones wonders what you'll do for fun away from work.
2016-12-16
124 reads
Awhile back I was working in SSMS and saw this window.
It threw me off since I was trying to write...
2016-12-16 (first published: 2016-11-30)
1,831 reads
2016-12-16
936 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-12-15
637 reads
Here’s a shot from our engineer, behind the scenes of my live talk today.
Tom Austin and @way0utwest live at #sqlinthecity...
2016-12-15
645 reads
2016-12-15
1,355 reads
2016-12-14
78 reads
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Comments posted to this topic are about the item Adding new column with DEFAULT
I've got a web application for my side business. I've added a SQL Server...
Comments posted to this topic are about the item Looking for New Blood
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