Configuring Service Account Privileges for SQL Server
How to grant Windows privileges to the SQL Server's service account.
2012-02-28
7,568 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,624 reads
Blogs
Daily Coping 17 Sep 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Ethics in Modern Data at Music City Tech 2021
By Will Assaf
On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...
Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available
Last week, Kerry and I delivered a webinar with tips on how to set...
Forums
SSRS Migration Question
So I have a SQL 2017 server that has the two Report Server Databases,...
What is the specific job of the SQL Developer position?
I knew about the position of SQL Developer through an introductory newspaper. I found...
update final code where not contain x then null if not contain x and another cod
i work on SQL server 2012 I face issue i can't update table replacement...
Ask SSC