SQL in the City Slides
I’m making the slides available from my SQL in the City 2012 talks. You can download them here
Prepare for...
2012-11-05
1,278 reads
Blog Posts
SQL Server – List of all the Error codes or messages
Question:
I want list of all error codes & messages of SQL server.
Answer:
Once some ask this thing to you or this though...
2012-11-05
34,207 reads
SQL Server Security: The Sum of Its Parts
When it comes to attacking SQL Server, whether we're talking about the security of an installation or as a piece...
2012-11-05
1,469 reads
SQL Street
I’m involved with with a new venture called sqlstreet.co.uk. SQL Street is the place to shop for database experts.
Here’s a...
2012-11-05
744 reads
Time Pass With Transaction Log - Part 1
Hundreds of expert level books, articles, videos and blogs has talked much about Transaction Logs and How well to manage it.
Everything from basics...
2012-11-05
1,930 reads
Countdown to PASS Summit 2012 – 2 to Go – I’m Presenting Again
I assume at this point some of you are already in Seattle and even getting ready to attend Preconference Sessions....
2012-11-04
645 reads
Countdown to PASS Summit 2012 – 3 to Go – Setting My Schedule
Three days to go. I need to get my schedule sorted out, how about you. What influences your schedule? Since...
2012-11-03
555 reads
SSIS C Sharp #115 – C# Script to detect delta
A reader asked me to share a C Sharp script I used in this post, SSIS #114 – How many ways...
2012-11-03
1,174 reads
Ask the Unicorn: Do I have to sing at SQL Karaoke?
The PASS Summit is coming up next week and that means that as the sun goes down, a number of...
2012-11-02
597 reads
Countdown to PASS Summit 2012 – 4 to Go – SQL Karaoke, Really?
Four days to the Summit. Will you be singing? Last year was my first time attending SQL Karaoke. While I...
2012-11-02
762 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