SQL Job Ownership Article on SSC.Com
Today, Please see my featured article appearing on SQLServerCentral.com discussing SQL Agent Job Ownership.
Have you ever had a situation...
2009-11-19
624 reads
Today, Please see my featured article appearing on SQLServerCentral.com discussing SQL Agent Job Ownership.
Have you ever had a situation...
2009-11-19
624 reads
It seems that the ownership of jobs is something that is often overlooked when articles explain
2009-11-19
8,997 reads
DB Audit Challenge #1
And the Winner is….
First, I want to thank everyone that participated in the DB Audit Challenge, and...
2009-11-10
807 reads
Well it certainly has been a busy and exciting week at PASS. I couldn't go this year, but through the...
2009-11-05
517 reads
In the spirit of my Who DID IT and RAN SQL Caper presentation.....
OK, I was hoping to get the creative juices...
2009-11-03
738 reads
Hey, just caught wind of some timely stuff going on at PASS. Had my trusty 'Google alert' email me, set...
2009-11-03
804 reads
Take the DB Audit Challenge - Intermediate - DB Audit Challenge #1
For those of you who have been following my recent blogs,...
2009-11-01
1,189 reads
Well, it's a wrap! Saturday has come and gone, but memories will go on. It was great to see so...
2009-10-26
746 reads
UPDATE: I just finished up my presentation slides for this upcoming NY/NJ SQL User Group meeting, on Saturday, 10/24/2009. I may cut...
2009-10-21
932 reads
Hi, all;
The countdown to the NY/NJ SQL Saturday event this upcoming Saturday has begun. And it's NOT TOO LATE to...
2009-10-20
543 reads
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Hi we run 2019 ssas std. Yesterday i imported my tabular project to vs...
Code for mssql 2008 DECLARE @CompanyID TINYINT DECLARE @MemNo decimal DECLARE @MemberFrom Integer DECLARE...
I have an execute task(has server list from a table) pointing to foraeachloop foreachloop...
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex] FILE = N'thirdone' , FILE = N'thirdtwo' , FILEGROUP = N'second' TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GOSee possible answers