Parse Dynamics AX Context Info
Dynamics AX and SQL Server
More and more I am seeing clients requiring assistance with the Microsoft Dynamics Suite. Each of...
2017-01-30
2,077 reads
SQL RNNR
Parse Dynamics AX Context Info
In this article I will only be discussing the AX product and an easy tweak to make troubleshooting that product much easier from the perspective of the database administrator....
2017-01-30
17 reads
User Contains Invalid Characters – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-12-24
1,914 reads
User Contains Invalid Characters – Back to Basics
While creating database users, it is possible to encounter an invalid character error message. This article will help clarify the error message.
Related Posts:
Changing Default Logs Directory - Back...
2016-12-24
231 reads
What Agent Job is Running – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2017-01-02 (first published: 2016-12-23)
2,076 reads
What Agent Job is Running – Back to Basics
It is quite common to be required to investigate performance issues on the server. With this, it is occasionally necessary to be able to interpret an obfuscated job name....
2016-12-23
30 reads
Database Backups – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-12-22
681 reads
Database Backups – Back to Basics
In this article, we will explore database backups. More specifically, how do you truly know if you have a successful backup? Here's a hint: it has to deal with...
2016-12-22
3 reads
Database Backup History – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-12-20
555 reads
Database Backup History – Back to Basics
In this article I explore the basic of querying backup history data as a foundation to reporting on essentials such as storage and job management.
Related Posts:
The Mystery of Missing...
2016-12-20
20 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
sp_prepare and sp_execute vs sp_executesql
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
Find Invalid Objects in SQL Server
Comments posted to this topic are about the item Find Invalid Objects in SQL...
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