Additional Articles


External Article

Identify SQL Servers with inefficient Power Plans

Regardless of the level of CPU load you currently sustain, you are very likely to benefit from correcting the power option, and are almost guaranteed to not make things worse. But knowing how to correct the issue is the easy part; it’s a simple setting in the Control Panel. The main issue is that it can be tedious to check this setting across all the servers in your environment.

2026-11-18

External Article

SQL DROP COLUMN Without Breaking Code

Adding a column is relatively easy, since the applications can just ignore it in most cases. But taking a column away can be a little bit more work, as you may have to trick the applications into believing the column is still there. I often see systems where deprecated columns have stayed around “forever” — because people are too afraid to remove them, or because they don’t have the access or capability to modify the source code of the affected applications.

2026-11-09

External Article

Strip double quotes from an import file in Integration Services SSIS

When loading data using SQL Server Integration Services (SSIS) to import data from a CSV file, every single one of the columns in the CSV file has double quotes around the data. When using the Data Flow Task to import the data I have double quotes around all of the imported data. How can I import the data and remove the double quotes?

2026-10-26

Blogs

Should You Use CHOOSE(): #SQLNewBlogger

By

I was experimenting with CHOOSE() recently after I was asked a question. In a...

T-SQL Tuesday #204 – Are blogs still relevant? (Roundup)

By

I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...

Build vs Buy AI: When to adopt, partner, build or buy

By

Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...

Read the latest Blogs

Forums

Cs Digital BCA KCP Kudusan Hub/Wa. 0817-819-444

By Halo_BCA

Jl. Zainul Arifin No.78, Sukoharjo, Kec. Klojen, Kota Malang, Jawa Timur 65118

Cs Digital BCA KCP Lawang Hub/Wa. 0817-819-444

By layanan 24jam BCA

Jl. Thamrin No.8, Lawang, Kec. Lawang, Kabupaten Malang, Jawa Timur 65211

Weird problem altering logins with sysadmin account

By Brandie Tarvin

Has anyone ever seen this before? I have sysadmin permission on a server. I...

Visit the forum

Question of the Day

Switching Schema II

I run this query:

SELECT 
 s.name AS schemaname
 , o.name AS objectname
 FROM sys.objects o
 INNER JOIN sys.schemas s ON s.schema_id = o.schema_id
 WHERE o.name = 'Beer'
I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beer
What happens?

See possible answers