(John Papa) SPA is one of the most exciting technology strategies today, but it may be one of the worst terms in modern web development. Just the word “Page” can have many meanings.
Author: SSWUG Research
Changes In Transclude() Function Availability In AngularJS 1.2
(Ben Nadel) The other day, my friend Sam Lin pointed out that my use of the transclude() function in a JavaScript demo had been deprecated in AngularJS 1.2. After looking at the documentation, I was quite pleased to find out that he was right. While the change appears fairly cosmetic, I think it mak
Tuning DB2 Applications – I/O Constraints (5)
(Lockwood Lyon) Many of these methods have advantages and disadvantages. Here are a few examples to review.
SQL SERVER – Scripting Statistics for Read-Only Database and Making it Permanent
(Pinal Dave) This is a follow up blog post to my earlier blog posts about statistics for Read-Only Database. Please read the following blog post in this series to get further idea about this subject:
SQL Server Error Log, A Little Deeper
(Chris Shaw) I posted a blog titled, SQL Server Error Log. Often the things I post about are the items that I am using that day, or recently. Many of the topics, are simply based on how I may have made using SQL Server a bit easier for me to use one way or another.
Undocumented functionality in FORMATMESSAGE
(Kenneth Fisher) I was reading a rather interesting post on stackexchange “Why is % a forbidden char in a THROW message?” (which is an interesting read in and of itself) and noticed something interesting in the OP’s example.
Updating Data In SQL Server With Power Query
(Chris Webb) As of the November update of Power Query, it’s now possible to write your own SQL query when you’re moving data out of SQL Server into Excel using Power Query. So I got thinking… if you can write your own SQL query, can you execute any other SQL statement?
Working with multiple Web.Config files
(Dean Hume) When dealing with multiple development environments, it can often be quite tricky to keep track of the different environment specific settings that you may have in place. Fortunately, Visual Studio has a handy feature that allows you to have more than one Web.Config file for different en
DEFAULT ON NULL on INSERT
(Hemant K Chitale) Prior to 12c, the DEFAULT for a column would not be applied if you explicitly (or implicitly) inserted a NULL into that column. The NULL would override the DEFAULT value — the DEFAULT would not get applied.
PL/SQL Runs on the Server, not on the Client
(Andrew Reid) I read in a book that PL/SQL runs on the server, not the client so I decided to check this out. I started a Command prompt on my Windows PC and used a SQL*Plus session to connect to a database on a UNIX server.