Forum Widgets
Latest Discussions
ODBC drivers for Ubuntu 22.04
I recently installed Lubuntu 22.04 and following these https://docs.microsoft.com/it-it/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15#ubuntu18 to install the ODBC drivers but apparently MS hasn't packaged msodbcsql18 or 17 for this version. Any ETA for those to be released? Related question: https://askubuntu.com/questions/1407533/microsoft-odbc-v18-is-not-find-by-apt Thanks, CaldeiraG
Open reportserver webservice URL with https leads to an ERR_HTTP2_PROTOCOL_ERROR
We have installed on a Windows Server 2022 the latest version of PowerBI Reporting Server. We have bound a wild card certificate to the PBRS webservice and PBRS portal site. We have also added the FQDN cname to the PBRS reportingserver config file. We have used to deploy any reports by URL's like https://reports.contoso.com/ReportServer/Pages/ReportViewer.aspx?/Invoice/InvoiceReport. Opening with Microsoft Edge we get the error: Hmmm… can't reach this page It looks like the webpage at https://reports.contoso.com/ReportServer/Pages/ReportViewer.aspx?/Invoice/InvoiceReport might be having issues or it may have moved permanently to a new web address. ERR_HTTP2_PROTOCOL_ERROR On the other hand when opening the URL https://reports.contoso.com/Reports/Invoice/InvoiceReport we will be asked to login with the user credentials. Afterwards calling the webservice runs fine. Does anybody had already the same error and how we can avoid it?Creating a SQL Login with SQL Server Availability Groups
The issue The logins used in the databases included in an AG must share the same SID if you have SQL Server AlwaysOn, availability groups. How come? Let's investigate further... A row is added to the [syslogins] table in the [master] system database each time a user is created. Now, when you map a user to a database and begin adding roles to that database for the specific user principal, a row with the pertinent data is added to the [sysusers] user database table. The [syslogins] and [sysusers] tables are connected based on SID information. Tada!. You can query sys.database_principals to get a list of database principals. As shown below, we have similar SID’s for a login [SQLAg2User] and database user [SQLAg2user]. Environment information The SQL Server Always On Availability Groups for these two nodes have the following characteristics for the purposes of this article: Primary Replica: SQLNode1\INST1 Secondary Replica: SQLNode2\INST1 Database: [MyNewDB] The Solution Enters T-SQL: You create the login on the primary replica node with the following script or something like that, that fits your needs: -- Connect to the PRIMARY REPLICA node of the AG USE [master] GO -- Create the login CREATE LOGIN user1 WITH PASSWORD = N'aStrongPasswordHere'; If everything runs successfully you run the next to get the SID of the user: USE [master] GO -- Get the SID of the user createdSELECT [sid], [name] FROM [syslogins] WHERE [name] = 'user1'; GO Now, that you have the SID, switch the connection the secondary replica and execute the following query: -- Connect to the **SECONDARY** REPLICA node of the AG USE [master] GO CREATE LOGIN user1 WITH PASSWORD = N'useTheSamePassword', sid=<copy-paste the SID from above>; Now, you are ready to go back to your Primary Replica that has the databases you want to grant the rights for the user and do so freely. The next time your database fails over to the other node it will work without a problem. Just a side note: why Windows Authentication mode does not have this SID problem? Well, if you think about it, the SID is governed by one source: the Windows Active Directory.Download and install SQL Server on Linux in less than a minute.
Lead engineer, Travis Wright demonstrates SQL Server on Linux, including how you can: download and install SQL Server on a Linux Virtual Machine; run your SQL Server-based apps inside of Docker containers and improve the performance of your applications using powerful features such as Column Store in SQL Server.
SQL Server installer unable to download the required files
Dear Community, I wanted to install the developer edition, however, I keep getting this error message: "We failed to download the files we require. Please check your network connection and try again." My network connection is working fine; however, my local disk is almost full. If that's the reason the installer is failing, is it possible to force it to download to another disk? Thanks.BACPAC: Could not import package. SQL72012
Hi SQL-guys, I'm running into this error during the last days and could not find a solution: I am trying to import a database .BACPAC file from SQL Azure into my local SQL Server. When doing so, I get this error on my local machine: Could not import package. Warning SQL72012: The object [mydb_Data] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box. Warning SQL72012: The object [mydb_Log] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box. I found this post (among with others...): https://www.sqlservercentral.com/Forums/PrintTopic1886371.aspx sp_configure 'contained database authentication', 1; GO RECONFIGURE; GO Interestingly, this reconfiguration worked once some days ago with another database. But now, I'm stuck, it doesn't work for me. [ I even installed the latest version of SQL Server Management Studio (SSMS) 17.2 from https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms but without success. ] Tips anyone? thx! ToniModernize on SQL Server 2019 Q & A [PASS DBA Fundamentals VG Webinar]
Hi Folks! Thank you so much to those of you who attended yesterday's webinar Modernize on SQL Server 2019! We did not have time for Q&A, so I've collected the questions and answers here. Feel free to comment with any additional questions you may have and I'll be happy to answer them. What is the link to your site? Most everything we present can be found at https://aka.ms/tigertoolbox You can find all our presentations and demos under the "Sessions" folder, as well as other useful tools and scripts. You can also find our blog at https://aka.ms/sqlserverteam, or by clicking on "Blogs" here on the TechCommunity site. Is there a timeline for the Common Criteria [security settings] to be released to 3rd parties so that they can independently certify SQL2019 from a security standpoint? We are still awaiting the release of these for SQL2017....after years of availability. There isn't a specific timeline for this, but it will be completed as soon as possible. SQL 2017 certification was delayed due to defects that needed to be corrected as well as some documentation issues. Currently the Microsoft provided SQL maintenance plans do not have settings for online, pause-able index maintenance. With the new capabilities being advertised, will these make it into maintenance plans? No plans for this. We generally recommend using some sort of smart script such as Adaptive Index Defrag (https://aka.ms/aid), for maintenance rather than a standard maintenance plan. For Azure SQL as a service can the database compatibility be set to 150 to get some of the 2019 features? Yes, you can choose compatibility 150 now! It is not yet the default, but it is an option.Can not able to import Excel File into SQL
Hi Team, I mostly working with Excel. Some of excel files having large amount of data (Eg. Around 8 lakh rows and 52 Columns) For getting some results, excel is hanging or taking more time and more functions. But SQL is very fine to get results within seconds. Problem is while importing excel file (Ver. 2007) it shows an error (Please find attached file) But, It allows to import excel file of 97-2003 file format. i.e xls. For getting result, i am saving "xlsx" file into multiple "xls" files (Coz, xls having 65536 rows only) Single "Xlsx" file of 8 lakh records saved as 16 "Xls" files contains 50000 records per file. And importing them into MS SQL Server. Solve this.
SSMS "Intellisense" behaviour is driving me demented
This behaviour is doing my head in and I'm hoping that there is a simple way to change it?Just to give you an example, I am starting to write a little query to check the status of FullText Indexes on database objects. This is for illustration purposes only so don't tell me what "better" alternatives there are for doing this, I just want to illustrate the behaviour that's bugging me.So the query I would like to run is:SELECT [SO].[name], [FI].[is_enabled] FROM sys.objects [SO] inner join sys.fulltext_indexes [FI] on [FI].object_id = [SO].object_idThe behaviour that annoys me can be illustrated as follows. In SSMS, type this:SELECT * FROM sys.objects [SO] inner join sys.fulltext_indexes [FI] on [FI].object_id = [SO].object_idThen go back to the *, remove it and start typing [SO] in order to get intellisense to show you column names you can choose from. So you have typed [SO] and your cursor is right behind the closing bracket:SELECT [SO]<cursor here> FROM sys.objects [SO] inner join sys.fulltext_indexes [FI] on [FI].object_id = [SO].object_id Type the dot The statement changes to:SELECT [SOUNDEX]. FROM sys.objects [SO] inner join sys.fulltext_indexes [FI] on [FI].object_id = [SO].object_idI didn't want "soundex". I wanted intellisense to show me a list of column names in sys.objects, aliased to "[SO]" by me. It does that once I hit Ctrl+Z which removes the auto-inserted [SOUNDEX] and then when I hit the dot again it shows me the list of columns. So I pick [name] and start adding the next column by typing , [FI]. And here it goes again:SELECT [SO].[name], [FILE_ID]. FROM sys.objects [SO] inner join sys.fulltext_indexes [FI] on [FI].object_id = [SO].object_idI didn't want [FILE_ID]. I wanted [FI]. and a popup showing the the column names in sys.fulltext_indexes I can choose from.Sure, this is one heck of a "first world problem" but as a touch typist this is driving me around the bend. If there's a way to change this behaviour (without losing Intellisense altogether), please tell me how.
