|
|
|
|
|
|
|
| Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Identify a Slipstream Installation | |
| I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later? | |
Think you know the answer? Click here, and find out if you are right. | |
| Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
The New Database CheckDB I run this code: create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')What is returned? Answer: 1900-01-01 00:00:00.000 Explanation: This returns 1900-01-01 00:00:00.000. Ref: DatabasePropertyEX() - https://learn.microsoft.com/en-us/sql/t-sql/functions/databasepropertyex-transact-sql?view=sql-server-ver17 |
| Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2019 - Administration |
| SSIS packages failing with a status "ended unexpectedly" (SSL/TLS timeout ?) - We have an issue where SSIS packages are failing with a status of "ended unexpectedly" within 30 - 60 seconds after scheduled start. This issue is transient and not specific to any SSIS package. After rebooting the server, packages will run normally for a couple of weeks but then start to fail a few at […] |
| SQL Server 2019 - Development |
| count the number of NULLs in a row - Hi everyone I have a SP that finds the average based on 3 tables. I need to know how many NULLs are in a row, not column. The only way I know how to do this is to first find all combinations of outcome and then second use a CASE statement. This is fine for […] |
| SQL Azure - Administration |
| SQL MI Next-gen general purpose tier - Has anyone used Azure SQL MI on the next-gen general purpose tier, Microsoft documentation says it offers better IOPS compared to the regular tier. If the IOPS limit is stated as 10k, is this limit applied per database or is it the upper limit for the entire SQL Managed Instance? Does the IOPS we get […] |
| General |
| Can Flyway work with GitHub Self-Hosted Runners? - I work on the CI/CD team. We're considering different applications for helping us with database migrations and, if necessary, rollbacks. Red-Gate's Flyway is one of the solutions we are considering. I've got experience writing SQL Scripts to create tables, views, stored procedures, etc., but I am not a DBA. I've started watching some of Red-Gate's […] |
| SSDT |
| ETL Framework In Production - Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through the Execute Process Task. I am extracting Data from E2 SQL to Azure SQL Server. The connection has already been established. I am building complete ETL using Function Extraction of Data (Full load/Incremental Load) Transformation Logging Audit Table Loading The […] |
| Editorials |
| The Selfish Case for Learning AI - Comments posted to this topic are about the item The Selfish Case for Learning AI |
| SQLServerCentral.com Website Issues |
| Are topic notifications working? - This is a topic to test whether reply notifications are working or not. |
| Article Discussions by Author |
| The Last Good DBCC Run - Comments posted to this topic are about the item The Last Good DBCC Run |
| SQL Server Ghosts - Comments posted to this topic are about the item SQL Server Ghosts |
| Regular Expressions in SQL Server 2025 - Comments posted to this topic are about the item Regular Expressions in SQL Server 2025 |
| Slip Streaming Installs - Comments posted to this topic are about the item Slip Streaming Installs |
| SQL Server 2022 - Development |
| Varchar(max) to lines - I have an issue with a varchar(max) field with up to 7000 characters needing to be put in to lines of 85 characters long and keep formatting with char(13) in it and not to break words. Basically it is to take a memo field from a software to import into Business Central Extended Text lines. […] |
| Deleting data in large table - I have a large table with 17M+ rows for our package record audits. I've decided to clear out anything older than 3 months which would clear all but 1.2M records. The table doesn't currently have any indexes. What's the recommended way to clear the records from the table? Should i consider adding an index to […] |
| SQL Newbie HELP: The query references an object that is not supported in distr.. - Hi everyone! I'm new to SQL and am trying to query a view (dbo.) made from a D365 table. My goal is to do a recursive joins on 4 different views but to start with I tried something basic and received the following error: The query references an object that is not supported in distributed processing […] |
| Connecting ERP system E2 and Extract Data , perform Transformation - Hello, May someone please help me how can I pull data from ERP named as E2. E2 is using SQL Server. Looking for detailed steps of connecting to E2 System. I am planning to use python scripting. Do I need to Install any driver. what all configuration details we have to paas in the scripting. […] |
| |
| ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |