Low Hanging Fruit
An open letter asks Google to change their default protocol to be more secure. Are there things that we might want to do inside SQL Server to make it more secure by default? Any low hanging fruit that would help the platform?
Virtualization and Preparation
The DBA news of the week contains some interesting thoughts on DR and virtualization plans. Steve Jones comments on why you should care about these topics.
Characters
No, I’m not talking about a Dickens novel. I’m talking about the number of characters in a string. I had a painful time recently because of the word “characters.”
Low Hanging Fruit
An open letter asks Google to change their default protocol to be more secure. Are there things that we might want to do inside SQL Server to make it more secure by default? Any low hanging fruit that would help the platform?
Low Hanging Fruit
An open letter asks Google to change their default protocol to be more secure. Are there things that we might want to do inside SQL Server to make it more secure by default? Any low hanging fruit that would help the platform?
Low Hanging Fruit
An open letter asks Google to change their default protocol to be more secure. Are there things that we might want to do inside SQL Server to make it more secure by default? Any low hanging fruit that would help the platform?
The Query Optimizer: Date Correlation Optimisation
In SQL Server 2005, a feature was introduced that was hardly noticed, but which might make a great difference to anyone doing queries involving temporal data. For anyone doing Data Warehousing, timetabling, or time-based pricing, this could speed up your queries considerably. Who better to introduce this than Query Optimizer expert, Fabiano Amorim?
Troubleshooting Reporting Services
Marcin Policht continues his discussion of implementing Reporting Services on SQL Server 2005 Express Edition. In this article, we will turn our attention to troubleshooting methods that can be employed to identify and resolve problems affecting reporting functionality and performance.
The Value of Experience
What type of previous experience makes a good DBA? Is it necessary to have other experience? Steve Jones asks the question in today's Friday poll.
Understanding INNER join in detail
This objective of the article is to give readers in depth understanding of INNER JOIN with different joining conditions.
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