(Robert Catterall) Securing data is more important now than ever before. There are, of course, the always more-stringent government regulations pertaining to the protection of various categories of data—two examples are credit card and healthcare records. In addition, there is the public-trust facto
Author: SSWUG Research
Using the DISPLAY Command, Part 5
(Craig S. Mullins) Today’s entry in our series on the DB2 DISPLAY command is the fifth – and final – edition of the series. We’ll wrap up coverage by briefly discussing the remaining features of DISPLAY. And, just as a reminder:
Attribute Routing in ASP.NET MVC 5
(Ken Egozi) Routing is how ASP.NET MVC matches a URI to an action. MVC 5 supports a new type of routing, called attribute routing. As the name implies, attribute routing uses attributes to define routes. Attribute routing gives you more control over the URIs in your web application.
Using SQL Server Management Studio Table Designer to create a table
(Robert Sheldon) Creating a table in SQL Server can seem daunting, especially if you’re new to database development. Not only must you define the columns that make up the table, but also the constraints that restrict the type of data you can insert into those columns.
ADO.NET: DataGridView Errors and SQLException Handling
(Ged Mead) In this blog post I described the steps needed to create a new Data Source and then use that source to display the data in a DataGridView on a Windows Form. As with all things code related, everything doesn’t always go as smoothly as you’d like and, in my experience at least, data handli
Scheduler API in Windows 8.1 and Visual Studio 2013
(Hannes Du Preez) Hello again! Today I will talk about the new scheduler API, to manage and schedule tasks or jobs, present in Windows 8.1. This allows us to set the priority of each job so that system resources are more effectively used and responsiveness is improved. The Scheduler API forms part o
Calculating Values within a Rolling Window in Transact SQL
(Dwain Camps) Before the SQL Window functions were implemented, it was tricky to calculate rolling totals or moving averages efficiently in SQL Server. There are now a number of techniques, but which has the best performance?
Constraints (Part 2) – ORA-00001 and ORA-02431
(Andrew Reid) The example below was checked on Oracle 9, 10 and 11. First a table was created:
Denormalize on Exadata compared with index
(Bobby Durrett) I modified the example from my previous post to see if on Exadata I could denormalize two tables and get the same performance without an index on the denormalized table that I get with the index on the normalized ones.
PL/SQL to delete invalid data from token Strings
(Jie Chen) Previous article describes how to delete the duplicated values from token string in bulk mode. This one extends it and shows the way to delete invalid data.