(Jack Vamvas) The SQL Server Error Msg 7609 Full text search is not enabled or a full text component cannot be loaded appeared during an application upgrade.
Tag: sql server
Endpoint Owners – Back to Basics
(Jason Brimhall) Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a blog post each month on a SQL Server Basic.
#0407 – SQL Server – Clearing out the list of servers in SSMS
(Nakul Vachhrajani) Today, I will talk about a very common question that I see in the forums. When you work with a lot of SQL Server instances, the list of servers seen on the login screen in the SQL Server Management Studio (SSMS) becomes quite long, raising the question:
Error – The following feature couldn’t be installed – .NET Framework 3.5
(Manoj Pandey) I got error this message on a pop window while running a new application after installing it on my Windows Server 2012 Azure VM.
Backup to NUL
(Kenneth Fisher) Yes, I spelled that correctly. NUL not NULL. NUL is basically a location you can send a backup to. In fact, one of the awesome bonuses of this location is that your backup will take up exactly 0 bytes of space.
Why the Clustered Index should be Unique In SQL Server
(NEERAJ Sharma) This article is a small part of the big series i started with my very first article on create primary key in SQL Server followed by question answer series on the primary key and then and explaining all the point of the answer in detail with internal structure.
Exporting Power Query/M Queries To ODC Files In Excel 2016 Get & Transform
(Chris Webb) A really useful new feature was added to Get & Transform (the functionality previously known as Power Query) in the latest updates for the Office 365 click-to-run version of Excel 2016: the ability to export and import ODC files containing M queries.
SQL SERVER – How to Install SSMS From Command Line? Error: The Specified Value for Setting ‘MEDIALAYOUT’ is Invalid.
(Pinal Dave) There are many DBAs who like to automate the deployment of SQL. It is not fun to use wizard in all the installations. Imagine that setup media is kept in a remote share and all you need to do is provide a batch file to run and it would take care of installation. Let us learn How to […]
How to Stop, Start, Enable and Disable SQL Server Services on Linux
(Rajendra Gupta) Microsoft has recently released SQL Server to run on Linux servers. Once installed, we may need to stop, start, enable or disable the services. In this tip we will see how to do it in Linux.
SQL SERVER – xp_logininfo – Msg 15404: Could not obtain information about Windows NT group/user, error code 0x2147
(Pinal Dave) One of my client was running into the below error running xp_logininfo on some of their users. It was interesting that when they run the script to capture user information it works for the same user in another domain.
