Relational databases vs Non-relational databases
I see a lot of confusion about the place and purpose of the many new database solutions (“NoSQL databases”) compared...
2015-08-27
1,536 reads
Blog Posts
SQLSat403 – Recap
The doors close, lights turn off, and cars begin to pull out of the parking lot. Another SQL Saturday event...
2015-08-27
359 reads
SQLSat403 – Recap
The doors close, lights turn off, and cars begin to pull out of the parking lot. Another SQL Saturday event...
2015-08-27
630 reads
Studying for the 70-462 Exam: Database Mirroring
If we could take a picture of the HA solutions currently offered in SQL Server, database mirroring would be the...
2015-08-27 (first published: 2015-08-18)
2,407 reads
Using Power BI with HDInsight Part 1: Power Query and Files
With the rise of HDInsight and other Hadoop based tools, it is valuable to understand how Power BI can help...
2015-08-27
714 reads
Adding a VLDB database to an SQL Server Availability Group
Recently, I was tasked with making an 60TB database highly available by adding it to an availability group. The following,...
2015-08-26 (first published: 2015-08-18)
2,105 reads
Agile Development – A DBA’s Initial Thoughts
I recently had the opportunity to attend a three day Agile development workshop. At a very high level, Agile development...
2015-08-26
632 reads
Critical Virtualized Database Education at VMworld
If you are one of the lucky ones who gets to attend VMworld USA this year, and you have any...
2015-08-26
634 reads
Nesting Aggregates with Window Functions
Recenty I was writing an article for MSSQLTips where I had to create a treemap (it will be published soon)....
2015-08-26 (first published: 2015-08-18)
2,627 reads
Shredding XML in XEvents
One of the biggest pains with Extended Events is the thing we love to hate - XML. XML is so foreign to many DBAs. It's not relational and often...
2015-08-26
19 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
Alamat BCA KCP Modernland Telp:0821°7555°651
Telp/Wa 628217555651 Ruko Modern Walk, Jl. Hartono Raya No.063 MW No. 062, RT.001/RW.006, Klp....
Alamat BCA KCP Cikande Telp:0821°8200°203
Telp/Wa 628218200203 Kawasan Industri Modern Cikande, Komp. Ruko, Jl. Raya Jkt No.Km. 68 Blok...
Alamat BCA KCU SERANG Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Pangeran Diponegoro No.14, Kotabaru, Kec. Serang, Kota Serang, Banten 42112
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers