Recent 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, CaldeiraGSQL Server Certifications
Recently, I have spoken at several user groups and/or SQL Saturday events on SQL Server Certifications. I have posted my powerpoint presentation below. But I thought I would give a quick overview. First you will need to start by earning one of the four eight MCSA cerfitications. You have the classic MCSA: SQL Server 2012/2014 certification which has been available for several years. Or, you could obtain one of the newer SQL Server 2016 MCSA certifications in either Database Development, Database Administration, or BI Development. (Four new SQL Certification introduced in Spring 2017 are listed at the bottom of this post.) I really like the new streamlined 2016 certifications because you can focus on your area of expertise and you only need two exams. With the SQL Server 2012, you needed a broader knowledge base to earn the MCSA certification. I for one had difficulty with the 70-463 exam as I do not work with Data Warehousing on a regular basis, but I had to learn that material for the exam. If you still want to demonstrate your breadth of knowledge, there is nothing to stop you from earning more than one MCSA. Once you have earned your MCSA, it is now even easier to earn you MCSE. You only need to take ONE of the exams from the electives listed in the next picture to obtain an MCSE. What is even better is that your MCSE no longer expires. However, you can re-earn the MCSE by taking an additional elective exam in subsequent years. I really like this option, because in years past I would need to study older material to renew my MCSE. Now, I can learn new skills for new exams each year while I re-earn my MCSE. UPDATE: (March 22, 2017) You can now retake an exam that you have already passed to re-earn your MCSE certification, however you must wait at least 365 days from when you passed the exam before being allowed to take the exam again. You can still earn the two older MCSE certifications (Database Developer or BI Developer) until March 31, 2017. After that only the MCSE: Data Management & Analytics will be available. Don't forget that once you pass an exam or obtain a certification, head over to the Acclaim website to pick up your shiny, new badge that you can use on social media to show your freinds, family, and co-workers. UPDATE: (April 12, 2017) Four new MCSA certifications were announced today. (Update May 23, 2017) Names of new MCSA certifications have changed.Meet SQL Server’s biggest fan, KillaDBA
Atlanta-based Homer McEwen has been a database administrator for more than 20 years. But it’s what he does in his spare time that makes McEwen, aka KillaDBA, a little different. The husband and father of three writes and records songs about SQL Server, the platform that helps power the travel company he works for. We sat down with KillaDBA and learned about everything from his top musical influences to his reaction when he found out he’d be performing at SQL Saturday in Redmond on April 15. After talking with him and hearing his music, even we’re seeing SQL Server in a whole new light. Give it a listen. See the full interview here.
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.Free SQL Training - Indianapolis
That's right, I said FREE! You're invited to a free, one day technical conference for SQL Server professionals. The user community for SQL Server is extremely passionate and have developed a contagious set of one day events around the world with the support of the national level user group association, PASS. The local user group of IndyPASS is bringing this event to Indianapolis! Join us for a full day of technical classes performed by world class speakers! They volunteer their time to bring their infectious enthusiasm for SQL Server and the SQL Server community here to share with you! We will have many technical and professional development tracks and sessions to choose from all day long so you can get the most out of the day. There are also many opportunities to network with fellow IT professionals in the area and become involved in the community. Saturday August 12, 2017 Ivy Tech Noblesville 300 N 17th St Indianapolis, IN 46060 You can register online at https://www.sqlsaturday.com/629/registernow.aspx. We will have a catered lunch on site for those interested for a $12 charge. You can pay this fee at registration. You are also welcome to bring your own lunch or step out to grab your own. We look forward to hopefully seeing you at SQLSaturday #629. Feel free to share news of this event with anyone you feel would like to attend. If you have any questions feel free to contact the Event Admins at sqlsaturday629@sqlsaturday.com. This event is provided through sponsorships. If you or anyone you know might be interested in sponsoring this event please share this with them. You can find more information at http://www.sqlsaturday.com/629/Sponsors/SponsorPlan.aspx. Thank You, Team SQLSaturday Follow this event on Twitter with hashtag #sqlsatindy, and get news on this event and network with attendees!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.SQL Server Professional Career Profile - Jaap Brasser
We just featured a career profile of MVP JaapBrasser who focuses on Powershell, Active Directory, SQL Server, Windows Server and many other technologies. If you're interested on his take on what a successful career in the cloud looks like, read the post in the IT Resources & Training community here: https://techcommunity.microsoft.com/t5/IT-Resources-Training/Cloud-Careers-Friday-Feature-Jaap-Brasser/m-p/54236#M84March Member Madness Contest!
Think you can provide some fantastic content this month, or be the most active community member? We have some extra incentive for you in our March Member Madness contest, where you can win one of 15 pairs of Bose Noise Cancelling Headphones! The winners will be the top 5 members in the community in three categories: Most Posts, Most Likes Given, and Most Likes Received. I’m excited to see the contributions from the SQL Server community, and hope to spark insightful dialogue around SQL Server and Microsoft Cloud. For more information, check out the post on Community Announcements
Using Azure as an HA/DR site for SQL 2016
I wonder if anyone has dabbled with this concept, or if it is economically viable to my customer, which is a "little big shop" that would like to spend $-- for SQL HA and/or DR (probably the latter is the only realistic cost-effective approach across data centers that feature geodiversity). So I'd like to have 3 on-premises instances replicate Async say 3-4x/day (RPO=6-8 hrs) to either IAAS instances that power on the same 3-4x/day to receive replication, or, if SQL Azure supports AlwaysOn, use that for a "target." Idea would be to use this as a read only DR site in use cases ranging from extended power outages to cratered HQ. Anything in this scheme that might work with reasonably limited engineering effort? I don't want to add a ton of complexity or cost. Any ideas or suggestions for reading will be appreciated.
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.
Instalation problem SQLServer 2019/2022 on Win11Pro
Hi everyone, I'm writing here for the first time because I ran out of ideas. I had a working SQLServer Express 2019 (CU13) on Win10Pro machine. For educational and development purposes, local instalation, nothinng special. Recently, I upgraded Win10Pro to Win11Pro. The SQLServer service stopped working immediately. I tried everything to start the service but no luck. The next thing I tried was uninstall SQLServer2019 and install new one (2022 and 2019, same thing). At the end of the instalation, both give me the same error: TITLE: Microsoft SQL Server 2022 Setup ------------------------------ The following error has occurred: The filename, directory name, or volume label syntax is incorrect. Error code: 0x84BB0001 I searched all over the Internet and tried: Uninstall SQLServer and all components, delete all folders related with SQLServer Clean the registry keys and values related to SQLServer manually and check with CCleaner Check fsutil fsinfo sectorinfo C:, and it is fine (512/4096) Tried sfc, d*ism, chkdsk - all ok Download new ISO installation (2022 and 2019), mount setup.exe - Run as Administrator Disable firewall, antivirus, Defender Tried installing under the default directory name and the short one, changed instance name Create new local admin user and install under the new user Nothing helps. The error is the same whatever I do or install 2019 or 2022 version. Checked error log - can't find anything to guide me to the solution. Checked Global Rules - it's fine The SSD that I have is (the same SSD as on Win10 where everything worked): SCSI\DiskNVMe____SAMSUNG_MZALQ512HBLU-00BL27L2QFXM7 SCSI\DiskNVMe____SAMSUNG_MZALQ512HBLU-00BL2 SCSI\DiskNVMe____SAMSUNG_MZALQ512FXM7 SCSI\DiskNVMe____SAMSUNG_MZALQ512 SCSI\DiskNVMe____ SCSI\NVMe____SAMSUNG_MZALQ512F NVMe____SAMSUNG_MZALQ512F GenDisk ...any ideas? TIA Mladen
SSRS 2022 not able to connect SQL Server 2022
Hi, on SQL Reporting Service Configuration Manager 2022, when i try to connect SQL 2022 instance, its enforcing encryption. However, during the SQL 2022 i just installed by default and haven't configured any SSL certificate or activated encryption. Moreover, MSSQLSERVER service account also default account which comes with installer. How can i disable or bypass this issue in order to configure SQL Reporting Service ? Regards,Solved : Uneven CPU usage
Greetings and salutations, I'm asking for your help with a situation that I'm not sure is a real problem, but it definitely caught my attention. We bought new hypervisor servers with two AMD EPYC 9174F processors (16 cores, 4.1 GHz, so 32 cores in total ). We are using Hyper-V. The hypervisor hosts only a single VM assigned 16 virtual cores. The VM is running Windows Server 2022 Standard and SQL Server 2019 Standard CU27. The VM was moved to this AMD hypervisor from another hypervisor, which was equipped with two Intel Xeon Gold 6346 processors (16 cores, 3.1 GHz, 32 cores in total). When monitoring the resource usage of a VM that is now running on the new AMD hypervisor, I see very uneven CPU usage that was not the case on the previous Intel hypervisor. As you can see in the images from Task Manager and Perfmon, the first 8 cores are significantly more loaded against the other 8. While the core for example core 0 and 1 are on average loaded at 66%, cores 14 and 15 are loaded at 2-4%. The SQL Server ERRORLOG clearly states that all 16 cores are in use, which is confirmed by querying the sys.dm_os_schedulers object. I'm partially hoping this is a Perfmon-level issue, but I certainly don't want to underestimate the situation. Perhaps I should direct my question to the Windows forum, but since it is database system, I'm creating a thread here. Does anyone have any idea how I should go about solving this situation please? Solution Almost by accident I managed to solve the problem and I'm ashamed that I didn't solve the problem sooner. The cause of the problem was an inappropriately set Widnows Server Power Plan. As you probably know, the default setting after installation is the Balanced mode, which, however, is extremely unsuitable for performance-intensive applications, which are database systems. Out of 16 virtual cores, 8 were in "Parked" mode. Changing the configuration to "High Performance" solved the problem immediately. It's already my routine to change this configuration when setting up each database server, and I'm almost certain I've done it on this system as well.
Recent Blogs
- We’re happy to announce that SQL Server 2025 Release Candidate 1 (RC1) now includes preview support for Red Hat Enterprise Linux (RHEL) 10, expanding our commitment to modern, secure, and flexible Li...Sep 17, 2025
- English follows Japanese. こんにちは、 SQL Server サポート チームです。 今回は、SQL IaaS Agent 拡張機能と Azure 上の SQL 仮想マシン リソースについて解説します。 SQL Server IaaS Agent 拡張機能とは SQL Server IaaS Agent 拡張機能は、Azure Porta...Sep 17, 2025
