PASS Summit 2014 – It’s not you, it’s me
After an exciting week at the PASS Summit, I’m back home with my family. This was my first ever PASS...
2014-11-11
612 reads
Consuming the Output of an SSIS Package in a Client Application
Typically, making the output of an SSIS Package available to a client application for further processing is achieved by outputting...
2014-11-11
4,849 reads
#tsql2sday #60 – Something New Learned – Problem Step Recorder
What is T-SQL Tuesday?
T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party...
2014-11-11
2,418 reads
Summit 2014
It’s hard to believe it’s over. It felt like a whirlwind while I was in Seattle for my 7th PASS...
2014-11-10
472 reads
How explicitly insert default value ? TIP #72
Suppose, sometimes you just need entry in the table with all the default values.
For example you have a Student...
2014-11-10
217 reads
#SQLPASS #Summit14 Day 2 Keynote Highlights !
This was one of those days I was waiting to happen. You might be wondering whats special? Yes, this day...
2014-11-10
857 reads
Let’s get started
Just back from PASS Summit 2014 and I am feeling inspired about stepping it up a notch and starting to...
2014-11-10
485 reads
Last Weeks Top “Reading” Links #108
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-11-10
340 reads
Expected Variables–T-SQL Testing
After I wrote about creating tables that contain the results I expected, I wondered if I could do the same...
2014-11-10
737 reads
Add Witness to Existing SQL Server Database Mirroring
1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option. 2. Click Configure Security, Configure Database Mirroring Security...
2014-11-10
19 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