Question I’m trying to find a way to allow an application to create tables and insert data into them on a SQL Server 2019 while protecting from injection attacks in case the app credentials would leak. My experience is limited when it comes to writing … [Read More]
Question I have a SQL query that looks for values in a table on a range of dates. If no record is found, I would like to generate rows with default values. Example of one of the table existing records: DeviceId Time Context Value 1 … [Read More]
Question Apologies in advance if I don’t use some terminology correctly here. I’m not a DBA but I’ve been temporarily forced into the role. I’ve inherited an application that runs on SQL Server 2016 Enterprise – one instance for PROD and another for TEST. These … [Read More]
Question Can anyone help with this error? SQL: Error: Msg 207, Level 16, State 1, Line 13 Invalid column name ‘PurchaseType’. asked 2022-01-13 by Mark_72 Answer This error is coming from your WHERE clause, not your CASE expression. You say WHERE PurchaseType = ‘Top Performer’, … [Read More]
I’m not going to beat around the bush. I hate the SERVERPROPERTY() and DATABASEPROPERTYEX() system functions. Loathing The thing I hate the most about these two functions is that you need to know the right magic spells to make them work. Let’s look at SERVERPROPERTY() … [Read More]
Question I recently had to uninstall Visual Studio 2012 and DTS, then install VS 2017 and DTS again. Afterwards, The directory containing sqlcmd.exe was not in my PATH variable. I installed the following. Should either of these kits install sqlcmd.exe? If not, which tool will … [Read More]
Question That’s a weird scenario. The transaction log is full. It waits on AG. AG is all good. No latency, last commit/hardened time is almost real-time on all the nodes. The Estimated Recovery Time is zero. I checked this from the primary node and secondaries … [Read More]
Question I have an application that uses PostgreSQL as RDBMS. There is a table containing orders placed by customers. The table has an id as primary key, an order_number (integer) and a created_at field (timestamp). id and created_at are assigned automatically when the row is … [Read More]
Question I have a query that pulls information for a database from the following tables sys.master_files sys.databases sys.filegroups Currently, the context set is the specific database which I want to query about. But if the database is in a mode such that USE DB_NAME doesn’t … [Read More]
Question doing some work with the SQL Perfmon counters and banging my head against the wall trying to work out how to translate the instance_name column to a database name. So if I run a query like the following I get a resultset like Log … [Read More]
Copyright © 2025 | Andy Mallon | am2.co