PowerShell Usage In DBA Work — Case Study 1 / 7
I have been blogged non-technical topics for too long and it is time for me to return to my favourite...
2013-03-06
960 reads
DBA Philosophy
Where Should Database Administration Go?
For the past 5 or 6 years, we have seen lots of innovative products emerged, from smartphone to tablets, from...
2013-02-04
782 reads
DBA Work Accounting
One thing lots of DBA teams, esp. the DBA managers, feel uncomfortable is that it is difficult to quantify/log DBA’s...
2012-10-22
1,822 reads
Why I dislike Third Party Database Monitoring Tools
I have to admit I am not a fan of the various 3rd party monitoring tools (after using a few...
2012-09-17
1,890 reads
When Can You Be Considered As A Senior DBA
As a DBA, when can you consider yourself as a senior DBA?
If you read online posts, you will find most...
2012-08-27
3,449 reads
Improve DBA Operation Productivity – Part Two
As a DBA, we have to take various actions based on huge amount of information received. In one perspective, our...
2012-07-31
1,887 reads
Improve DBA Operation Productivity – Part One
I define DBA operation productivity as the total positive values brought to the work environment by a DBA in a...
2012-07-24
1,073 reads
Inspirational Database Administration Requirements
Just as a society’s civilization is mostly nurtured by its culture, I believe that DBA work quality is mostly determined...
2012-06-23
925 reads
“Green” Database Administration
For the past few years, I have seen tens of sql server boxes added in my work environment every year,...
2012-06-04
4,629 reads
Investment for DBA Career
As IT professionals, we all will consider and take actions, at some point of time, to “invest” in our careers....
2012-06-02
1,057 reads
Blogs
A New Word: Ecstatic Shock
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Forums
Find Invalid Objects in SQL Server
Comments posted to this topic are about the item Find Invalid Objects in SQL...
Email..dmtworld2@gmail.com..Buy MDMA Ecstasy Pills, Black Tar Heroin, Pink Cocai
Email..dmtworld2@gmail.com Telegram..@jemsscott237 Vaping DMT makes it considerably more advantageous when contrasted with really illuminating...
Question of the Day
Who am I?
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