|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Getting the OS Version | |
I want to query the OS version from T-SQL and use that to decide how other code runs. What is the easiest way to get this version programmatically into a variable? | |
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 Browser Port I have installed a named instance of SQL Server 2019 on a server. I have enabled remote connections, but want to have clients connect automatically to the instance by name as it uses a dynamic port. What firewall change do I need to make for the SQL Browser to function? Answer: open UDP port 1434 Explanation: The SQL Browser service uses the UDP protocol on port 1434 to let the client know which TCP port to connect to. Ref: Configure the Windows Firewall to Allow SQL Server Access - https://docs.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-ver15 |
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 2017 - Administration |
SSAS 2017 installation (dedicated) - Hi, I selected just SSAS and backward compatibility/Shared features while doing the installation. I opened the SQL server Configuration manager but the SQL Server Network Configuration is empty. Why there is no protocals showing? |
SQL Server 2016 - Development and T-SQL |
SQL Server 2016 SP3? - It’s been almost 4 years since Microsoft released 2016 SP2 and I’m wondering what happened to SP3 given that they usually release one service pack a year during mainstream support. Did 2016 join the Modern Servicing Model like SQL Server 2017? Is 2016 SP 2 the last service pack and from now on we will […] |
SQL Server 2019 - Administration |
Distributed AG - Hi, I setup distributed AG between two clusters and did failover testing. During failover I found an issue. Please help me to resolve the issue or provide me links showing if it is limitation. Problem: Configuration: WSFC 1: Node1 and Node2 WSFC2: Node3 and Node4 Availability Groups: AG1(WSFC1). AG2(WSFC2) AG1 Primary node: Node1 AG2 Primary […] |
SPLA License question - I've never used SPLA lic before. I'm at a new company that requires it to host applications. I've reviewed the User Rights docs. Can someone confirm if I have this correct? 3 node AG Cluster, 2 HA and 1 DR server. (4 cores each, SQL 2019 Ent) I think I have to license 8 cores, […] |
SQL Server 2019 - Development |
SUM with a ISNULL - Need to show as 0 (Zero) versus NULL - Is it possible to have '0' (zeros) versus a NULL in my output? DECLARE @GroupBy1 VARCHAR(100) = 'Visit Financial Class' DECLARE @GroupBy2 VARCHAR(100) = NULL -- 'Insurance' SELECT [Type] = 'Payments' , [Amount] = SUM(td.Amount) , [Action] = t.Action , [Date] = CONVERT(DATETIME, CONVERT(VARCHAR, MONTH(DateOfServiceFrom)) + '/01/' + CONVERT(VARCHAR, YEAR(DateOfServiceFrom))) , [AR_Bucket] = CASE […] |
ODBC Driver 18.0 - |
IIF statement query using SQL server - hey, Using the following statement I can calculate conversions taking place within the same month: IIF(datepart(wk,appl_createddate) <= datepart(wk,appl_conversiondate), 1, 0) however, if I want to return values where appl_conversiondate =< 4 weeks after appl_createddate how would I go about achieving this? Ultimately I'm trying to capture conversions that take place between months as well so […] |
How to show table in one row - Hello everyone, I want to display the information in the table in one row for each status (show the max create date of status) like the example. I would like to know how to do that Tks, Gilad |
Select from a table that might not exist - Hello! I'm writing a query. As per the logic in my SELECT statement there should be a column from a table that might exist. If it does not I should select Null instead Smth. like the following non compiling code DECLARE @NoTable bit SET @NoTable = 1 SELECT e.SN as ESN, CASE WHEN @NoTable = […] |
SQL Azure - Development |
Land and process 100's of files using Synapse - Hi fellow cloud people We are looking at moving from the land to the cloud we have 100's of files and SQL tables to load into the Data Lake Gen2 then process into the staging and presentation zones (I know names) and then on to the SQL Data warehouse We are looking for the best […] |
Amazon AWS and other cloud vendors |
Lambda Error Handling with SQS Trigger - Hey everyone, so I am trying to build a queue (fifo) with a worker lambda. Simple enough and it works. But in case of an error, I want to reliably mark the failed workload as failed in a database (no retries!). For some errors, I could just use a try-catch block. But in case of […] |
General Cloud Computing Questions |
Question about which cloud provider to get certified with. - Hi all! An opportunity within my company recently came up that would allow me to pursue a foundational certification for either GCP or AWS (AWS Certified Developer Associate vs GCP Associate Cloud Engineer). I wanted to reach out to ask if anyone had valuable insight about which certification would be most worthwhile to pursue. For […] |
Integration Services |
SSIS Expression to get current date with out timestamp - I have folder path c:\Employee\Students20220507023108 i am using this folder c:\Employee\ in for each loop container and i am planning to bring the foldername dynamically like created 2 variables folder path- c:\Employee\ folderName - Students Another new variable that holds entire path along with date. but the problem is my folder keeps on referring to […] |
Concatenate value - Hi all, I have derived column in the package (eight-bite integer value): (Test_column % 1000000000). Example, we have a code 111100000001234566. Using this expression we received 1234566. But now I need also fetch the first 4 digit and added this expression (Test_column % 1000000000). So, I want to receive this value 11111234566. Could you please […] |
PostgreSQL |
Turn on Query Execution Time Command - Hey, I am in the learning state for PostgreSQL and looking to turn on query execution command examples. I have added one example taken from this here. Can anyone tell me, Is it the right command example? user_ab=# \timing Timing is on. user_ab=# select count(*) from film; count ------- 1000 (1 row) Time: 1.495 ms […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |