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.
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.
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.
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.
A day of free training near Washington DC in December. Come and learn how more about SQL Server.
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.
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.
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?
This article covers multipath operations that require a different hierarchical logic than SQL naturally produced hierarchical processing. These include nonlinear data ordering, the renormalization of data to remove replicated data, and the processing of network structures.
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Comments posted to this topic are about the item We Are Eating Our Own...
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers