This article will show you how you can execute a SQL job with one click, allowing anyone to do this. Author Divya Agrawal shows a technique to let other users run jobs that do things such as perform a backup with a batch file.
2009-06-05
22,554 reads
Compare feature sets for the two Microsoft SQL Server 2005 Mobile Edition 3.0 (SQL Server Mobile) connectivity solutions, merge replication and remote data access (RDA), and understand which connectivity solution might be more beneficial for your project.
2009-06-05
1,690 reads
It doesn’t happen often but every once in a while you may be the lucky person to find a previously unknown bug in SQL Server.
2009-06-05
4,014 reads
Put the stacked bar chart to work in your own business environment. BI Architect Bill Pearson continues his hands-on introduction to Reporting Services charts based upon Analysis Services data sources.
2009-06-05
2,178 reads
I'm happy to announce that SQLServerCentral is sponsoring a track at this year's SQL Connections conference in Las Vegas, Nov 9-12, 2009. We're supplying the speakers, and picking the topics. If all goes well, we should be continuing this...
2009-06-05
1,164 reads
Ensuring that you can recover your server is critical. Chad Miller shows us how to accomplish daily backup monitoring and reporting.
2009-06-04
16,113 reads
One of the problems you might run into when building applications that consume web services is how you can use web services data within a SQL Server instance. Greg Larsen discusses how to do this within a stored procedure that only runs within the context of SQL Server.
2009-06-04
5,276 reads
Separation of duties is an important consideration for databases and database applications. By properly defining schemas and roles, you can create a distinction between users who can manipulate data from those that administer the database. This paper discusses the topics of which application developers should be aware and provides a heuristic example to guide you in achieving separation of duties.
2009-06-04
1,633 reads
Whenever I do a security presentation, I make sure to cover the Principle of Least Privilege. And when I do I boil it down to this very simple definition: Giving the rights to do the job. No more. No less.
2009-06-04
1,912 reads
Birmingham (May 20), Pensacola (June 6), and Portland (June 6) are upcoming SQLSaturday events. If you are in the area, please attend.
2009-06-04 (first published: 2009-05-05)
1,524 reads
By Kevin3NF
Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...
By gbargsley
Whether you’re a seasoned DBA or just exploring database tools, DBeaver offers a powerful,...
DBAs should never run SSMS under their everyday Windows account If you open SSMS under...
Immediate need for a hands-on SQL Server DBA. This is a greenfield opportunity to...
Import-Module ImportExcel # Path to your .sql file $sqlFile = "C:\Data\MyQueries.sql" $excelPath = "C:\Data\SqlExtract_$(Get-Date...
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer
@customername varchar(200)
AS
BEGIN
DECLARE @added VARCHAR(100)
SELECT @added = xxx
IF @customername IS NOT NULL
INSERT dbo.Customer
(
CustomerName,
AddedBy
)
VALUES
(@customername, @added)
END See possible answers