Comparing an inner join vs a subquery
I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing...
2013-05-08 (first published: 2013-05-03)
5,930 reads
The Activity Monitor is unable to execute queries against the server !
I’m generally not a great fan of Activity Monitor which is built in with SSMS,however today I wanted to check...
2013-05-02
3,449 reads
Want me to do a presentation?
I greatly enjoy doing presentations on a variety of topics, such as Business Intelligence, SQL Server, and personal development. If you...
2013-05-02
718 reads
PASS Virtual Chapter Events : May 2013
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...
2013-05-02
688 reads
Fix Page Checksum
A checksum value is tagged with every data page in SQL Server. This is used to detect issues on the storage system to ensure what has been read from...
2013-05-02
14 reads
Fix Page Checksum
A checksum value is tagged with every data page in SQL Server. This is used to detect issues on the...
2013-05-02
1,934 reads
PowerSQL - List SQL Server instance configuration details and sending an automated email
Reblogged from Prashanth Jayaram :
This article walks through how to list SQL Server configurable and non-configurable instance settings using PowerShell...
2013-05-01
2,927 reads
PASS SQL Saturday Events : May 2013
PASS SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in...
2013-05-01
550 reads
Calculating the next beginning of month and the current end of month
Handling dates is always a fun challenge in T-SQL! Finding the current end of month and next months beginning of...
2013-05-01
2,237 reads
Well I finally passed the 70-451
So I am now an MCITP Database Developer for SQL 2008. This is a big milestone for me. A few...
2013-05-01
813 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