(Imran Ghani) jQuery extensively simplified web developer’s life and has become a leader in javascript available libraries. There are a lot of useful jQuery snippets available but here in this post I am going to share 7 basic and widely used code snippets that every front-end web developer must have
Author: SSWUG Research
Database Mail Tip: Notifying Operators vs. Sending Emails
(Michael K. Campbell) In the past few months I’ve provided a number of blog posts about ways to configure and use SQL Server’s Database Mail functionality to proactively send alerts and notifications. However, one way that I’ve recently found to be more effective is to stop sending emails/notificati
Setting up linked servers using Windows Authentication and how to solve multiple hop problem
(Szymon Wójcik) This post will cover a topic of connecting linked servers using Windows Authentication. Linked server is a hot topic since longer than I am able to imagine (namely SQL Server 7.0) but it needs a bit of attention to understand it properly. The focus will be on setting up linked server
Query to get only date from datetime in sql server like dd/mm/yyyy, mm/dd/yyyy, yyyymmdd, dd-mm-yyyy etc
(theheing) Here I will explain how to convert or get only date from datetime in different formats like like dd/mm/yyyy, mm/dd/yyyy, yyyymmdd, dd-mm-yyyy etc in SQL Server.
SQL Server 2012 Analysis Services Partitioning Performance Demonstration
(Dallas Snider) How much of an improvement in processing time can a simple SQL Server Analysis Services (SSAS) partitioning structure provide? Can you provide any examples? Does this processing time improvement only apply to the fact tables?
How to export data from database tables to an XML file using SSIS
(Maxim Rudoi) I had a task to export data from tables in a database on SQL Server to an XML file. Here is a simple way to do it using SSIS. No Script components!
Pick a task to work on
(depesz) There are cases where system stores list of things to do, and then there are some worker processes that check the list, pick something to work on, do it, and remove from the list.
Top Ten Common SQL Mistakes (with DB2 for z/OS)
(Craig S. Mullins) There are many different types of development mistakes that can be made when you are coding a complex application system. But probably the most pervasive mistakes being made when developing an application using DB2 for z/OS are SQL mistakes… well, actually, that statement is pro
ORA-39083 and ORA-00439
(Andrew Reid) I created a table with deferred segment creation in an Oracle 11.2.0.1.0 Enterprise Edition database:
WPF Base Classes – FrameworkElement – Object Lifetime
(Richard Carr) The twenty-sixth part of the Windows Presentation Foundation Fundamentals tutorial continues to look at the members of the FrameworkElement type. This article describes three object lifetime events that can be captured for any WPF control.