Configuring Service Account Privileges for SQL Server
How to grant Windows privileges to the SQL Server's service account.
2012-02-28
8,353 reads
Lock Pages in Memory
Great SQL Server Debates: Lock Pages in Memory
There has been much debate over the need for the Lock Pages in Memory privilege, on 64-bit versions of SQL Server. Jonathan Kehayias presents a "warts and all" account of its history, the confusions surrounding its use, and why he believes it's still a good default configuration for 64-bit SQL Server instances, even when running Windows Server 2008 and Windows Server 2008R2.
2011-12-29
2,878 reads
Poor Man's Enterprise Feature - Lock Pages in Memory
Enable Lock Pages in memory on Standard edition was ONLY an Enterprise feature until now. Read this article to see how you enable this setting in SQL Server.
2009-10-15
8,765 reads
Blogs
Moving T-SQL Tuesday to Jekyll
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
European Microsoft Fabric Community Conference announcements
By James Serra
A TON of new features announcements at the European Microsoft Fabric Community Conference help...
Forums
An error occurred while skipping data rows
I am trying to build an ETL for an Existing Table. The ETL (SSIS)...
What is causing this error?
(This is probably the wrong forum to be posting this question, so please forgive...
Changetracking disabled in database snapshot, new bug in ms sql 2019 ?
Hi, We are using database snapshot together with changetracking to keep a datawarehouse up...
Question of the Day
Data Migration Assistant Targets
In the current (2024) version of the Data Migration Assistant, which on-premises targets are available?
See possible answers