Configuring Service Account Privileges for SQL Server
How to grant Windows privileges to the SQL Server's service account.
2012-02-28
7,943 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,666 reads
Blogs
Is Cataloging Your Data Important?
By Chris Yates
Data continues to be the lifeline for companies across the globe. As maturity levels...
Daily Coping 20 Mar 2023
By Steve Jones
Today’s coping tip is to get outside and notice how the weather feels. This...
Tales From The Field Weekly Wrap Up for the Week of 03-13-2023 & SQLBits 2023
By SQLBalls
Hello Dear Reader! What an incredible week we had. I started off traveling on...
Forums
Centralized SSIS Server?
Has anyone every created / managed a centralized SSIS server? We have a virtualized...
Azure SQL - Restore to lower enviornment
Hello! Backups are automated for Azure SQL Prod environment, we can do point-in-time recovery...
Ask SSC