Tag Archives: sql server

Customizing SSMS–Results

This is a short series on some customizations in SSMS to make it visually more appealing. As a presenter, I’ve learned how to change the way Management Studio (SSMS) looks to make it easier for people to see the screen … Continue reading

Posted in Blog | Tagged , , , , | 2 Comments

Filestream and Filetable in SQL Server

This talk is an update of my Unstructured Data in SQL Server talk that looks at the Filestream and Filetable features of SQL Server. This session begins by presenting a case why we will manage more binary (unstructured data) in … Continue reading

Posted in Presentations | Tagged , , , | Comments Off on Filestream and Filetable in SQL Server

Disabling Resource Governor

I had known that the Resource Governor is always running in modern versions of SQL Server. It’s core to the operation of the SQLOS, though it can’t be used to do anything unless it is enabled. You can read more … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Disabling Resource Governor

The Command Shell

Recently I heard a few people arguing over the use of xp_cmdshell in a particular situation. One person was adamant that there was a security risk in using this feature. Many of you probably feel the same way, and even the SQL … Continue reading

Posted in Editorial | Tagged , , | 2 Comments