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
474 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
523 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,589 reads
Blogs
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Forums
Website Stability 2025/12/05
All week we've had issues with the site being up and down. There's been...
403 Forbidden
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
Question of the Day
Fabric Mirroring
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers