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.
2010-11-29
3,405 reads
A day of free training near Washington DC in December. Come and learn how more about SQL Server.
2010-11-29 (first published: 2010-11-23)
1,920 reads
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.
2010-11-26 (first published: 2009-08-20)
10,351 reads
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?
2010-11-26
3,697 reads
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.
2010-11-25
2,295 reads
This article covers how to implement the SQL Server 2008 Execution Log DB and package on SQL Server 2008 R2
2010-11-24
4,645 reads
SQL Server 2008 R2 Data-Tier Applications make database development, deployment and management much easier. When you create and build a Data Tier Application, it creates a single, self-contained unit of deployment called a DAC package. Arshad Ali shows you how to deploy the created DAC package and discusses the different methods of deployment.
2010-11-24
2,616 reads
My client wants to standardize address information for existing and future addresses collected for their customers, particularly the street suffixes. The application used to enter and collect address information has the street suffix separated from the address field, but it is a textbox instead of a drop down list therefore things are not standardized. I know there are some options out there to standarize data, but they would like a less expensive alternative. Are there any functions in SQL Server that I can use to standardized data?
2010-11-23
5,296 reads
Recently when I created a SQL Server Agent job to execute a SSIS package, it failed with the message "Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account.". What is this exception about? What causes it and how do I resolve it?
2010-11-22
3,971 reads
Continuing on with his testing series for T-SQL code, MVP Andy Leonard looks at deployment here.
2010-11-19 (first published: 2009-07-15)
8,919 reads
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
WhatsApp:083831618816 Perum Bumi Cikarang Asri Blk. F5-F6, Ciantra, Cikarang Sel., Kabupaten Bekasi, Jawa Barat...
Jl. Dr. Saharjo No.149 G-H, Manggarai Sel., Kec. Tebet, Kota Jakarta Selatan, Daerah Khusus...
Jl. Raya Parung Gg. Kp. Jati Ruko Blok A-B, Parung, Kec. Parung, Kabupaten Bogor,...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers