Configuring Service Account Privileges for SQL Server
How to grant Windows privileges to the SQL Server's service account.
2012-02-28
7,337 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,605 reads
Blogs
Power BI Monthly Digest – August 2020
By Devin-Knight
In this month’s Power BI Digest Matt and I will again guide you through...
Daily Coping 14 Aug 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Setting default values for Array parameters/variables in Azure Data Factory
By Rayis Imayev
(2020-Aug-14) Setting default values for my parameters or variables in Azure Data Factory (ADF)...
Forums
Removing TDE from a Database: Level 4 Stairway to TDE
Comments posted to this topic are about the item Removing TDE from a Database:...
Location Data Privacy
Comments posted to this topic are about the item Location Data Privacy
TextBox Property>Action>GotoURL for Multiple Values?
Hi I am using two stuff commands in my query. One gets the date...
Ask SSC