What do Clocks, Cars, and Warships have in Common?

A few months ago we had Daylight Savings Time. My parents were delighted to discover that “the clock” in their car automatically adjusted itself, as did their computer. But now they had to change the two clocks in their bedroom, the two clocks in the kitchen, and several others around the house. How did the […]
Read More ›

Build Your Very Own Electron Cross-Platform Desktop App Using JavaScript

Cross-platform technologies are popular right now. Microsoft seems to be embracing non-Windows OSes—e.g. porting flagship projects such as .NET and SQL Server to Linux/macOS. Most of this activity is around server and mobile technologies. Windows still has a commanding share—89% in 2016)—of the desktop, with macOS on just under 10% of desktops in the same […]
Read More ›

Apply the Openrowset Function to Acquire Rowsets

In the previous blog on SQL Server’s OPENROWSET function we observed that while OPENROWSET is most often encountered in relation to linked servers, it is also valuable for directly reading flat files. It’s worth taking a moment to mention another less common application of OPENROWSET ( ). If you wanted to write code that returned […]
Read More ›

Missing Server Configuration Manager from SSRS Server

I had an interesting problem recently. I was doing some work for a client on a CRM deployment and a performance issue. Whilst onsite, I helped with a problem with SSRS and reports not displaying. Further investigation displayed an error that said SSRS was not using a valid execution account. The error was “The report […]
Read More ›

How to Manage the Flashback Data Archive

In this post, we will continue with the theme of Information Lifecycle Management (ILM). Through ILM, I will be discussing how to successfully manage the Flashback Data Archive. Maintaining the Flashback Data Archives To add space to an existing archive: ALTER FLASHBACK ARCHIVE two_year_archive ADD TABLESPACE archive_two QUOTA 2G; To change the retention time: ALTER FLASHBACK ARCHIVE two_year_archive […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.