Learning Extended Events in 60 Days
Want to Learn Extended Events over the course of your lunch break for a couple of months? This is the Table of Contents for learning Extended Events over the...
2015-09-08
60 reads
Learning Extended Events in 60 Days
This post will serve as the landing page for a series I am calling 60 Days of Extended Events. The...
2015-09-08
771 reads
TSQL2SDAY #70: Strategies for managing an enterprise
Thanks to MidnightDBA (b/t) for hosting this month’s #tsql2sday.
Strategies for managing an enterprise.
What do you think of when you...
2015-09-17 (first published: 2015-09-08)
1,066 reads
T-SQL Tuesday #70 – The Enterprise
It’s hard to believe this is the 70th edition of T-SQL Tuesday. I haven’t missed many, and I’ve enjoyed them...
2015-09-16 (first published: 2015-09-08)
1,311 reads
Unusual errors with Distributed Replay
I’ve come to really like Distributed Replay in the last couple of years. I’ve used it to do a scale...
2015-09-08
1,173 reads
High Availability and Disaster Recovery Training in Dallas
I’ll be doing a precon for SQLSaturday #447 in my home town of Dallas on October 2nd, 2015 titled “Creating a High...
2015-09-17 (first published: 2015-09-08)
1,052 reads
Building Better SSIS Packages Class in Dallas
I’m happy to announce a new, full-day class in the Dallas area next month. I’ll be presenting my Building Better...
2015-09-15 (first published: 2015-09-08)
1,614 reads
Extended Events Objects
Today I want to start diving into some of this data a little deeper as we progress some of the of the core concepts surrounding Extended Events.
Related Posts:
Correlate SQL...
2015-09-08
8 reads
Extended Events Objects
So far, I have talked about some of the metadata associated with Extended Events. But I have not yet started...
2015-09-15 (first published: 2015-09-08)
1,923 reads
Where you should start when managing an enterprise
This T-SQL Tuesday we are hosted by one of the DBA’s of the night: Jen McCown (b/t). She want’s us...
2015-09-11 (first published: 2015-09-08)
1,864 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