| Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2016 - Administration |
| Connection options to encrypted servers. - I've applied certificates and enforced encryption on two SQL 2016 SP2 servers. Using the same login credentials I can create an encrypted connection to one of the servers by selecting 'encrypt connection' in the connections options. With the second server unless I also select 'trust server certificate' I get a connection error: A connection was […] |
| Disable Download button SSRS2016 (RC3) ?. - Hello, I'm testing the Reporting Server 2016 RC3 in the top row of the page http://server /reports you see right of the settings button , the Download button. ( see attachment ) Is it possible to disable this download button? thanks jackyjoy |
| SQL Server 2016 - Development and T-SQL |
| Parsing an XML field within a table - I am trying to parse a field that is XML in a table and insert into a table. Where would be a good example to do this> I have attached the values from that field in a notepad++ file. |
| Sequencing query - Hello, I have a query regarding the best way to deal with a sequencing problem. This may be a little hard to explain. I have the following data (table and data script attached) where I need to regroup the depths columns by 1 foot increments and join the corresponding data which falls within […] |
| Debugging with VS setting breakpoints - Ok i under stand how to debug with VS, my Question is this. I have an update statement which fires a trigger which in turn fires a stored proc which in turn fires more store procs.... (I did not right this process it was done by a third party.) The question is i have a […] |
| Administration - SQL Server 2014 |
| removing database from AG and putting it back in - Lets say a database was removed from AG for maintenance purpose. The primary node would have the w/r copy of it and secondary would have it in restoring state. What would be the best way to put it back in the AG again after maintenance? From primary --> add to AG and then join? |
| Development - SQL Server 2014 |
| get Actual backup file name from the sql backup path - Hey everyone, sorry, i am trying to get the actual file name accurately from the path, what i currently have is: E:\Backup\Server1\Database1\Database1_131983519013.bak and want to get just: Database1_131983519013.bak trying to use trim or left etc. but finding it difficult as some other database names might be longer or shorter, so its random, any idea how […] |
| SQL Server 2019 - Administration |
| SQL server for an oracle developer/dba - I have a few years experience developing with oracle and have now moved to a place where they use SQL server (2005). Where would be a good place to learn things like SQL Server query optimization, basic dba stuff and sql server gotchas for someone with my background. |
| HA solution using mixed SQL Server on-prem and Azure SQL Server - trying to come up with an architecture for HA. I was thinking of using our on-prem SQL Server as primary, with Azure as secondaries. IT has mandated that putting everything in Azure is too costly, and we wanted to come up with a geo-replicated solution as our customers are all over the place. Does anyone […] |
| Retrieve data from First 25 and last 25 data pages from the Database - I have received a very strange and unusual request from one of our departments to provide them the data for first 25 and last 25 pages of the database since they would like to copyright that data. My argument is that database is made up of multiple objects like tables, stored procedures, functions etc which […] |
| SQL Server 2019 - Development |
| Server is fast, then slow, then fast with no pattern - I am having a problem with my sql server running queries and using it in Visual Basic. The primary table I pull data from has 24 columns with 76,000 rows. Sometimes it takes less than 6 seconds to run the query. Other times, it takes over two minutes and once in a while, it stops […] |
| Reporting Services |
| Add more space below report totals - Hello, First off I am sorry if I'm posting this in the wrong area. I hope I'm not I've search endlessly to try and find this answer. Even on here. Probably using the wrong words. How can I add more space below the bottom of my reports. When I run the report, I need […] |
| Integration Services |
| save mutiple ssrs reports from a ForEach loop into a single file - Hello, I have a client who has a letter run that is produced monthly using a combination of SSIS and SSRS. In short, a foreach loop passes the parameter intothe ssrs report and usinga C# script task generates a PDF into a windows folder. They are asking if I can alter the process so that […] |
| Design Ideas and Questions |
| SQL newbie, question about primary key. - Hello, SQL newbie here. I've got a question about the proper use of primary keys, hoping someone can help out. Let's say I establish an HR database and decide that, since Social Security numbers are unique and non-repeating, I'm gong to use SS numbers as my primary key. Something like this: Name, Title, Social_Security_Number Joe […] |
| The Future of Community |
| Is there room for independent SQL or Data Integration based User Groups? - So I live in a smaller community with no real User Group presence of any kind, and though when SQL Saturday events were still in person the nearest one near me is 2 hours drive. Now during pandemic I doubt we'll see any return anytime soon, so I was wondering if there's room to try […] |
