The IT Employee Benchmark
What's important in an IT employee? Steve Jones talks about the skills and measurements CIOs want today and tomorrow.
T-SQL Function to Determine Holidays in SQL Server
While working on a project recently I was asked to develop a mechanism that would provide the dates for state and federal holidays in a given year. Since this project deals with all states and territories of the United States, the list had to be comprehensive and the client asked that this list be in the form of a SQL query calculated on-the-fly, rather than a static list.
Going Naked
Steve Jones talks about the value of software maintenance and how you should view their value.
Going Naked
Steve Jones talks about the value of software maintenance and how you should view their value.
Going Naked
Steve Jones talks about the value of software maintenance and how you should view their value.
Bookmark Lookups
Building high performance applications with SQL Server can be a challenge if you do not understand how the query processor works and how the server uses indexes. SQL Server expert Randy Dyess brings a look at how bookmark lookups are used when satisfying a query and how this can impact the performance of your query.
Return Query Text Along With sp_who2 Using SQL 2000
This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".
Soft Skills
A guest Friday poll from Adam Angelini, DBA and member of the band Wakamojo, which was featured on some editorial podcasts. This week Adam wonders about soft skills for DBAs.
Avoid Untrusted Constraints in SQL Server
Some time ago, I loaded a large set of data into one my tables. To speed up the load, I disabled the FOREIGN KEY and CHECK constraints on the table and then re-enabled them after the load was complete. I am now finding that some of the loaded data was referentially invalid. What happened?
Migrating from Business Objects Crystal Reports to SQL Server 2005 Reporting Services
This document assists Crystal Report designers with migrating to Microsoft SQL Server 2005 Reporting Services using a step-by-step migration strategy.
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 Kelapa Gading Hub.0813•7887•595
BCA KCP Kelapa Gading Hub.0813•7887•595.Jl, Jl. Boulevard Raya Blok FX No.9-10, Klp. Gading Tim.,...
BCA KCP Cempaka Putih TLP/WA 0821•697•7749
Jl. Letjen Suprapto No.30 EF, Harapan Mulya, Kec. Kemayoran, Kota Jakarta Pusat, Daerah Khusus...
BCA KCP WTC Mangga Dua Hub.0813•7887•595
BCA KCP WTC Mangga Dua Hub.0813•7887•595.Gedung WTC Mangga Dua Lantai Ground Lobby Selatan dan...
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