What is User Defined function in SQL Server?

User-defined functions encapsulate T-SQL statement and return a table or a scalar value to the caller. UDFs can not be...

Yet one more quick and easy performance tuning setting

I blogged in the past about two simple commands that can be a big help in performance tuning SET STATISTICS...

SQL Server 2016 – the Security & Performance Release / ein Sicherheits- und Performance-Release

Sysmail_help_Account_sp – SQL Server Database Mail Stored Procedure – Part 6

Hi friends, in this blog we will learn how to get information about database mail account using stored procedure sysmail_hep_account_sp....

005 – Antiques Roadshow - WaterOx Consulting

Reading Time: 4 minutesAre You Running An Antiques Roadshow? In WOxPod!, episode # 005 –...
The post 005 – Antiques Roadshow appeared first...

Book Review: Connected

I heard about Connected from a show on NPR (Yes, I listen to NPR, why do people keep saying that?)....

Detach and Attach All User Databases

Sometimes you are in a scenario where you need to transfer a large number of databases from one server to...

Finding gaps or missing dates in a date range using TSQL

Here’s a quick how-to on returning temporal data set that includes missing dates. Suppose you are tasked to query an...

hey its time for 2016!!!

Hi all Yeah its true microsoft announced SQL server 2016 and CP2 has been released to public also we can...

Installing SQL Server 2016 CTP2 – UI Changes

SQL Server 2016 CTP2 public build was released by Microsoft yesterday, and if you haven’t downloaded it yet, then drop everything(No,...