Interesting! Thanks Jack for sharing this. Do you have a way to check the this setting by command?...

What if you had to create a script stack that installs SQL Server from an image library? And customisations – such as adding the SQL Server Start up account to the Lock Pages in Memory Local Policies? If this needs to be rolled out quickly acros...

Learn about SQL Server DBA, SQL Server database performance,SQL Server optimisation,database tuning,t-sql,ssis...

Slipstream is a process to merge SQL Server Service Pack with the original installation media. This can ease the install of SQL Server. Since you just need to install once, not twice (SQL Server and Service Pack). However, the slipstream step is tedious...

I often here the terms session, connection and request. What are they? Also can you explain a little of the dmvs: `sys.dm_exec_requests`, `sys.dm_exec_connections`, `sys.dm_exec_sessions`. Thanks....

I often here the terms session, connection and request. What are they? Also can you explain a little of the dmvs: sys.dm_exec_requests, sys.dm_exec_connections, sys.dm_exec_sessions. Thanks. ...

I wrote a post yesterday on how to read/write the Windows registry from TSQL. Nakul asked a question on when should we read/write to/from the registry directly. This post is an answer to his question. We know that a lot of configuration information a...

Hi Nakul, Since a lot of SQL Server configuration information are saved in the registry, you can get/modify the information directly instead of through a GUI if you know these stored procedures. For example, you may need to add a specific trace flag ...

Cool. Congrats!...

This books tries to explain the new FILESTREAM feature introduced in SQL Server 2008 from basic to advanced levels through a number of simple examples and walk-through labs...