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,183 reads
How to reset an identity field to the next contiguous value, after deletions.
2012-12-03
8,651 reads
When using format files to import data into SQL Server, the Integer(INT) data type needs special handling.
2012-02-16
5,187 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,759 reads
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Let’s face it, most of the time, you probably don’t want your SQL Server...
Many job schedulers (e.g., SQL Agent, Airflow, Azure Logic Apps) can report when a...
Comments posted to this topic are about the item The Table Backup
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
I run this code in SQL Server 2022. What happens?
BACKUP TABLE beercount TO DISK = 'beercount.bak'See possible answers