It is easy to import Excel data into database tables via TSQL, using OLEDB, either by the OPENROWSET function or linking to the spreadsheet as a server. The problem is that there are certain things that aren't obvious that you need to know about.
Steve Jones completed a task this year that he's rarely completed in the past.
This article shows a step-by-step guide to move the distribution database to a new SQL Server instance.
Marcin Policht presents different methods that allow you to monitor the performance and characteristics of your PaaS databases, ensuring that they behave in a manner that matches your expectations.
There's an interesting idea that exists for lightweight, application separation on a host that's different from virtualization. It's Docker, and Steve Jones talks about it today.
Whereabouts in the application should the business logic of data-validation checks be made? The advantages of a layered approach to validation that includes database constraints, would seem to outweigh the disadvantages.
This article is part of the lesson 18 to 20 related to SQL Server Data Mining with Excel.
This article is part of the lesson 18 to 20 related to SQL Server Data Mining with Excel.
Greg Larsen explores how to remove rows from a SQL Server table using the DELETE statement.
When a table has multiple indexes defined on the same columns, it produces duplicate indexes that waste space and have a negative impact on performance. This metric measures the number of possible duplicate indexes per database above a set threshold. You can then consider dropping the indexes and reverse the change.
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Efficient query performance in Amazon Redshift often comes down to how well you manage...
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Recently, our dev teams approach me for advice on improving their huge heap table...
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers