MongoDB : Point in Time Restore/Recovery of MongoDB
This post demonstrates the methods of PIT recovery of the database. The step by step details of the recovery process...
2016-05-17
2,049 reads
Konferenzen im SQL Server Sommer 2016 – Conferences in SQL Server summer 2016
(DE)
Kaum von den SQLBits XV in Liverpool zurück, auf der ich die Security-Features des SQL Server 2016 vorstellen durfte...
2016-05-17
755 reads
Catching Up on The #SQLPASS Virtual Chapters
(Didn't realize until I was posting that this was my 100th post...whew!)
--
A few months ago we purchased a new "smart"...
2016-05-17
905 reads
MDW Data Collector – Collection Set jobs not working
ERROR :
Error Message 1 :
Executed as user: Domain\UserName. SSIS error. Component name: DFT – Upload collection snapshot, Code: -1071636372, Subcomponent: RFS...
2016-05-17
973 reads
10 SQL Server Data Warehouse Design Best Practices to Follow (Part 1 )
This past Saturday I had the pleasure of speaking at SQL Saturday #552 here in beautiful Jacksonville, Florida. My good...
2016-05-24 (first published: 2016-05-16)
6,899 reads
Query Store, Forced Plans, and New Plans
I love questions. I recently received one about new plans in the Query Store (available in Azure SQL Database now and in...
2016-05-23 (first published: 2016-05-16)
2,733 reads
RAID your backups
Let’s start with a very brief definition of some RAID levels.
RAID 0 : Stripe your data across multiple disks. Writing a...
2016-05-24 (first published: 2016-05-16)
1,497 reads
Continual Deployment of Visual Studio SqlProj
Unveil the inner workings of the esoteric build system...
As a data professional, I've never worked extensively with msbuild or other...
2016-05-16
3,256 reads
DBA Database scripts are on Github
It started with a tweet from Dusty
The second session I presented at the fantastic PowerShell Conference Europe was about using the...
2016-05-16
825 reads
SQL Server – Change in Identity() Property during transactions
Recently while working on a scenario I found that in case of transaction if you are doing insertion operation on...
2016-05-16
566 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