|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
DBCC UPDATEUSAGE | |
What does DBCC UPDATEUSAGE 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 Migration Tool to Use Which migration tool is suited to assess my SQL Server data estate and lift and shift my estate to SQL Server on Azure VMs? Answer: Azure Migrate (online hub) Explanation: The Azure Migrate online portal is the place to lift and shift (and track) your migration of on-premise SQL Servers to Azure VMs. Ref: Compare SQL data migration tools - https://docs.microsoft.com/en-us/sql/sql-server/migrate/dma-azure-migrate-compare-migration-tools?view=sql-server-ver16 |
Featured Script |
Daniel Brink from SQLServerCentral Use DBCC CLONEDATABASE to make a Schema Only Database Backup
|
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 |
Unable to Communicate to SQL 2005 via Linked Server - Hi all, I'm having issues communicating via a linked server from a Windows 2019 Standard server running SQL 2017 Standard to a Windows 2003 R2 Enterprise server running SQL 2005 Standard. The operating system on the source server was just upgraded from Windows 2012 R2. Error: OLE DB provider "SQLNCLI11" for linked server "server" returned […] |
SQL Server 2016 - Administration |
Extended Events: using ATTENTION Event to log external apps timeouts. - The purpose I created the attached Session and one of the queries to view data and periodically reload it to the table WAS BECAUSE once in a couple of weeks we have had this nasty bottleneck in our environment when instead of an average of 40 or 50 timeouts (from ASP web pages/IIS) per day […] |
SQL Server 2016 - Development and T-SQL |
SQL convert Rows to columns - I have seen several posts on this many of which suggest Pivot. I am trying to mimic a MS Access report that used VBA to format the columns. I have been working on this for awhile and I am still no closer to solving it, here is the Problem. Some of my attempts have involved […] |
SQL Server 2019 - Administration |
SQL2019 Std Quantity License Keys and multiple backups servers - Hi All, I'm in need of knowing how many SQL2019 Standard license key I need in my scenario; I'm hoping someone could help so I'm compliant with Microsoft key usages. I'm not a SQL person, I'm the DB Admin but falls upon me to provide software to others. My server speck's: 4x HP DL360 G9s, […] |
SQL Server 2019 - Development |
Calculated column vs. Running Total column - I'm in discussion with my development team regarding the best way to model staff members taking annual leave. Rather than post a lot of DDL stuff it's easier to describe narratively. I personally think that the best way to model this is as follows. A table called StaffLeaveEntitlement, where a member of staff has their […] |
How to rename a Windows folder using TSQL - Hello, I need help to rename a folder name from 20220822, which is the current date to anything, "newdirname", for example. "C:\Test\20220822\" I would like to use a sql script. Or, if anyone knows how to get this done using PowerShell, I will appreciate feedback. Thanks |
How to make pivot for features dynamically based on feature name and feature val - sssss I work on sql server 2019 i can't make pivot for feature values based on feature name . i need to apply pivot dynamically because may be tomorrow add new features so it will depend on features on table . for original part id i have 4 features as ProgramMemoryOriginal,NumberCoresOriginal,NumberADCsOriginal,NumberDACsOriginal […] |
SQL Azure - Administration |
Azure Data Studio - SQL Profiler - save or export results to table - I can launch SQL profiler (Alt P) using Azure Data Studio and can see the system logs on the screen. However, when I stop the trace session on the screen, and change the [Select View] option on the top right, all the data that was collected initially gets lost. How to save the results of […] |
Azure Data Factory |
Question about data factory html request - Hello! We have used Logic apps to make http request to our clients system and retrieve xml data from it. Is it also possible to do on data factory? Flow is like that: Make http request --> request response body is xml data --> take that xml data and store it in blob storage as […] |
Reporting Services |
Subscriptions are 'disabled' and setting to enabled instantly revert to disabled - We have SSRS 2019, some of our subscriptions (across multiple reports) are currently 'disabled' and other subscriptions for same reports are ok so cannot see any commonality. If we via the browser mark the subscription as enabled, then refresh browser it is back in disabled mode. However if we 'edit' the subscription then simply click […] |
Ratio from Metrix - Hello Calculating ratio from metrix - or if you have other way of doing it please ratio is SUM of A for 2018 divided by SUM of B for 2018 multiplied by 100 for percentage purpose Please see attached file to see whats given and required 75 = ( 300/400)*100 Thanks |
General |
No experience with programming; how difficult is SQL for new prospect? - I'm looking at a career change. I have bachelors degree in healthcare management and pre counseling. My mental health is going down the drain and do not think I can sustain myself long term in the field of addiction. I was planning on going to grad school for counseling, but entry level data analyst positions […] |
MS Visual Basic OR MS Visual C# ?? - Hi everyone, So for some time now I have been learning SSIS and I have worked on various tasks and created some projects on it without using Script Task. What I have learned so far is that to achieve what I am trying to do via SSIS built-in tasks, I can get much better results […] |
Continuous Integration, Deployment, and Delivery |
CI/CD to deploy database using Gitlab - Hello, I want to do CI/CD do deploy database (sql server) and ssis package using Gitlab , but the problem i don't know how can i start and also i didn't fount any tuto on the internet. Can someone help me how can i start to do that ? and also if possible to do […] |
Integration Services |
Transfer SQL Table Data into Excel - Hi everyone, I have designed a SSIS package that transfers SQL table data into an excel file. I am fetching data via this query: /****** Script for SelectTopNRows command from SSMS ******/ SELECT CONVERT(NVARCHAR(4000),[LIST_TYPE]) AS LIST_TYPE ,CONVERT(NVARCHAR(4000),[LIST_CATEGORY]) AS LIST_CATEGORY ,CONVERT(NVARCHAR(4000),[LIST_SUBCATEGORY]) AS LIST_SUBCATEGORY ,CONVERT(NVARCHAR(4000),[LIST_DESCRIPTION]) AS LIST_DESCRIPTION ,CONVERT(NVARCHAR(4000),[LIST_VERSION]) AS LIST_VERSION ,CONVERT(NVARCHAR(4000),[T2_CODE]) AS T2_CODE ,CONVERT(NVARCHAR(4000),[T2_TYPE]) AS T2_TYPE ,CONVERT(NVARCHAR(4000),[T2_NAME]) […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |