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
628 reads
Robert Pearl
Let's Talk Ownership (and SQL Jobs)
It seems that the ownership of jobs is something that is often overlooked when articles explain
2009-11-19
9,028 reads
And the Winner is........
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
814 reads
Thoughts on a PASSing Scene...
Well it certainly has been a busy and exciting week at PASS. I couldn't go this year, but through the...
2009-11-05
521 reads
DB Audit Challenge #1 - Part II - Get a Clue
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
742 reads
Reference to PASS Session - T-LOG
Hey, just caught wind of some timely stuff going on at PASS. Had my trusty 'Google alert' email me, set...
2009-11-03
810 reads
DB Audit Challenge #1
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,192 reads
SQLSaturday Sensation in NJ
Well, it's a wrap! Saturday has come and gone, but memories will go on. It was great to see so...
2009-10-26
752 reads
Who did IT and Ran - The title of my upcoming presentation...
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
938 reads
It's NOT TOO LATE to Register....NY/NJ SQLSaturday Event 10.24.09
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
547 reads
Blogs
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers