How to Connect to a SQL 2005 Server When You Are Completely Locked Out
If you need to connect to a SQL server and don't have the 'sa' password plus the builtin\administrators account has been removed then Rudy Panigas shows us what you need to know.
Max Memory
This Friday Steve Jones asks for who's got the best bragging rights. Let us know this Friday just much RAM is a lot.
The Modern Resume - Building Your Brand Online
A presentation by Steve Jones that gives practical tips for enhancing your online brand and making yourself stand out in the modern world.
Change Management and Source Control
So, given the many good reasons for using Version Control systems for managing the changes in database applications, how does one go about the rather different routines of team development, such as testing, continuous integration, and managing data? What are the issues that you're likely to face?
MCM – The Knowledge Exam
I recently took the knowledge exam, and I loved it. I thought it was a great exam. I have taken...
SQL Server Connections Discount Code
If you are thinking about attending SQL Server Connections (a part of DevConnections) in Orlando this March 27-30, take advantage...
SSRS Report Parts Versus Sub Reports FAQ
I'm trying to decide on a development strategy to satisfy the reporting needs in my organization. I would like to increase our efficiency in responding to report requests, while minimizing our maintenance burden. Two topics that I would like to dig in to are Report Parts and Subreports. Can you provide some considerations for using one versus the other?
DBA Concerns
A survey of Oracle DBAs shows them having a number of security concerns. Steve Jones thinks that a survey of SQL Server DBAs would be similar.
The EXCEPT and INTERSECT Operators in SQL Server
The UNION, EXCEPT and INTERSECT operators of SQL enable you to combine more than one SELECT statement to form a single result set. Rob Sheldon explains all, with plenty of examples.
Quality Over Timing
Is quality job one for software companies? Steve Jones asks what you think and comments on why quality might not be as high as we would like.
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 Muara Karang 2,Telpon/Wa 0821-8200-239
Jl. Pluit Karang Blok D-7-U. 211A Kav.1 & No. 211, Kav 2, Daerah Khusus...
BCA KCP Riau Tlpn/wa:085373737551
Jl. Laks Jl. L. L. R.E. Martadinata No.92, Cihapit, Kec. Bandung Wetan, Kota Bandung,...
BCA KCP Muara Karang 3,Telpon/Wa 0821-8200-239
Komplek Galeri Niaga Mediterania, Jl Jl. Pantai Indah Utara 2 Blok X.3 Kav.No.A8, Kapuk,...
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