Merge statement- A simple way for DML TIP#105
When, I first saw this statement a Hindi proverb come to my mind which is “1 teer 2 nishane” . The...
2015-07-18
951 reads
Rajat Jaiswal-337252
Proper Aliasing will help you somewhere TIP#104
Recently, When we were delivering session on “SQL SERVER” one of the persons asked why we require Aliasing so I...
2015-07-09
459 reads
It is OK its NULL only TIP #103
We always take NULL very lightly. Like if we are designing database then whether it is necessary or not we...
2015-07-15 (first published: 2015-07-06)
2,709 reads
Microsoft MVP–A dream came true
Dear All,
“Microsoft Most Valuable Professional “ – MVP is one of the prestigious tag. It is one of the dreams which came...
2015-07-02
476 reads
A myth about view TIP #102
I don’t know why every interviewer’s favorite question “Can we insert record using View ?” If you say Yes/No the interviewer...
2015-06-20
524 reads
Bulk Copy Program (BCP)–A simple way to export data in a file TIP#101
Let’s consider a scenario where the end user require a CSV file of all the records in a table then...
2015-06-18
1,293 reads
Find all the dates in a date range ? TIP #100
It’s almost one month that I didn’t write anything on the blog due to some personal reason. I am really...
2015-06-22 (first published: 2015-06-12)
2,428 reads
How to hide my SQL Server instance in network ? TIP #99
In TIP #70 we saw how to find all the running SQL SERVER instance in a network or a machine....
2015-05-04
664 reads
I am not able to access my SQL server instance on another computer tip #98
On last Friday , one of my colleagues had some issue related to accessing of SQL Server instance of database server...
2015-05-11 (first published: 2015-05-04)
5,913 reads
How to send E-mail/E-mail with Attachments in SQL Server TIP #97
In last post, TIP#96 We have configured Database E-mail. Now in this post we will see how to send mail...
2015-04-26
8,590 reads
Blogs
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Streamlining Azure VM Moves Into Availability Zones
By John
One of the more frustrating aspects about creating an Azure virtual machine is that...
Monday Monitor Tips: Native Replication Monitoring
By Steve Jones
Redgate Monitor has been able to monitor replication for a long term, but it...
Forums
Deadlock graph anomaly
I've come across what appears to be a strange deadlock anomaly. As seen in...
Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
The Challenge of AI
Comments posted to this topic are about the item The Challenge of AI, which...
Question of the Day
Deprecated Feature Tracking
From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?
See possible answers