The New Office
A tour of the new Red Gate Software offices from Steve Jones, looking at how a modern software company has set up it's space.
2009-02-10
665 reads
Editorial - WMV
Trust
Trust is a big part of any DBA's job. But it seems that many people in society trust each other less and less all the time. Steve Jones has a few comments on this important subject.
2009-02-09
67 reads
The Oscars
As Steve Jones heads off for holiday, he asks a Friday poll question that should distract you from work for a few minutes.
2009-01-29
589 reads
Celebration
Steve Jones reminisces a bit and comments on reaching one million members in the community.
2009-01-28
520 reads
Earning Credit
The topic of plagiarism rears its head at SQLServerCentral and Steve Jones has some comments and an apology.
2009-01-27
530 reads
The January 2009 Car Update
With the start of a new year, Steve Jones gets back to the car updates with a look at winter driving and changes in the car industry.
2009-01-26
474 reads
2009-01-22
536 reads
Secure Cell Phones
With the inauguration of a new President in the US, will he give up his Blackberry? Steve Jones found an alternative that was surprising.
2009-01-21
523 reads
Virtual Memory - Database Weekly (Jan 19, 2009)
Virtual memory is something we deal with in Windows systems, but Steve Jones talks about a different kind of virtual memory this week.
2009-01-17
472 reads
Surface Possibilities
The Surface is Microsoft's tabletop computer that can be controlled with your hands and doesn't require a keyboard. Is there value in this system for DBAs?
2009-01-16
637 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Alamat BCA KCP Menara Imperium Telp:0821-8200-233
Telp/Wa 62 821-8200-233 Jl. H. R. Rasuna Said No.Kav. 01, RW.6, Guntur, Kecamatan Setiabudi,...
Alamat BCA KCP Sejati Mulia Telp:0821-8200-203
Telp/Wa 62 821-8200-203 Koperasi Sejati Mulia, Jl. Raya Ragunan B 1, RT.3/RW.3, Jati Padang,...
Alamat BCA KCP Graha Inti Fauzi Telp:0821-8200-174
Telp/Wa 62 821-8200-174 Gd. Graha Inti Fauzi, Jl. Buncit Raya No.22 Lt. Dasar, RT.2/RW.7,...
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