|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Changing the DMK Password | |
I have a database on one of my SQL Server 2017 instances with a Database Master Key (DMK). I do not know the password, as someone else created this. How do I reset this password? | |
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) |
COUNTROWS() I am exploring the use of the COUNTROWS() function in DAX. Which of these is true about the function? Answer: This counts the rows in a table or the table result from an expression Explanation: COUNTROWS() works on a table or table result of an expression. Ref: COUNTROWS( ) - https://docs.microsoft.com/en-us/dax/countrows-function-dax |
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 |
Search All Tables for a specific Value & return the location - Hi Forum, I need to find a Value in a database and have seen some useful code to do this. The only thig is there's littl explanation on how to use it or how it works. Note this helpful link HOW TO FIND A VALUE IN ALL COLUMN OF ALL TABLE IN A db. My […] |
SQL Server 2016 - Administration |
replication error - we configured transactional replication with account as sql user having sysadmin on sql , but when we tried to run the job getting error Step 1 failedreason: The LogReader subsystem failed to load [see the SQLAGENT.OUT file for details]; The job has been suspended). The step failed.' How to slove this error ? |
Windows update on Virtual SQL Server 2016. - We have a Virtual Server with Windows Server 2012 & SQL 2016 installed on it. When we restart the server to apply windows updates we find that we get logged off the rdp session but the server is still available as it is being monitored via SentryOne, during this time we receive reply on ping. […] |
SQL Server 2016 - Development and T-SQL |
Self join / row_number() partition number generation based multiple status - Thanks in Advance:) Whenever there is a change in Status or Comment for name_id then we need to consider that record Attached sample data excel with output Table1 data |
SSIS Implementation - Hi We would like to implement SSIS Jobs in our new environment for the Data Loading. I am little new to the Environment/capacity planning. So I would need suggestions on how I can implement it. I am aware of the Package creation. Our task here is to load data from CSV/Excel files into Database tables. […] |
Network timeout issue with sqlcmd from Linux - Hello experts, Some clients are testing a sqlcmd statement from a Linux host that is trying to run code in a SQL Server database on a Windows host. However, they are using the option -D (uppercase 'D'), which I do not see listed in the documentation for the Windows sqlcmd utility. Their goal is to […] |
SQL Server 2012 - T-SQL |
An issue with an encrription function - Hi, I am trying to get a Microsoft function to work with a variable. Below as you can see I am using the encryptByPassPhrase function. If I put the number in quotes as shown in the first code shown it works great. However, I would like to use a variable, as in the 2nd one, […] |
SQL Server 2019 - Development |
Using result of previous function call in SQL Server... or any better idea - I use a recursive CTE ;WITH cte ( -- anchor UNION ALL -- recursive parte ) SELECT * INTO #ReservaREBAtivos FROM cte OPTION(MAXRECURSION 0);? to get this sample rowset then I use the following query to return the data from the temp table create: SELECT Chave ,Ano ,Idade ,qx ,qy ,qxi ,ix ,vx ,vx_pec […] |
How to get column names in the row wise along with their values - |
nvarchar - int comparisions - I have an nvarchar column size which has values like 1200 MB How do I compare in a where clause : where size > 1000 in a select clause and get the relevant results Cannot redefine column to int or any other datatype. Thanks |
How can I determine relationships or dependencies between tables or queries? - Hello everybody I have inherited a very large database with really many tables, queries and countless stored procedures (SP). There is also no ER model created. Tables and queries are used in SP and are related to each other. And now my question: How can I determine relationships or dependencies between tables or queries? Or […] |
SQL Server 2008 - General |
Memory Pressure alleviate with proper indexing ? - Dear friends: SQL Server physical machine, critical services, overloaded with several requests, some partitioned tables, although non aligned indexes exist, other indexes appears that are not wiseley choosen, my question is how indexing could help alleviate memory pressure counters or make worst the problem. Thanks for your help and ideas |
How to prevent access with TDE ... one user wants to access on the fly. - if we want ensure no one else access database and only app user can get connect. Please suggest options to use on the fly / network along with data need to encrypt..... |
Integration Services |
Export dtx package but doesnt work on SQL Agent - Hello, So I am trying to get this simple SSIS package to work on SSISDB, it has 1 variable called SheetName, a foreach loop, and within the foreach loop has a data flow task and the foreach loop is using ado.net schema rowset Enumerator. The purpose of this is to get an excel file from […] |
COVID-19 Pandemic |
Daily Coping 11 May 2020 - Today’s tip is tell someone about why your favorite music means a lot to you. My thoughts: http://voiceofthedba.com/2020/05/11/daily-coping-11-may-2020/ |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |