| Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2016 - Development and T-SQL |
| Create Multiple XML Files using SSIS - Hi community, I have a table in my database which consists of 100,000 rows. I am trying to move this data to 10 XML files (10,000 each rows). I am able to convert my data to XML format using ZS Export XML Task. I basically want my XML files like this: Individual_1.xml, Individual_2.xml, Individual_3.xml and […] |
| Designing a table - I have a scenario where: a company can have many workers(01,02) & worker can have multiple jobs (jb01, jb02) within the company, and in each job the worker can have 3 training courses (tr01,tr02,tr03) every year (2020,2021,2022). I need to create one table to accommodate this scenario to record the courses each worker did in […] |
| Replace calendar table multiplier column with date logic - Hello All, It's been a while. See the DDL/DML. I have a multiplier field associated with each day in a calendar table that I would like to replace with date logic. Updating the multiplier data is a yearly chore requiring an UI/data entry but really we would like to encapsulate the logic rather than relying […] |
| Development - SQL Server 2014 |
| Best practice - Hello friends, I am planning to setup some process for archival. The configuration part I have thought of but execution wise all I can think of sequential. I want to make it generic but can't think of a way around. Setup I am thinking of us something like this: 1. Configuring table with base table […] |
| SQL Server 2019 - Administration |
| SQL Server authentication issue with linked servers & mixed authentication types - I have a target server that I have read-only access to with Windows authentication. We'll call this Server01. I need to aggregate some data and do some analytics that isn't always easy in-session so I need to store some data more permanently than in temp tables. I also need to correlate with other data from […] |
| Performance problem - Hi I have one server running SQL server 2017 and one running SQL server 2019. The developer has reported that the SQL 2019 is much slower than the SQL 2017. Both servers are virtual and has the same spec regarding memory, CPU, OS ( Windows 2019). The settings in SQL is the same on the […] |
| AOAG Listener Error:Kerberos Status is showing: Incorrect username and Password - Hi, I am having error in creating AG Group Listener. We finally try to create one from Failover Cluster Manager by right click on AG role and added Listener from there. Listener IP comes online but Listener name still shows offline state. Please if anyone having same error, how to fix this. I am lost. […] |
| How to take offline backup in sql without interrupting Application connectivity - Hello All, My requirement is to to take full backup of the databases in below two production environments. We were doing Prod migrations. Before that we were planning to perform mock cutover. Without any down time or stop the application we would like to take the backups in both environments. 1st environment: Always on Configuration. […] |
| SQL Server 2019 - Development |
| Retrieving date from next from to fill in column on row above - Hi all, I have a very short query that contains an effective date but not expiration date. I would like to populate a expiration date set to 1 day before the next row's effective date. Here is query and results. For example, on part 100-121-0000, Revision A2; I'd like the Expiration Date to be 08-09-2009 […] |
| Getting count from Scheduled job procedures - I have a new requirement to create a Power BI Dashboard that shows current running jobs, average duration and a number of other KPIs including how many records are returned from a particular scheduled stored procedure. Is there an easy way to return this value? Most of the other data I can get from the […] |
| SQL Azure - Administration |
| How to set up Replication Alerts in SQL MI - Hello, Since Operators are not supported in SQL MI, how do you set up in SQL Managed Instance the Alerting on the normal Replication Monitoring? Normally can setup the 'Latency exceeds the threshold' and 'Warn if a subscription will expire' but they are configured with Alerts which isn't supports in SQL MI. Thanks, […] |
| General Cloud Computing Questions |
| MySQL and Cloud SQL - Hello all, I’m working on a go web app and am using the app engine. Right now I am trying to set up a landing page for an email list (for a soon to come site). I’m a bit confused as to how cloud SQL works. From my understanding I still have to install MySQL […] |
| Azure Data Factory |
| Data factory question - Upon my adventures of Azure data factory and all the wonders it can do I have stumbled upon a issue that Microsoft support has no answer as of yet. Long story short, I am trying to ingest data from a storage blob in another tenant. That customer will only allow us to connect to that […] |
| Powershell |
| Attempting to run PS / DBA tools script as a SQL Agent job - If I run my PS script with PS as an ADMIN interactively it runs fine. If I attempt to run it as a SQL Agent job it has issues. I think the problem is it needs to run as an ADMIN but I cannot figure out how to do that. Has anyone had issues running […] |
| SQLServerCentral.com Website Issues |
| Alerts and default font - I have not been receiving e-mail alerts in the last few days. Also, when I type a post, it looks like the default font has changed to Courier 9pt or similar ... even though the published post renders as usual. |
