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,215 reads
How to reset an identity field to the next contiguous value, after deletions.
2012-12-03
8,694 reads
When using format files to import data into SQL Server, the Integer(INT) data type needs special handling.
2012-02-16
5,239 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,506 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,286 reads
2008-11-20 (first published: 2008-10-06)
972 reads
By Andy Warren
Somehow two years have elapsed since my last update; hopefully it won’t be that...
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
I have table: t1 in schema1 with 19 billion records. I have another table...
Comments posted to this topic are about the item Minimally Viable Security
Comments posted to this topic are about the item Encoding NULL
What is returned from this code in SQL Server 2025?
SELECT BASE64_ENCODE(NULL)See possible answers