Do’s and don’ts   What is SQL Server FileStream feature? This feature allows adding unstructured documents into the database. You can store images, PDFs, videos, or whatever files you want into SQL Server database. This allows to have transactional consistency of images.   We have worked with very large FILESTREAM implementation. And I will show

How to re-initialize SQL Server Merge replication publication 1. Connect to publisher instance: CIXSQL01\TOUCHSTORE. 2. Click right on Replication folder and click on “Launch Replication Monitor” option. 3. Click right on publication that you want to reinitialize and click on “Generate Snapshot” 4. After generating the snapshot go back to Local Replication, expand the publication

Before vs. After Perf Tuning Report #11 – 767,508% improvement This is the case when tuning sometimes can not be done perfectly. We trying to change DB code, so nothing else needs to change. In some cases, even though result set is exactly same, rows may come back in the different order back to the

Why Disk (or Storage or I/O or R) operations matter the MOST when Tuning T-SQL Calls for Performance “Disk” – has different names. I think that confuses anyone outside of DBA little world. Alternate names some DBAs call Disk (including myself) are: Storage I/O (input output operations) Disk operations or simply “Reads” All of those

Before vs. After Perf Tuning Report #10 – 340% CPU gain This tuning requires a bit of a different explanation. In some cases, client server is pressure on different resources. The three resources/parameters when tuning we care most about are: CPU Storage Duration In this case, this stored procedure ran a LOT. It ran enough,

Before vs. After Perf Tuning Report #9 – 1,600% gain Another tuning. Another significant gains. More details:     Here is the Excel version.        

How to configure Antivirus running on SQL Server   First, I’d question having Antivirus on SQL Server if it is a “must have”. Then question it again. Seriously. Not joking.   SQL Servers are often internal. Behind firewalls. Not accessible from outside. Only accessible by internal apps. Therefore, it may not make sense to run

12 SQL Server Monitoring Jobs and the best SQL monitoring practices even if Santa brought you all third party software licenses you asked fir   I don’t care how many third party software monitoring you got going on. Some alerts work best as SQL native tools.   SQL DBA are responsible to many SQL Servers.

How to apply Windows or SQL Server patches to failover SQL Server cluster with AlwaysOn – Step by step Apply patches to lower environment servers first. This is DEV, QA, UA, etc. Use the lowest environment in the release cycle. Let the new change “burn in” for a while. The “while” depends per client. Some

Before vs. After Perf Tuning Report #8 – 913,262% speed improvement Total improvement: 913,262% Not bad, huh? These type of database speed improvements makes me smile! 🙂   Here is another SQL Server performance tuning report. Before vs. After. “Before” – shows numbers before we made any changes. “After” – shows performance numbers after we