An Age of AI?
The age of artificial intelligence seems to be here, but it's a little different to what we were promised.
2019-07-22 (first published: 2016-02-15)
449 reads
DaveConvery
2016-10-17
110 reads
2016-04-18
90 reads
SQL Injection - The Revenge
As yet more personal details are spilled by preventable security lapses, what's
2015-11-02
298 reads
Who Cares About Your Data?
The observation that people hear what they want to hear is not a new one, and yet the extent to which people will go out of their way to ignore or misinterpret evidence can still surprise.
2015-06-01
122 reads
Email In The Bathroom: Not A Universal Good
Here are some fine, affordable products to completely destroy your work-life balance.
2015-04-27
174 reads
2015-02-16
90 reads
Fine Products for the Modern Drudge
As working hours in tech trend upwards, we look at some ways to make life easier.
2014-10-13
144 reads
The Broad View
An ingenuous use of existing data leads to the thought - when are we so deep in our work that we can't see how to improve?
2014-08-18
65 reads
Running With The Red Queen
Trying to take the time to fix sub-par processes has some surprising parallels in nature.
2014-04-28
183 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
Adding new column with DEFAULT
Comments posted to this topic are about the item Adding new column with DEFAULT
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
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