(Robert L Davis) I have one more thing I want to talk about regarding the conversation I had recently with my friends and former colleagues at Idera about the things that slow down SQL Server. Another “quick performance wins” you can take advantage of is segregating the types of files SQL Server use
Author: SSWUG Research
The job History of all SQL Server Scheduled jobs are getting deleted automatically on a daily basis!
(Pooja Kamath) In this blog I would be explaining how we resolved a Scenario where a customer reported that
Use Powershell to Send Email Notification for SQL Server Cluster Failover
(Ben Snaidero) We generally find out that a SQL Server Cluster has failed over to another node in the cluster after the fact when looking at logs for some other reason. This tip will look at using PowerShell to send out an email notification when a failover occurs.
Cleanup a MySQL Schema
(Michael McLaughlin) My students required way to remove all their tables, views, and constraints from a MySQL database (or the alias schema). Since they’re using referential or foreign key constraints, I also wrote one procedure to drop all foreign key constraints from a database.
Post JSON data to WCF RESTful Service using jQuery
(Imran Abdul Ghani) The POST request method is basically designed to post data to a web server for storage. That’s why its normally used when submitting a complete form. In this WCF RESTful service tutorial, I’ll try to explain how we can post JSON data to a WCF RESTful service using jQuery Ajax cal
Getting Started with jQuery.tmpl (jQuery Templates) in MVC
(Abhimanyu Kumar Vatsa) In this post you will learn how to use jQuery.tmpl (jQuery Template) JavaScript library in MVC for client side templating. I will take you through few easy steps to setup it and working.
Creating public-facing websites in SharePoint Online
(Brien Posey) Although SharePoint is probably best known for its user sites and team sites, SharePoint Online supports the creation of a publicly facing website. This SharePoint site is publicly accessible, even to those who do not have an Office 365 account. In fact, some organizations host their c
Regular Expressions, Part 2: Positioning and More
(Ondrej Balas) In my last column, I left off with an explanation of how groups can be used to divide a pattern into smaller pieces, or sub-expressions, allowing for repeating subsets of the pattern.
Build your Apex application better – do less in Apex
(Jeffrey Kemp) I recently saw this approach used in a complex Apex application built for my current client, and I liked what I saw – so I used a similar one in another project of mine, with good results.
Auto-Replace in Oracle SQL Developer?
(Jeff Smith) I get this question every few months, and I got it again last week in Denver –