Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Development |
tsql help - Hi All, Need some TSQL help. Need to extract a portion of the string of [tran_log_writes] column, convert that value to GB and display it as seperate column as "TLOG-gen-GB". Below is the sample data. CREATE TABLE [dbo].[test2]( [tran_log_writes] [varchar](8000) NULL ) GO INSERT [dbo].[test2] ([tran_log_writes]) VALUES (N'db1: 245471085 (68491820 kB)') GO INSERT [dbo].[test2] ([tran_log_writes]) […] |
SQL Server 2016 - Administration |
WSFC - DR question. - I'm trying to write a DR doc with no test system for someone with no experience of SQL / clustering. I know! Don't ask. It's a weird old place where I work but they pay, I do. So, 2 nodes at site 1. 2 at site 2. 2016. AG. WSFC underlying on 2016. File share […] |
SQL 2016 Patches and CUs marked "duplicate (do not use) - What's the story with a lot of SQL 2016 patches being marked "duplicate (do not use)"? It's not just one or two, it goes all the way back to CU1, and seems to be almost all of the patches, but there's no explanation or reference to what should be used or how to know if […] |
SQL Server 2019 - Administration |
Odd Connect Issue With FQN - I have a 2019 SQL server that I can connect to with the NetBIOS name, but get "Access Denied" when I try to connect to it using the FQN. I have tried from multiple clients, including the console of the problem server. I have verified the normal things, access rights, group membership, that the domain […] |
Need to enter the port to connect... - This is one of the mysterious things that clearly something changed, and n0body knows what. We have our monitoring software installed on a SQL 2019 server. Last week, it stopped connecting to two servers, SQL 2016 and SQL 2014 versions. Both are named instances. The connections were set up as ServerName\InstanceName, and this has been […] |
failed jobs - if then else - i'd like to list out the failed jobs within the last 24 hrs. if there's none, print "none". however i'm getting an error. error: Msg 128, Level 15, State 1, Line 39 The name "none" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are […] |
SQL Server 2019 - Development |
Audit data - Hi Team , We have a requirement from the client , in which we have get the data about all users(ip address , machine etc) who have performed DML operation on any table in the database . If there were few tables I would have created a DML trigger . Is there any tools in […] |
General Cloud Computing Questions |
Not a question - Just making sure everyone knows. - I'm posting this because I just want to make sure that people are aware. I don't believe a "panic" is required but I do believe that "awareness" is required. We all "knew" the following would "never happen", right? https://www.securityweek.com/microsoft-cloud-hack-exposed-more-than-exchange-outlook-emails/amp/ https://www.bleepingcomputer.com/news/security/stolen-azure-ad-key-offered-widespread-access-to-microsoft-cloud-services/ You might also want to check on the "Related" links near the bottom of […] |
Azure Data Factory |
using ADF to extract Dynamics 365 data - Hello, we a migrating from on premises CRM to cloud D365 and need to ETL data into on-premises sql server/data warehouse. I have come across 2 options... KingswaySoft SSIS Integration Toolkit for Microsoft Dynamics 365 / SSIS Productivity Pack Azure Data Factory. We are a company that uses Microsoft products and services and already have […] |
Reporting Services |
showing character "?'' as total of pages in the top toolbar navigation panel. - Hello fellow, I would like to post this issue which is driving me insane referred to the pagination control on the navigation top menu. On initial element listing paging shows up like image above. Whereas I'm moving forward thru next pages, it remains as such: Same issue continues till get the last page. The only time […] |
Powershell |
Append MMYYYY to File to Copy - How can I adjust this script to add MMYYYY to the file name before the extension on the Copy? thanks Before: dys_ihhist.txt After Copy to Dest dys_ihhist_072023.txt $source="c:\fileloading" #location of starting directory $destination="c:\filecopy"; #location where files will be copied to $files=@("*dys_ihhist*") New-Item -ItemType Directory -Force -Path ($destination); Get-ChildItem -recurse ($source) -include ($files) | Copy-Item […] |
Analysis Services |
Can workspace database be recreated in tabular cube? - Hi All, I need to modify an old tabular model for which workspace database has been deleted accidentally. Is there a way to recreate the workspace database? I deployed the cube but it only creates main DB not the workspace database. |
Strategies and Ideas |
What is the meaning actually for DWH - Hello.. Im working on a data facility almost since 8 years on a BI and DWH design … and there was always a question on my head about designing the DWH when we talk about storing data .. are we talking about every part , column , row , cell of data or are we […] |
Integration Services |
Script task to get oauth 2.0 token error - I am trying to figure out a way to get oauth2.0 bearer token from the rest API. So from Postman I can do a POST method for "https://helloworld.org:443/xyz/oauth2/token" And in the body, I choose x-www-form-urlencoded and put grant_type as "password" and put the values for my username and password. This gives me a token which […] |
SQL Server 2022 - Administration |
Find Version Mismatch - Hello, I'm looking for a way to generate a cross-sever report [using TSQL(without LinkedServers) or Powershell ] to show SQL Server AlwaysOn replicas that are not in the same version. Can someone please guide me? Thanks in advance |