Data is stored in heterogenous environments in many organizations. Enterprise reporting for management and other departments is created using a variety of tools. There are Excel Workbooks, SSRS Reports, Tableau Dashboards, flat files, data streams from MySQL databases, etc. Each data extract or report is created by a BI or DB Development Team member. Often […]
2020-07-07
7,130 reads
How to reset an identity field to the next contiguous value, after deletions.
2012-12-03
8,629 reads
When using format files to import data into SQL Server, the Integer(INT) data type needs special handling.
2012-02-16
5,140 reads
2009-12-09
3,375 reads
Replacement script for usp_ShrinkDBLogs, updates for SQL 2008 deprecating the WITH TRUNCATE_ONLY method.
2009-11-27 (first published: 2009-10-30)
963 reads
Preparation for upgrading SQL Server 2005 production database servers to SQL Server 2008, I tested upgrade in dev/test env.
2009-11-17
9,721 reads
When creating XML messages for Service Broker or other applications use this simple method to build a validation XSD.
2009-10-28 (first published: 2009-10-06)
1,459 reads
Ammends the sp_who2 procedure with the input buffer contents, ususally the SQL statement for that SPID
2009-04-24 (first published: 2009-03-27)
1,248 reads
2008-11-20 (first published: 2008-10-06)
964 reads
Introduction Traditional SQL Server backups can struggle with large databases, resulting in longer backup...
By Rob Sewell
"Let me know where you get your magic pixie dust from!"
By Steve Jones
flashover – n. the moment a conversation becomes alive and real, when a spark...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Hi Everyone, I have the data in the below form : Desired output: Here...
What was the originally name of the appliance that eventually became Azure Synapse Analyics?
See possible answers