How to Configure E-mail in SQL Server Step by Step–TIP #96
For different reason we need to send database report , data and other SQL Server database related stuff using E-mail . SQL ...
2015-04-21
609 reads
Rajat Jaiswal
- Interests: I am always interested in Microsoft Technology specially asp.net & SQL server. Other than this I love Singing ,dancing and playing musical instruments.
Good things should be appreciated–SQL sentry Plan Explorer TIP #95
Although , It is out of box but I would like to share here. I am very choosy in food. When...
2015-04-16
545 reads
Very useful SET XACT_ABORT TIP#94
SET XACT_ABORT is one of the hidden gem we can say. It is helpful in many ways.
Let me explain by...
2015-04-14 (first published: 2015-04-04)
8,081 reads
How to resolve Space issue in SQL server 2005 TIP #93
Hello friends,
Many times we face space issues with our database. To resolve this problem SQL Server 2005 provided one more...
2015-03-23
757 reads
Data Compression–A unique feature PART–II TIP #92
In last post TIP #91 we talked about What is Data compression ? What are the features ? Now in this tip...
2015-03-11
602 reads
A Comprehensive Manual to Manage SQL Server Database
SQL Server is a uniquely designed Relational Database Management System developed by Microsoft. Its basic functionalities include storing, manipulating and...
2015-03-09
720 reads
Data Compression– a unique feature of SQL Server TIP #91
A part from performance many times we faced challenges related to space of our database. Sometimes our database is actually...
2015-03-08
627 reads
Kill–use this weapon carefully in SQL SERVER . TIP #90
When we heard “Kill” then first impression of this word is very bad. We always scare with this word.
In...
2015-03-03
641 reads
Secure your password with HashBytes TIP #89
Dear Friends,
In my last article (TIP 87) I wrote about PWDENCRYPT. I forgot to write few details but thanks to...
2015-02-28
1,234 reads
PWDCOMPARE–a hidden function of SQL SERVER TIP #88
I the last tip TIP#88 we saw how to encrypt a password. Now in this tip I would like to...
2015-02-25
918 reads
Blogs
Setting Up Always Encrypted
In this post we're going to go through the steps to set up Always...
Using Azure Automation and Runbooks to Run Azure SQL Database Maintenance Tasks
I’ve been using Azure SQL Database for quite some while and have set up...
Create and Verify Microsoft Fabric Capacity
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....
Forums
how to determine if we can delete the index can be removed
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
how to determine if we can delete the index can be removed
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
how to determine if we can delete the index can be removed
The table InventDim has some indexes, we create one index idx1 which has index...
Ask SSC