Is Unit Testing Important?
Testing our applications is important, but at what level do we need to test? Steve Jones talks about unit testing today, and wonders if this is prevalent for SQL Server developers.
Writing Custom Rules for FxCop
FxCop is a useful tool for analyzing code to highlight potential issues and deviations from best practise. To fully utilize to power of FxCop, custom rules can be added to the inbuilt rules that ship with FxCop.
#SQLPASS on Twitter
With the PASS Summit taking place last week in Seattle, Steve Jones found that there was a tremendous amount of SQL Server news and information on Twitter. It's a medium that is becoming useful for SQL DBAs.
A Bad Litmus Test
A litmus test is a way of determining your answer to a question based on a single issue or response. Steve Jones sees this as a bad idea, especially when looking to hire technical people.
An Un-indexed Foreign Key Gotcha
Indexing is important for improving performance, but do you know that a lack of indexes might actually cause things to stop working? Alok Dwivedi brings us a very interesting scenario where the lack of an index causes a problem with concurrency.
A Bad Litmus Test
A litmus test is a way of determining your answer to a question based on a single issue or response. Steve Jones sees this as a bad idea, especially when looking to hire technical people.
A Bad Litmus Test
A litmus test is a way of determining your answer to a question based on a single issue or response. Steve Jones sees this as a bad idea, especially when looking to hire technical people.
A Bad Litmus Test
A litmus test is a way of determining your answer to a question based on a single issue or response. Steve Jones sees this as a bad idea, especially when looking to hire technical people.
What a Data Warehouse is Not
Recently, I was at a conference, and I heard the following discussion about what a data warehouse was. One person suggested that a data warehouse was really all the old legacy systems connected by software that could access the data. By calling such a contraption a data warehouse, the organization could avoid having to do the hard and complex work of integration. There are so many problems with this federated approach to a data warehouse that they are almost not worth repeating here. But (once again!) here goes.
Introduction to the Transaction Log
The transaction log is a fairly complex construct in SQL Server and present in every database installation. New author James Rea brings us a great introduction to how the log works and how to maintain it.
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 Rajawali No.Telp:087757645171
Whatsapp:087757645171 Jl. Rajawali 53 G, Krembangan Sel., Kec. Krembangan, Surabaya, Jawa Timur 60175
BCA KCP Kas City Resort Hub.0813•7887•595
BCA KCP Kas City Resort Hub.0813•7887•595.Komp, Jl. City Resort Residence Boulevard Ruko Miami, Jl....
BCA KCP Mangga Besar VIII Telp:cs.(0821)8171955
Whatsapp:08218171955 Jl. Mangga Besar VIII, BB CC No.11, Daerah Khusus Ibukota Jakarta 11150
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