(Ember Crooks) There are a a vast array of things you can do in SQL. But just because you can doesn’t always mean that you should.
Author: SSWUG Research
Introduction to jQuery for App Customization
(Kevin Mehlhaff) JQuery is a popular JavaScript library that is used by many websites. LightSwitch employs jQuery to make it easy for developers to customize their applications. JQuery enables you to easily select, manipulate, and traverse HTML elements in the document object model, or DOM.
Looking at ASP.NET MVC 5.1 and Web API 2.1 – Part 3 – Bootstrap and JavaScript enhancements
(Jon Galloway) This is part 3 of a series covering some of the new features in the ASP.NET MVC 5.1 and Web API 2.1 releases.
[SQL Snacks Video] Importance of COPY_ONLY Backups
(Ayman El-Ghazali) There are many features/options we sometimes overlook and then wonder later what went wrong. The COPY_ONLY option with backups is one that I felt is important to highlight to SQL Server DBAs.
Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.
(Kenneth Fisher) I frequently rely on joining sys.dm_exec_requests and sys.dm_exec_sql_text() to know what queries are running on a system and when I have a blocking situation I like to look and see what query is running that is blocking everything else.
JSON Serialization Using Newtonsoft JSON Serialize
(Sourav Kayal) In this article we will use the Newtonsoft JSON serialization library to serialize JSON data.
PL/SQL Example Using SUBTYPE and VALUE_ERROR
(Andrew Reid) This example was tested on Oracle 11.2. First it creates a single-digit variable called SMALL_NUMBER. It then uses this to define a subtype called SINGLE_DIGIT, which has the same type as SMALL_NUMBER.
SQL SERVER – Writing SQL Queries Made Easy with dbForget SQL Complete
(Pinal Dave) Down with shackles of convention! dbForge SQL Complete 4.5 came in this world.
Designing Multi-Tenanted Databases
(Noel Herrick) Designing database tables for many customers is a surprisingly foreign concept for some programmers. I’ve been in interviews where a programmer will sketch out a normal object model, and then proceed to suggest that for the database, each customer has their own set of tables, each pre
Custom Code First Conventions – EF 6 New Feature
(Abhimanyu Kumar Vatsa) In this blog post you will learn a new feature ‘Custom Code First Conventions’ introduced with Entity Framework 6. This is ‘Code First’ only improvement. EF 6 comes with number of cool new features and improvements, so I decided to write blog posts and cover some of the new f