Hiring a new employee can be a hit or miss proposition. We often don't learn much about how someone will work from an interview. Steve Jones talks about an alternative way to hire someone by taking them for a test drive.
2009-08-19
511 reads
Networking is one of those things that so many people say is good for your career? But why? Steve Jones has a few examples today from his own experience.
2009-08-17
653 reads
Sharing how you do your job can help others be better at theirs. This Friday's poll asks a technical question. How do you determine which fillfactor to use.
2009-08-14
471 reads
Join Steve Jones and a few of the SQLServerCentral community in Las Vegas this fall at the SQL Connections conference.
2009-08-13
643 reads
There can be a lot more value when pieces of data are put together than when they exist separately. Steve Jones comments on a few ways people are repackaging information in the modern world.
2009-08-12
80 reads
This Friday's poll asks you about having a fair set of benefits for extra time work. Steve Jones wants to know how your employer treats you.
2009-08-07
600 reads
Many businesses have loyalty programs to encourage repeat business. However do they think about data security when they build these programs? Steve Jones thinks they could do better.
2009-08-06
482 reads
What's your stolen data worth? It might be worth investigating, as Steve Jones suggests. Then you'll know how much you should be spending to protect it.
2009-08-05
616 reads
Is it better to build an API into your code and allow someone to "plug in" or provide them with source code? Steve Jones thinks the former is better and gives you a few reasons why.
2009-08-04
485 reads
Is software engineering dead? Some well respected software developers have stated that, and one says we should be craftsman, not engineers.
2009-08-03
788 reads
How I used AI for this postChatGPT to generate images based on info specifically...
By ReviewMyDB
My T-SQL Tuesday #202 entry for Marlon Ribunal's invitation on memorable SQL Server outages....
A RAG pipeline that answers questions in the demo is not the same thing...
Hello everyone, Last week we performed an upgrade of our SQL Server instance, moving...
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...
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