(Rohatash Kumar) Today, I have provided an article showing you how to develop and design queries using the Query Designer in SQL Server 2012. Many new developers don’t want to write queries directly. This is because they don’t know the SQL syntax.

(Rick Dobson) Have you been tasked with transferring SQL Server data for several different SAS analysis packages or even for a single package on a recurring basis? Are the precise inputs for the SAS pack(s) subject to change? Do you have to enable SAS developers to create their own solutions with cu

(Rohatash Kumar) Today, I have provided an article showing you how to add columns of multiple tables into one column in SQL Server 2012. There is no need to write an insert query again and again; you can do it using a single query.

(Daniel Calbimonte) When deploying an application or application updates, sometimes there is a need to create or modify SQL Server database(s), tables, views, stored procedures etc… This can be done using scripts and connecting to each instance, but what if you need to deploy to multiple servers

(Chris Lambrou) As one of the developers of SQL Monitor, I often get requests passed on by our support people from customers who are looking to dip into SQL Monitor’s own data repository, in order to pull out bits of information that they’re interested in.

(Rohatash Kumar) Today, I have provided an article showing you how to calculate the difference between two dates of the same column or in different columns in SQL Server 2012. I have a table named Registration and this table has two relevant fields UserID and CreatedDate and Lastlogin.

(Mika Wendelius) From time to time different discussions pop up concerning truncating the transaction log in SQL Server. The truncation is often offered as a treatment to a problem that the log file filling up or is already filled. While it’s true that truncating the log and shrinking the log file m

In the previous SSWUG TV interview with Stephen Wynkoop and Laura Lee Rose, we covered How to handle “Net Takers”. This is a more detailed discussion on that topic.

(Itzik Ben-Gan) When a new T-SQL feature is introduced in SQL Server, it usually takes some time before users realize certain aspects of working with the feature. In time, people develop best practices for using the feature and discover interesting, nontrivial things about it.

(Pinal Dave) Sometime email requesting help generates more questions than the motivation to answer them. Let us go over one of the such examples. I have converted the complete email conversation to chat format for easy consumption.