| Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2016 - Administration |
| SQL Server 2016 SP1 to SP2 - We are currently on SQL server SP1. Should we go ahead and apply SP2? What are your recommendations? Do you think it is critical that if we do not apply this updates are we are not having any issues with SP1? Thank you, |
| SQL Server 2016 - Development and T-SQL |
| SQL2016 to Access2016 Linked server issue - Hi all We've got an issue with a linked server to an Access database. The general gist is we need the Access database for a file submission that we have to make. The linked server itself is fine but, when I try and write data to it via code, I get the […] |
| Datawarehouse question - So I have one dimension table and a fact table. dimension table has surrogatekey, fiscalyear and businessplan attributes. (Fiscalyear=2021) fact table has invoice level facts and businessplan surrogate key in there, which works fine. Now, business has additional requirements. They want to come up new business plan for new fiscal year (2022). This new year […] |
| Getting sum of all transactions by month-end - I have a table that is a list of inventory transactions. For simplicity sake, the table has these columns: Location, Item Number, Trx Date, Trx Amount I'm trying to create a query that gets the accumulation of all transactions for each month in a year. For example, let's assume these transactions: I'm trying to create […] |
| Administration - SQL Server 2014 |
| Enabling/Configuring Read only routing - I have 2 servers which are part of AG. DB1(Primary) and DB2(Secondary). It has been setup like this for quite some time now but we don't have read routing enabled/configured. I went thru GUI and scripted out what I want to do. Couple of question related to my inquiry. Do I have to failover/reboot when […] |
| SQL 2012 - General |
| Implementing TLS In sql server 2012 - Hi Experts, In my project we have 2 servers Webserver and one is database server . We are planning to Implement the TLS in the database server and our DBA can handle the the step to implement TLS on the database server. My query is what all changes we have to do on the Webserver […] |
| Can we use SSIS dynamically import or export from one table to another table? - Normally, we can use selected databasename--tasks--import data/export data to handle data import and data export rapidly, but this operation is required to be done manully, Can we use SSIS dynamically import or export from one table to another table? such as creating a job in backend to call it as the schedule or call the […] |
| SQL Server 2019 - Administration |
| SQL server 2019 reporting need help - Hello sql server reporting 2019, i created temp for 180 days and not sure what to do next, I need to do the following: create a folder for reports for reporting services server. 2.create the report. We want to generate a reporting services web page where you display the contents of the table and create […] |
| Changing Data Drive Allocation Unit Size on Existing Installation - I have an existing SQL Server 2019 Standard installation that includes SSRS. The setup is fairly typical and the databases are relatively small at this point. There is a C drive and two additional local drives; one for data files and one for backups. The data drive was formatted for 4K and I'd like to […] |
| Unable to uninstall Sql Server 2019 in my Laptop - Hello, I have installed Sql Server 2019 more than 6 months before and forgot the credentials. So I tried uninstalling manually but it is not allowing me to uninstall. Even the services are not starting in Services.msc and Sql Configuration Manager. Not sure what is the issue. Attached the screenshots of the same. I tried […] |
| Grant Execute on ALL procs in a Database - I see a lot of old, 10+ year old posts for SQL 2000, 2005 etc on this. For our SQL 2019 environment, what is the easiest most efficient way to: GRANT EXECUTE on ALL StoredProcedures in DB_XYZ to MyDomainUser (eg. MyDomain\User_1) thx for any feedback! |
| SQL Server 2019 - Development |
| Cant cast VARCHAR(MAX) To XML Variable - Hi there I would like to cast a NVARCHAR(MAX) variable string to an XML variable as follows: declare @DataSheetXML NVARCHAR(MAX) = 'supports_alarmsTruealarmsTinylikesupports_min_maxFalselocally_latched_alarmsFalsesupports_startFalsesupports_suspend_when_fullFalsertcinternalhas_radioTrueunicode_descriptionsTrueminimum_interval120host_battery_alert_functionbattery_alertmemory_size1146880pt1000_reference_resistor1831.1688311688313device_descriptionTinytag Ultra2 Radio Receiveris_basestationTruememory_size32768config_hz1024delay_hz1max_delay315360000outputs_signed_encodingTruehas_32_bit_addressesTruehas_bc_start_new_sessionTrueserviceserviceambientserviceinstrumentationinstrumentationtesttesttesttesttesttesttesttesttesttesttest01thrhinstrumentationambienttestserviceloaded_vrefswitched120false0vrefswitched120false0bat_chk120twelve_bit_rawfalse0temperature120false0RadioStats_00160false0Radio' declare @xml xml Set @xml = cast(@DataSheetXML as XML) However I am getting the following error: Msg 9400, Level 16, State 1, Line 6 XML parsing: line 1, […] |
| Powershell |
| Pipeline Variables - Hi All I am trying to understand why my filtering doesn't work here.... I am new to Powershell Using dbatools This works: $t = get-dbaregserver $t | Where-Object {$_.group -eq "GroupName"} This does not filter the result: $p = get-dbaregserver $p | Where-Object {$p.group -eq "GroupName"} |
| The Future of Community |
| Future of SQL Server - I am becoming a little disconcerted by the lack of news about the next version of SQL Server as well as the continual bombardment of all things Azure from Microsoft. Microsoft is pushing Azure hard. The subscription model via the Cloud is the future. For Adobe customers it is already the present. Now, logically, I […] |
| Administration |
| Changing Data Drive Allocation Unit Size on Existing Installation - I have an existing SQL Server 2019 Standard installation that includes SSRS. The setup is fairly typical and the databases are relatively small at this point. There is a C drive and two additional local drives; one for data files and one for backups. The data drive was formatted for 4K and I'd like to […] |
