SQL Server – Generate Calendar using TSQL
Introduction
Recently, I was asked to develop a SSRS based report for the Event Management module in MS Dynamics CRM 2011....
2013-04-09
1,157 reads
SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP
SQL Server – Generating PERMUTATIONS using T-Sql
Were you ever asked to generate string Permutations using TSql? I was recently asked to do so, and the logic...
2013-03-11
841 reads
SQL Server – TSql to find Records matching certain criteria in all the tables of a DB.
Generally, we try to find out records matching a certain criteria from a single or few tables. However, there are...
2013-03-06
1,031 reads
SQL Server # Moving MASTER database in cluster environment
Few months back I have wrote post about moving MASTER and MSDB database to new location in stand alone machine....
2012-12-24
2,115 reads
SQL Server Database Backup Report using T-SQL
Today, I am going to share few very useful scripts which will report us on Database Backup from different view...
2012-10-17
962 reads
SQL Server # TSQL to Convert STRING in PROPER format
Problem Statement
SQL Server has got in-built functions to convert the given string into LOWER() or UPPER() format but it does...
2012-10-14
1,319 reads
Troubleshooting Oracle Link Server - Part2
It's my bad that I did not made a post since long lately. I would not make an excuse like...
2012-09-01
1,074 reads
SQL Server # Storing Hierarchical Data – Parent Child n’th level # TSQL
Introduction
Today, I would like to explain one way in which we can store the HIERARCHICAL data in SQL tables. A...
2012-03-27
2,440 reads
Last Execution Date Time of a Stored Procedure
On many forums I have found a very basic yet important query - “How can I know when was my Stored...
2012-03-11
10,025 reads
Moving MASTER Database
In my previous post we see how to move MSDB database, today we will see how to move or relocate...
2012-03-08
1,093 reads
Blogs
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers