Mistakes in April
Steve Jones has a blooper reel for today that shows some of the things that happen when shooting a daily podcast.
Comparison of Dates in SQL
This article discusses a common mistake while making date comparisons in T-SQL and its resolution. From new author Manish Sinha.
Setting Up Database Mail - SQL School Video
Learn how to get started integrating mail with your SQL Server in this SQL School video. MVP Andy Warren shows how to set up Database Mail.
The Best High Availability
Clustering is often the first choice for high availability, but is it the best choice? A lot of people think so, but Steve Jones has other thoughts.
Performance Testing SQL 2008’s Transparent Data Encryption
The focus of this article is to test the performance of SQL Server 2008's Transparent Data Encryption. How does it perform compared to a database without encryption? How does the mix of SELECT/INSERT/UPDATE affect the performance results?
Secure Storage
How do you keep the passwords and keys for encrypted data safe? Steve Jones comments on the challenges of working with keys and passwords.
Secure Storage
How do you keep the passwords and keys for encrypted data safe? Steve Jones comments on the challenges of working with keys and passwords.
Secure Storage
How do you keep the passwords and keys for encrypted data safe? Steve Jones comments on the challenges of working with keys and passwords.
Starting Conversations - Part 2
A week or so ago I posted a note about reading How to Start a Conversation and Make Friends (worth reading), and I had a comment posted to the blog by author Don Gabor. I like that kind of follow up, so I sent Don a note and a ...
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
ActualExecute
IT's OK I've create a stored procedure ActualExecute which is the TSQL script equivalet...
BCA KCU RAWAMANGUN Tlpn:CS.0853•5504•2311
BCA KCU RAWAMANGUN Tlpn:CS.0853•5504•2311 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta...
PT Central Santosa Finance. Tlp/wa:08218168235
Komplek Ruko Grand Mall, Jl. Sudirman (Kompeks Ruko Grand Mal, Jl. Jend. Sudirman Kompeks...
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