|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
The Assert Transformation | |
What does an Assert Transformation in Azure Data Factory do? | |
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 Azure Database Timezone How can I check the current timezone of an Azure SQL Database or a Managed Instance from a client? Answer: SELECT CURRENT_TIMEZONE() Explanation: CURERNT_TIMEZONE() is a function that is available in Azure SQL Database and Managed Instance to give you the current timezone of the instance or server. For an Azure SQL Database, this is always UTC. Ref: CURRENT_TIMEZONE - https://learn.microsoft.com/en-us/sql/t-sql/functions/current-timezone-transact-sql?view=sql-server-ver16 |
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 |
Uninstalling SQL 2012 Native Client breaks Failover Clustering - Is anyone aware of issues where uninstalling SQL 2012 Native Client breaks Failover Clustering? We were recently asked to remove unsupported software from our servers and the list included SQL 2012 Native Client. Version 11 was installed, so we removed it from test & dev servers without any issues. When it came to the Live […] |
Log full error 9002 - Hi Experts. I want to call a sql agent job when 80% of the Transaction Log file is full. I wanted to do some data collection when the log is getting full. How to do it? Thanks, Bob |
SQL Server 2016 - Administration |
Last login for user on spesific table - Hi Is it possible to get a report for each table in a databse of who last viewed, updated, delteted and so on ? I know I can get last login to a databse, but I want to check what table for last login for that user |
WinRm run Invoke-ProcessPartition : A connection cannot be made - I have a script which is used to connect to a remote SQL Server. It works well when in local Windows environment. However, when I run it use winrm on another server, this exception happens: Invoke-ProcessPartition : A connection cannot be made. Ensure that the server is running CategoryInfo : NotSpecified: (:) [Invoke-ProcessPartition], ConnectionException FullyQualifiedErrorId […] |
SQL Server 2016 - Development and T-SQL |
Table Header with Dynamic Dates - Hello, I need to create a dynamic table that produces a Date Column Header based on Date parameters entered, is this possible? My table is as follows, followed by the desired results: CREATE TABLE #t (CustID int, StaffID int, JobID int, Dt datetime, Units money) INSERT INTO #t (CustID, StaffID, JobID, Dt, Units) VALUES (101, […] |
SQL Server 2019 - Administration |
Sqlagent data transfer issue - I am not an sql person but have been asked to investigate strange behaviour when transferring large amounts of data from Linux to windows using sqlagent.exe. wireshark seems to suggest that for every packet sent, an ack is returned and appears to be ignoring tcp window size. Pic below and any advice/pointers would be great. […] |
Fix for SSPI context error uses RC4 - any alternatives? - Hello experts, I've been trying to resolve an issue that seems to happen when SQL Server 2019 runs on Windows Server 2019. This may be actually an issue with our Systems-mandated security settings to lock down the servers, but I am wondering if you have some advice for other ways to work around the issue. […] |
SQL Server 2019 - Development |
Multiple Database Deployment using DACPAC - Dear All, I am able to deploy single database using DACPAC and VS Solution ,Post deployment scripts .But now I have to deploy multiple databases to same instances .Can you please guide how to do that using DACPAC. Do need to create DACPAC and VS solutions for each database ? |
Trying to go remote through a Cox Technicolor Modem/Router - I'm really not sure how to ask or what to ask for. This is NOT an Openvpn question. This is about accessing my SQL Database remotely. So does anyone access their home computer from a laptop in another location not using Openvpn? Below is my setup and situation. My setup: Windows 10 Pro Sql Server […] |
Replace value from - Hi guys I hope everything's ok with all of you I have this example to do it in SQL. I want all characters after the space between. like this Please beware the number of characters. The ideal would be something like "give all characters from space to the right" I hope I was clear. Thanks […] |
SQL Azure - Administration |
Unable to Connect to Azure PaaS Instance using SSMS 18.x - Good Morning Team, When we try to connect to Azure PaaS instance using SSMS 18.x from our VDI's; we are unable to connect and receive Error Message 10060. The same Azure PaaS Instances are reachable from our Azure VM's using SSMS without any issues. However on the VDI's; In SSMS->Additional Connection Parameters; if we specify […] |
Reporting Services |
Is it possible to view (display) a Varchar(max) saved in in a Table. - I have an old database sql server 2008R2 from Microsoft Dynamics CRM 2011 which users need to view old data. I have been able to recreate searches for entries however have stumbled on one problem. 1 table contains documents/spreadsheets/messages/text etc stored as a varchar(max) with a filename and a mimetype. [MimeType] [nvarchar](256) NULL, [DocumentBody] [varchar](max) […] |
Adding report inputs to history by extension or js - Is there a way to add all queries/inputs you queried with to be added to the normal browser history so you can look through them the other day?? And go back and forward at anytime? |
SSRS 2012 |
Repeating Rectangle/Tablix - Hi there, I'm trying to enable a rectangle or tablix to repeat on every page i.e like an invoice but I don't want it to be in the header. Even when I set to repeat on pages to true it still won't repeat. Is there another way to do this? Thanks in advance Liam |
General |
What's been your most favorite/fun project you've worked on? - I'm looking for something fun to make. I love learning about all the intricacies of programming and how something was made like RCT2 or small programs that made you money without knowing it would. What's coolest thing you've programmed? |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |