DBA VC Presentation May 11
Come one, come all!! Oh wait, it’s too late now. I just finished giving my presentation to the DBA VC (virtual chapter). There was good attendance and there were...
2011-05-11
5 reads
Blog Posts
DBA VC Presentation May 11
Come one, come all!! Oh wait, it’s too late now. I just finished giving my presentation to the DBA VC...
2011-05-11
668 reads
Dealing with Frustration in the Workplace
Inevitably, even if we work for ourselves, we get frustrated with our workplace. This is true of all aspects of...
2011-05-11
3,036 reads
Dirty looking SQL or MDX? Clean it up
A quick tip for you: Ever get some SQL or MDX sent to you in an email, or copied from a...
2011-05-11
680 reads
Help Pick the 2011 Summit Topics and Speakers
Here’s your chance to give the program committee your thoughts on which sessions should be selected for the big show....
2011-05-11
558 reads
Looking for FREE SSAS training?
SSWUG.org is hosting a free SQL Server Analysis Services expo on May 20, 2011. Register today to reserve your spot.
If...
2011-05-11
817 reads
Networking and Connections
This quote says it all:
It’s from an article on the 9/11 memorial and how an algorithm was used to inscribe...
2011-05-11
752 reads
PASS Summit 2011 Session Preference Survey
PASS has added a new feature to the session selection process for the PASS Summit 2011, which they are calling...
2011-05-11
608 reads
PASS Summit Session Selection is Open
This year the Program Committee decided to open up the selection process to the community. I'm anxious to see how...
2011-05-11
863 reads
Patch Week
My email account started getting notices of Windows patches yesterday, indicating it’s patch week again. If you manage Windows devices,...
2011-05-11
899 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
Alamat BCA KCP Cilandak KKO I Telp/Wa:0821-8200-233
Telp/Wa 62 821-8200-233 Jl. Raya Cilandak KKO No.9, RT.1/RW.5, Ragunan, Ps. Minggu, Kota Jakarta...
Alamat BCA KCP Arkadia Telp/Wa:0821-8200-203
Telp/Wa 62 821-8200-203 Gedung Perkantoran Hijau Arkadia, Tower C - Ground Floor, unit C103,...
BCA KCU KUNINGAN Telp/Wa:0821-8200-174
Telp/Wa 62 821-8200-174 Menara Karya, Jl. H. R. Rasuna Said Ground floor, RT.1/RW.2, Kuningan,...
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