Comparing data in two identical tables

Continuing with the recipes in SQL Server 2012 T-SQL recipes book – I was drawn to this puzzle that asked for...

Supporting Khan Academy

Khan Academy is doing a fund raiser and I just donated $10 to help out – my kids have easily gotten...

The Writeable Warm Standby

I saw a question recently that went like this: I get one full backup from FTP. I’ll get daily log...

Monday Morning SQL Break – December 14, 2015

It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...

One More PASS Board Update for 2015

Remember that post I wrote about taking on SQLSaturday events as my new PASS portfolio?

Never mind.*
Instead, it seems I’ll be...

Can we get a license for DDL Triggers?

There are several types of triggers.
Logon triggers – Fired when someone tries to connect to the instance.DML triggers – Fired after...

Picking a Clustered Index

A Clustered Index is not another term for Primary Key, and more thought should be put into the key columns...

Quick Tip: Why Can’t I Pin an Excel Range to a Power BI Dashboard?

So two new exciting capabilities were announced recently in Power BI.  One involved Excel and the other SSRS, but they...

SQL Server – Check the status of active Trace Flags

Hi friends, few days back I was exploring data masking features introduced in SQL Server 2016. I got stuck in...

SQL Server tips ,SQL Server tutorials, database tips- Indiandotnet: Step by Step Merge transformation control in SSIS ...

SQL Server tips ,SQL Server tutorials, database tips- Indiandotnet: Step by Step Merge transformation control in SSIS ...: In the Series...