Evil Code
/*
A couple
of years ago, I wrote the Simple-Talk Prettifier. This is really no more than a stored
procedure that...
2009-08-14
3,554 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
The Joy of Data Modelling.
You may think that the task of teasing out the exact nature
of the data and processes within a company...
2009-08-11
2,494 reads
There's a Lot to Learn From Even Simple Puzzles
Phil reflects on the problem-solving power of SQLServerCentral at its best, and mentions some of the impressive contributions to the Summer SQL Stumpers competition
2009-08-11
423 reads
Advice for the Unemployed
Everyone has an opinion on the best advice to give an IT person who is unemployed and wants to get back into paid work. Phil Factor outlines what he would advise.
2009-07-16
229 reads
Basically Available, Soft State, Eventually Consistent
The use of non-relational databases is a fascinating topic but they will remain special-purpose and are not competing with SQL-based relational databases.
2009-07-13
855 reads
Stress
Developers and DBAs both tend to lead stressful lives. Occasionally, things don't go to plan, and this stress can then build to pretty intolerable levels. Without adaptive methods of dealing with stress, things can go very wrong...
2009-07-02
278 reads
Documenting Database Code: Structured Headers
When you're doing any database development work, it won't be long before you need to seriously consider the documentation of your routines. Should we, as a community, propose a common standard for T-SQL headers, and the information that should go into them?
2009-06-30
486 reads
When the next object-persistence boat comes in.
Phil enjoys an old Microsoft Training manual and wonders why it is no longer possible to encompass the whole of SQL in a 400 page book any more..
2009-06-29
1,933 reads
The secret skill revealed in the dusty booklet
Going through one’s father’s belongings after his death is always a poignant, bitter-sweet experience. I was going through his most precious books a while back; there were books that were written by him, books by friends and relatives, books about friends...
2009-06-26
2,357 reads
When the next object-persistence boat comes in.
I was reading a MCP training manual for SQL Server the other day. It was good. The whole of TSQL...
2009-06-22
1,746 reads
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 KCU PURI INDAH,Telpon/Wa 0821-8200-239
Gedung C3 Lt. 1-3 Komplek, Jl. Puri Indah Raya No.1-3 Blok 02, Kec. Kembangan,...
BCA KCU CIKARANG Tlpn/wa:085373737551
Madison Square, Business Park Lippo Cikarang, Jl. MH. Thamrin No.163, Cibatu, Cikarang Selatan, Bekasi...
BCA KCU PANGERAN JAYAKARTA. Tlp:(+62) 8218168235
Jl. P Jayakarta Komp. No.127, Mangga Dua Sel., Kecamatan Sawah Besar, Kota Jakarta Pusat,...
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