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
29 reads
Blog Posts
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,146 reads
Transaction log shipping in SQL Server on Linux
SQL Server on Linux has been out for a bit now and I’ve played around a little (see here) but...
2017-01-30 (first published: 2017-01-25)
2,140 reads
Warning: Not a valid checkpoint file name
One of the other DBAs I work with noticed a warning message that was flooding the log files on one...
2017-01-30
1,898 reads
How to compare two SSAS databases with a custom MDX query
[2017-Jan-29] It came as a request from one of my customers where I had worked as a consultant to quickly compare...
2017-01-29
2,789 reads
SQL and the other technologies
Next table shows how SQL stands with the other technologies. The data is taken from StackOverflow.Data charted looks like in the...
2017-01-28
456 reads
Worth Reading – Something I learned while unemployed by Rod Falanga
SQLServerCentral recently published Something I learned while unemployed. Written by Rod Falanga, it has lessons worth learning about making time to...
2017-01-28
833 reads
CloudProPT – The New Cloud/Azure Community in Portugal
I am so happy to share the news that as of today, the new community CloudProPT (as in Cloud for...
2017-01-27
463 reads
Data Channel - Interview 03 - Hamish Watson on DevOps and Azure
Dear All,
After a short break, we are back with the 3rd interview on #DataChannel. Mr.Hamish Watson, Community Lead from Christchurch,...
2017-01-27 (first published: 2017-01-18)
1,076 reads
Finding Sysadmins with dba tools–GetDbaRoleMember
I’ve been wandering through the dbatools set of cmdlets, trying to see where various cmdlets are useful, and also practicing...
2017-01-27
520 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCP Rembang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
Layanan BCA KCP Blora Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
Question of the Day
Adding Bits I
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers