Burnout
What happens when you burnout? Would you recognize when it happens? A guest editorial from Andy Warren talks about some of the signs and what you can do.
Run an SSIS Package Under a Different Account
In this article, learn how to use the SQL Server agent proxy to run an SSIS Package under whatever account you choose.
A High Level Comparison Between Oracle and SQL Server
Part I of the Oracle / SQL Server comparison looks at the various editions of each database and their structure.
Left outer join vs NOT EXISTS
And to wrap up the miniseries on IN, EXISTS and JOIN, a look at NOT EXISTS and LEFT OUTER JOIN...
Injecting Your Own Bias
Steve Jones talks about the controversy surrounding the PASS Survey and future Summit announcements. And about how we, as data professionals, might subtly bias clients.
A little restriction that prevent changing tables in SQL Server 2008
In SQL Server 2008, by default, the option to prevent tables changes is "on". We can have some issues and...
SQL Saturday #29 - Birmingham
A free one day training event from SQL Saturday and the Birmingham SQL Server groups. Come join us if you are in the area.
SQL Server - Introduction to Business Intelligence Development Studio
In his latest article, Marcin Policht demonstrates a variety of tools that can be employed to execute SQL Server Integration Services packages, focusing in particular on the method leveraging functionality available within the Business Intelligence Development Studio.
Expanding The Scope of Bridge Tables
Timothy Claason continues talking about database design in a new article. This one talks about expanding the functionality that Bridge Tables provide in your schema.
Microsoft SQL Server 2008 Integration Services Problem-Design-Solution - Sample Chapter
Learning about practical Integration Services is an important part of the well rounded DBA for the future. Read a sample chapter from this new book.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Plaza Merdeka Mas,??|wa Telp/Wa 0821.3111.159
Ruko Plaza Merdeka Mas, Jl. Raya Merdeka Blok A1-A2, RT.002/RW.002, Cimone Jaya, Kec. Karawaci,...
BCA KCU PANGERAN JAYAKARTA Tlpn/wa:085373737551
Tlpn/wa:085373737551 Jl. P Jayakarta Komp. No.127, Mangga Dua Sel., Kecamatan Sawah Besar, Kota Jakarta...
BCA KCP Kas Sepatan,Telp/Wa 0821.3111.159
Jl. Tangerang Golden City Jl. Raya Mauk No.3 Blok R1, Sepatan, Tangerang Regency, Banten...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers