Analyzing Product Growth with the Management Data Warehouse
This article presents a case study of using the Management Data Warehouse feature in SQL Server 2008 to analyze disk usage trends by product.
Ready for Inspection
Today we have a guest editorial from Andy Warren. Are you ready for an inspection at work? Are you really running your environment in a way that would make you proud? Andy has some thoughts about sticking to your policies and procedures.
TSQL Challenge 44 – Identify products that belong to each unique color
The first part of your job is to identify the unique color combinations of products and the second part is to identify the products that have the given color combination.
When a Dogma has had its' day
Phil points out that the SQL Server community has a role to play in making sure that the wisdom of SQL Server Pundits is regularly tested and challenged.
Custom sp_start_job to delay next task until SQL Agent Job has completed
The system stored procedure sp_start_job is a very useful T-SQL command that starts a SQL Agent job. The problem with this is that it starts the job and it doesn't wait until the job is finished and sometimes I want to start a job and wait until the job is finished and move on to another job or task that depends on the result of the previous job.
SQL Saturday #61 - DC
A day of free training near Washington DC in December. Come and learn how more about SQL Server.
An Example of Test-Driven Development, Part 5
The fifth installment of this fantastic series by MVP Andy Leonard looks at database versioning. Be sure to read this one to continue learning more about TDD.
Do You Talk Salary in the Interview?
This is a reprinted editorial from August 2, 2005. It is being republished as Steve is on vacation. Steve discusses the challenge of discussing salary in an interview.
Implicit Permissions Due to SQL Server Database Roles
I have audited for permissions on my databases because users seem to be accessing the tables, but I don't see permissions which give them such rights. I've gone through every Windows group that has access to my SQL Server and into the database, but with no success. How are the users accessing these tables?
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 Semut No.Telp 083831617937
Whatsapp.083831617937 Jl. Bongkaran No.17-19, Bongkaran, Kec. Pabean Cantian, Kota SBY, Jawa Timur Surabaya, Jawa...
BCA KCP Kota Bukit Indah No.Telp:087757645171
Whatsapp:087757645171 Kawasan, Jl. Kota Bukit Indah Raya Kav.A II/29 No.RK 5, Dangdeur, Kec. Bungursari,...
BCA KCP Arkadia No tlpon:083138717148
Whatsapp:083138717148.Jl. TB Simatupang No.Kav 88, Daerah Khusus Ibukota Jakarta 12520
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