Laden...
|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Finding Keys | |
I am using Always Encrypted in SQL Server 2019. I have a symmetric key for the key that is used to actually encrypt the data. Which DMV stores the metadata about this key? | |
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) |
Debugging a PowerShell Function I have this test function for debugging. My default value for $DebugPreference is SilentlyContinue. function Test-Debug { [CmdletBinding()] param($a) Write-Debug ('$DebugPreference is ' + $DebugPreference) Write-Host ('Default: ' + $DebugPreference) }If I load this into my environment and execute it, what two values are returned for the $DebugPreference variable when I execute it like this? Test-Debug 12 -Debug Write-Host ('Default: ' + $DebugPreference)Answer: Inquire and SilentlyContinue Explanation: In this case, the Debug parameter changes the $DebugPreference inside the function to Inquire. When the function ends, this returns to the value previously set, which is the default. Ref: About_Preference_Variables - https://docs.microsoft.com/en-us/powershell/module/Microsoft.PowerShell.Core/About/about_Preference_Variables?view=powershell-7.1 |
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 2016 - Administration |
SSRS Query Designer times out - Hello experts, I am getting the following error when trying to open the Query Designer for the a report Dataset in Report Builder. The report runs successfully in the browser and in Report Builder. And the data sources for the report validate successfully. I also checked for TLS issues, but the report server is correctly […] |
Error 17311 while trying to run query with OPENDATASOURCE - SQL Server 2016 SP2 terminates suddenly with the error id 17311. Here's the SQL dump error: 2021-06-27 10:32:05.29 spid63 SqlDumpExceptionHandler: Process 63 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 2021-06-27 10:32:05.29 spid63 * ******************************************************************************* 2021-06-27 10:32:05.29 spid63 * 2021-06-27 10:32:05.29 spid63 * BEGIN STACK DUMP: 2021-06-27 10:32:05.29 spid63 * 06/27/21 10:32:05 […] |
SQL Backup/Restore - Hi, Production database : I have a database Backup size is 300 GB from production server. Total size of hard disk is 1 TR in Production. Test environment: I want to restore a database in test, not all the tables from backup mdf. , i need only 50 GB data, from the database backup. Total […] |
SQL Server 2016 - Development and T-SQL |
Unable to create USER with T-SQL - Hello Community, Can someone explain why I'm getting the error Incorrect syntax near '-' When I run the followng sql code: CREATE USER DT-SERVICES-TEST WITHOUT LOGIN; My guess is because of the hypen '-' If that is the case, can someone let me know how to add the code with the hypen? Thanks |
sp_server_diagnostics_sleep - Hi, we are trying to bulk write the data in the table. but the process seems to get slow. On checking the wait type, i found continuous records of sp_server_diagnostics_sleep. Couldn't find the real reason for the latency of bulk insert in the table. Kindly help Saumik Vora |
Need to get records based on Sub Query - I have written the query using ranking function. I tried to write the same query using sub query no clue. Can any body help The query below as follows WITH HighRecords AS ( SELECT BusinessEntityID, FirstName, MiddleName, LastName, TotalDue, ROW_NUMBER() OVER(PARTITION BY BusinessEntityId ORDER BY TotalDue ASC) AS RN FROM Person.Person Pp INNER JOIN Sales.Customer […] |
Trouble filling missing months of data with zero values - Hello, Hopefully someone can help a novice with the following problem i have. We have as system that records monthly reported figures and for several accounts, quite often the sites don't report their figures. So for a 12 month period there can often be gaps. I would like to show all months in a result […] |
Administration - SQL Server 2014 |
Unable to connect to SQL Server instance - I just created 2 named instances on 2 different server. Created firewall rules, enabled TCP/IP, made sure SQL Browser was running, both instances are running under default acct. I am able to connect to 1 named instance thru SSMS from my local machine and not to the other. I am also able to ping both […] |
Development - SQL Server 2014 |
SQL Server 2014 Developer Edition - Hi, Can we use SQL SERVER 2014 Developer free Edition for UAT environment. Please help me. Thanks, Carmelo Labadie |
SQL Server 2012 - T-SQL |
Cursor replacement suggestions - I have a process that uses SqlAgent jobs to process data coming from many sources, and I'm seeing performance issues trying to process the data. Looking for suggestions on processing of the data table. I have a single SP currently processing from the table and it has a parm of equip_id so I break the […] |
SQL Server 2019 - Administration |
Who Update the Stored procedure Last time? - Hello EveryOne, Need your help once again. I have lots of Stored PRocedures in my Database and we are 3 sql dba/developer . But need to know who updated the stored procedure last time? or by whom the stored procedure was updated last time?? Any Help or suggestion would be appriciated. Thanks in advance. |
SQL Server 2019 - Development |
transposing date column to rows - Hello people, I am trying to transpose date column to rows. I am not sure if this can be done for more than 10000+ rows. For example, I am trying to convert the table in image 1 to image 2. Please note that the below is just a example extract of the data , the […] |
Splitting adhoc queries into a data structure - Issue - Current adhoc SQL can be generated by our reporting module that is difficult to maintain much less decipher. The TSQL is huge and almost un-manageable. This makes it extremely hard to figure out what to do since we can have hundreds of queries Partial solution - instead of using profiler we have a […] |
SQL Azure - Administration |
Backup/recovery using native Azure tools - Hello, Hopefully someone who manages and administers hundreds of SQL Server VM's in Azure can share their experience. We have a few dozen SQL Server VM's in Azure and a small handful of managed instances. One of the issues we run into is the lack of visibility into backup failures, as well as being able […] |
Powershell |
load xls file to sql - Looking for a script to load xls files to SQL without using dbatools or a Driver that's need to be loaded... Is there any Native loads of xls to SQL using PS script? I've been trying to use a script that converts cls to csv, but I run into issues on fields where the delimter […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Laden...
Laden...
© 2024