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,212 reads
How to reset an identity field to the next contiguous value, after deletions.
2012-12-03
8,691 reads
When using format files to import data into SQL Server, the Integer(INT) data type needs special handling.
2012-02-16
5,234 reads
2009-12-09
3,385 reads
Replacement script for usp_ShrinkDBLogs, updates for SQL 2008 deprecating the WITH TRUNCATE_ONLY method.
2009-11-27 (first published: 2009-10-30)
977 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,768 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,505 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,285 reads
2008-11-20 (first published: 2008-10-06)
972 reads
By DataOnWheels
It has been a while since my last T-SQL Tuesday blog. When I saw...
The last T-SQL Tuesday of the year is hosted by my good friend Mike...
By Steve Jones
This month Mike Walsh hosts T-SQL Tuesday. It’s been quite some time since he...
hi i get the error you see below when trying to process my AR...
Hi So I have the below select query that won't return results if I...
Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise:...
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers