(Hannes Du Preez) The Windows 8 infrastructure is quite different than any earlier Windows version. This makes doing ordinary tasks quite cumbersome as: 1) you have to learn an entire different way of doing things, and 2) you have different tools at your disposal. By tools I mean classes in the Wind
Author: SSWUG Research
INTERVAL Partitioning
(Hemant K Chitale) A quick demo of INTERVAL Partitioning.
SQL SERVER – What Permissions I have on Database I am Connected to?
(Pinal Dave) Here is the first thing I do when I get access to any new server – I check what are different permissions I have with respect to the database I am connected with. The matter of the fact is that most of the database consultants and administrator want to know what are different permission
ASP.NET MVC Paging with OData
(Dino Esposito) It is natural for the user to want to browse through data within an application. Until recently, the interfaces with data sources have been ill-equipped to support this. OData, at last, takes the legwork away with some well-considered support for the paging of data, without imposing
SQL Server – Calculating elapsed time from DATETIME
(Vishal Gajjar) Elapsed time can be calculated from DATETIME field by extracting number of hours/minutes and seconds. You can use below query to calculate elapsed time between two dates:
SSIS For Loop Skip Files
(Mike Davis) When running a For Each Loop through a set of files, sometimes you will have specific files that you do not want to load.
Entity Data Modeling with Visual Studio
(James Serra) While there are a lot of tools out there for data modeling, there is one option that is free if you have Visual Studio. It’s called the Entity Data Model Designer. It works well if you need a quick-and-dirty way to create a logical model of tables and have the DDL automatically creat
Running PL/SQL Procedures in Parallel
(Brendan Tierney) As your data volumes increase, particularly as you evolve into the big data world, you will be start to see that your Oracle Data Mining scoring functions will start to take longer and longer. To apply an Oracle Data Mining model to new data is a very quick process.
Another one on ‘Oracle Type inheritance and advanced type casting’
(Martien van den Akker) Already four and a half year ago I wrote an article on Oracle Type inheritance and type casting. See here. But although Object types are supported by Oracle since Oracle 8, it seems to me that there is still little familiarity on the subject. I’m not really a Pl/Sql progra
Web API With AJAX: Exception Handling in jQuery Ajax() Function
(Sourav Kayal) Welcome to the “Web API with AJAX” article series, here we have been explaining various concepts related to AJAX and the Web API that is the latest technology for Microsoft’s communication platform.