Emailing Disk Space Alerting With Powershell
A DBA doesn’t want to run out of space on their servers, even in their labs! To avoid this happening...
2014-11-04
4,916 reads
#Summit14 Embarcadero Book Signing
The blessings continue as Embarcadero offered to support my new book by hosting a book signing and providing 100 copies...
2014-11-04
1,058 reads
Cardinality Estimation in SQL Server
Each time you view a seek/scan operator in an execution plan, you may have noticed that there’s a value for...
2014-11-04
1,295 reads
PASS Summit 2014 Diary – Day 1
Today is the first day of official activities for the week. The PASS Summit hasn’t yet started, but I’ll be...
2014-11-03
769 reads
5 things to know about Databricks
Databricks is now available in both AWS and Azure so it’s getting a lot of buzz! Let’s discuss 5 things you should know about Databricks before diving in. 1. ...
2014-11-03
30 reads
What is a data warehouse and why do I need one?
While the data warehouse isn’t a new concept, many are left wondering – what is a data warehouse? And why do I need one? I’m sad to tell you...
2014-11-03
15 reads
Implementing Tabular Data Models: Microsoft Virtual Academy
Implementing Tabular Data Models
Date: November 11, 2014
Time: 9am?5pm PST
Where: Live, online virtual classroom:
http://www.microsoftvirtualacademy.com/liveevents/implementing-tabular-data-models
Cost: Free!
Register today! (linkto: http://www.microsoftvirtualacademy.com/liveevents/implementing-tabular-data-models)
What will you do...
2014-11-03
2,001 reads
Last Weeks Top “Reading” Links #107
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-03
465 reads
Setting Expectations–T-SQL Testing
I don’t know who started this pattern, as I’ve seen it in a few places. It could have been Sebastian...
2014-11-03
883 reads
SQL Server Database Mirroring Monitoring
SQL Server Database Mirroring keeps running all time to sync data between Principle & Mirror database. We need regular monitoring of Database Mirroring to ensure that everything is working...
2014-11-03
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