Configuring SQL Database Mail

     

Views – 105


My Microsoft Code Extensions

Here are the current set of MS Code extensions I use on a daily basis. Views – 89


Removing TempDB data files from SQL Server

I had a situation where a SQL Server 2016 install did not install correctly. The install completed but when I tried to move the tempdb datafiles over to a separate LUN, it created new files, leaving the old ones in place and active, so I ended up with 16 active tempdb datafiles. Here is how…


How SQL Server processes a query

The logical order in which SQL Server parses a query and generates an execution plan: 1. FROM [left_table] 2. ON [join_condition] 3. [join_type] JOIN [right_table] 4. WHERE [where_condition] 5. GROUP BY [group_by_list] 6. WITH { CUBE | ROLLUP } 7. HAVING [having_condition> 8. SELECT 9. DISTINCT [select_list] 10. ORDER BY [order_by_list] 11. [TOP_specification] The physical…


10987 Performance Tuning and Optimizing SQL Databases (OLL)

10987B – Performance Tuning and Optimizing SQL Databases Trainer: Bill Chapman Download Companion Content for Microsoft Official Courseware (MOC) Online Syllabus for Course 10987B Mon Dec 12 – Thur Dec 15 Monday Session 1 – SQL Server Arch, Scheduling and Waits – Module 01 -Windows has a scheduler to manage scheduling starvation for other tasks…


Resize a VirtualBox Linux VDI Disk under Windows Host

Resize a VirtualBox guest Linux VDI Disk under Windows Host The link to GPartEd: GParted ISO download Views – 199


Protected: Installing SQL Server on Linux

This content is password protected. To view it please enter your password below:

Views – 225


Migrating Parallels VMs to Oracles’ VirtualBox

Below are the steps to migrate a Parallels VM to VirtualBox. This example is done on a MacBook Pro running OS X Sierra (see screenshot below) using the followjng versions of Parallels and VirtualBox: 1. Locate the VM file that you wish to import. It is located in your Parallels folder (where all the VM´s…


Using the KILL command

You can view the status of a KILL command used to stop an open transaction by typing the following:

Views – 211


About Replication

Questions: 1. Does TR copy schema changes? (It does not. It’s a lot like CDC in many ways) Setup Transaction Replication in SQL Server 2012 Using Multiple Versions of SQL Server in a Replication Topology Getting Started with Transactional Replication In defense of transactional replication as an HA technology Troubleshooting Transactional Replication SQL Server Replication…