Laden...
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
The AG Synchronous Replicas | |
In a SQL Server 2022 Enterprise Edition AG, how many replicas can be configured with synchronous commit mode? | |
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) |
Counting Bits What does the BIT_COUNT function do in SQL Server? Answer: This returns the number of 1s in a binary version of a number Explanation: This function returns the number of bits set to 1 in the binary representation of a number. Ref: BIT_COUNT - https://learn.microsoft.com/en-us/sql/t-sql/functions/bit-count-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 - Development |
Symmetric Key EncryptByKey returns NULL value - I haven't used column level encryption because usually the vendors I deal with have .dlls to do that work. But now I have a dev working on this and having issues in one specific environment. Because the code works in the other environments, I feel like the issue is more about something missed in Symmetric […] |
SQL Server 2016 - Administration |
SQL Clustered Resource in online pending for about 3-5 mins before coming online - Hello! SQL Clustered resource used to come online during manual or automatic failover in less than a minute but now it is taking about 3-5 mins. What could be causing it? Thanks in advance. |
SQL Server 2019 - Administration |
PK violation in replication but only one subscriber - We have a publication with three subscribers; it's basically a part list with around 1.2 million rows. The local table is on a SQL Server 2019 instance, and is updated nightly via a MERGE statement from a larger part list. This table and several smaller ones are replicated via Transactional Replication to three different Azure […] |
orphaned users in sys.sysusers - Hi everybody, we got 2 entries in this table [myDatabase].[sys].[sysusers] Is there a possibility to delete those entries? With DELETE ... we got this error: "Msg 259, Level 16, State 1, Line 4 Ad hoc updates to system catalogs are not allowed." And further it is not possible with the reconfigure option. Thanks Kind regards, […] |
SQL Server 2019 - Development |
SQL Query to use in MS SSRS server to give you your report structure. - Code that can be used in order to create dashboard or SSRS report on report statuses based on Report Structure that can be used to be filtered. /* Created By: wolfsvein Create Date: 2025-01-17 Details: Used to see distinct list of Report Folder Structure. Revisions: Version By Notes 1.0 wolfsvein Created */ SET TRANSACTION […] |
Temp table security - So, I have an interesting situation that I need a double-check on. One of my coworkers (who is no longer at the company so I can't ask him) advised some users on a PII security situation that doesn't quite make sense to me. App team creates global temp table for a job that does "stuff" […] |
TDE for multiple databases and severs - We are self hosting sql servers, we are not using Azure for sql servers. and we would like to do encryption on data that is at rest for multiple sql servers that has multiple databases. I understand using TDE includes Encryption for data files and backup files. My question is since we have multiple servers […] |
Azure Data Factory |
Sending SQL Query Result via an Email in ADF - New to Azure Data Factory, and as a starting point, we're trying to see if we can use it to to run some of the menial tasks. We have a couple of SSIS jobs that we'd like to get rid of and ADF is being pushed as a likely replacement. One such task requires it […] |
Powershell |
search text files for multiple keywords - How can I modify this script to do a couple more features. 1) process only the most current file from the folder. 2) if I find 4 occurrences of the word FULL in that most recent file .. then issue an email many thanks to the people in this forum. # Define the path to […] |
Integration Services |
Replace OLEDB source editor task with a powershell script - I want to replace all the oledb source editors as shown below with powershell script tasks that execute sql queries. Please give me some inputs on how to construct the powershell script so that it will a replacement for all the oledb source editor task so the powershell script could be something like below […] |
How create a Google bigquery connection manager in SSIS - Hi So I have created a system dsn to google bigquery data warehouse. However I am not able to figure out how to add a connection manager in the ssis canvas using this Datasource? Can someone guide on the bigquery connection |
SQL Server 2022 - Administration |
Recovery Takes 10-20 mins with ADR enabled - Hi Experts, I have database about 300GB in size with ADR enabled but after every failover\restart it takes about 10-20 minutes to come online. The database have multiple files and the tables are all partitioned. Can anyone shed some light on this ? CREATE DATABASE [LogsDB] CONTAINMENT = NONE ON PRIMARY ( NAME = […] |
Searching a Form (using "Find") after an Access to SQL Migration - I have completed a successful migration of an access database to SQL Express. Most things work fine in Access except when in a "Form" and using "Find" (CTRL+F) in a field & doing a search. It takes forever (over 5 mins) & in some cases crashes the database totally. Is all the users need to […] |
AlwaysOn Standard o Enterprise edition - Hi everyone, I need advice from the experts, this is the structure I created for testing and it works wonderfully: AWS Balancer that serves 2 Windows server instances (on 2 different datacenters) -Server 1 EC2 c5.2xlarge with our application + SQL Server Evaluation. -Server 2 EC2 c5.2xlarge with our application + SQL Server Evaluation. the […] |
SQL Server 2022 - Development |
Problem with the dll (version 1.2) of an Extended Stored Procedure with SQL Serv - SQL Server 2022 16.0.4165.4 Windows Server 2022 Datacenter 21H2 20348.2849 Our Extended Stored Procedure works 95% but it occasionally generates overflow errors (BEX64) in the Windows event log. In the Event Viewer we have an Information Event 1001 from Windows Error Reporting (Event name BEX64 and SQLException64). What's strange is that this indicates that there […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. [email protected] |
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Laden...
Laden...