What do you do as a DBA if you get asked to cook the books? With the economy doing poorly, some executives will be tempted to mis-report earnings and they might ask the technical people to help. Steve Jones has a few thoughts.
2009-09-03
668 reads
We sometimes find ourselves in situations that we didn't count on. Or that aren't necessarily a mistake we made in the installation. Steve Jones reminds us that we should keep that in mind when someone is asking for our help.
2009-09-01
109 reads
Perhaps we need to protect more data, according to Steve Jones. With the ability to identify most people with 10 digits of information, Steve Jones asks you to really think about what you need to store.
2009-08-31
679 reads
This Friday's poll looks at security and password changes. What interval do you think is appropriate and why? Steve Jones asks and gives you a few thoughts on his own experiences.
2009-08-28
674 reads
Someone asked Steve Jones about finding a mentor to become a better DBA. He shares some thoughts and advice about how to do this.
2009-08-27
654 reads
SQL Server is so large and complex that it's like an operating system. In fact, there the core engine is often referred to as the "SQL OS" by Microsoft developers. Steve Jones would like to see SQL Server as it's own OS at some point.
2009-08-26
483 reads
Posting online is a way of building your own brand, but you need to be careful of overselling yourself. Steve Jones talks about being careful in the impressions you create from your online presence.
2009-08-25
586 reads
SQL Server doesn't support two factor authentication, but Steve Jones thinks it might be a good idea. Perhaps it's something that will get implemented in the next version, and might even serve to better secure the platform.
2009-08-24
567 reads
For the Friday Poll this week, Steve Jones is wondering what type of data protection you use at home for your information. Especially those all important family photos.
2009-08-21
581 reads
There are new types of databases being deployed in the world. Steve Jones says that DBAs need to be aware of the changing technologies.
2009-08-20
438 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