Guides

DPM 2016 Backup Error SQL Express databases ur4

DPM 2016 Error backing up SQL Express databases on server after ur4. When you add the database to the Protection group you get error: DPM could not enumerate application component SERVERNAME\MICROSOFT##SSEE\master on protected computer SERVERNAME (ID: 964) Scenraio After updating our DPM 2016 Server with ur4 there is an issue with MS ADFS 2.0 servers …

DPM 2016 Backup Error SQL Express databases ur4 Read More »

Convert Datetimeoffset to DateTime in SQL Server

Datetimeoffset to DateTime Convert issue in SQL Server 2016 Database. You are facing issue in one conversion, which is working fine in 2008 DB but not in 2016 DB. Select Convert(DateTime,created_ts,20) From Table Where, created_ts Type is DateTimeOffset. Its throwing error in 2016, as “The style 20 is not supported for conversions from datetimeoffset to datetime.” Please see …

Convert Datetimeoffset to DateTime in SQL Server Read More »

SQL: How to get previous and current month records?

SQL Server – Database Design. How to return the current month first date and the previous month first date between values, but its gives us the different values. You can do like this: f.StartDateKey >= DATEADD(mm,DATEDIFF(mm,0,GETDATE())-1,0) and f.StartDateKey < DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0) Another way is this (if on SQL 2012 and above) f.StartDateKey >= DATEADD(dd,1,EOMONTH(GETDATE(),-2)) and f.StartDateKey …

SQL: How to get previous and current month records? Read More »

What’s the future of Win32 and UWP?

For those who aren’t familiar, Win32 applications are your traditional desktop programs. They are typically installed via a downloaded installer, can be run directly from their .exe files and are located in the Program Files folder of every Windows computer.  UWPs, on the other hand, are essentially glorified mobile apps as part of Microsoft’s last-ditch …

What’s the future of Win32 and UWP? Read More »