2016-10-21 (first published: 2015-05-12)
2,382 reads
2016-05-25 (first published: 2014-03-06)
2,215 reads
Code For Truncating Table with foreign Key Constraints
This can be used for data warehouses as well as truncating table with foreign key constraints.
2016-04-08 (first published: 2014-07-07)
2,611 reads
Accurate Time between Two Dates in Year, Month,Day Format
This script shows the total time between two dates.
2016-03-29 (first published: 2014-07-09)
3,069 reads
Detach & Attach Procedure
For successful run, Your SQL Server service account should have permission to old location & new location
2015-05-27 (first published: 2015-05-10)
1,027 reads
Find only characters or only integer from alphanumeric value
Extract only integers or characters from alphanumeric :
2014-10-07 (first published: 2014-09-05)
1,498 reads
Blogs
When It’s Still Viable
By Brian Kelley
If a technology is still viable, don’t overlook it. Don’t get caught up chasing...
T-SQL Tuesday #179: The Detective’s Toolkit
By Steve Jones
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend,...
Moving T-SQL Tuesday to Jekyll
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
Forums
Azure SQL DB CLR
Hi, Azure SQL DB doesn't support CLR, if we have an application with CLR...
Steps to restore database which is part of Trans replication and Allwayson db
We have a Setup where replication and AG is configured as below. Servers:Node1,Node2 ==>Node1...
An error occurred while skipping data rows
I am trying to build an ETL for an Existing Table. The ETL (SSIS)...
Question of the Day
Data Migration Assistant Targets
In the current (2024) version of the Data Migration Assistant, which on-premises targets are available?
See possible answers