SQL

admin on April 21st, 2016

THANK YOU! For attending my session on SQL and PowerShell. Full democode can be downloaded SQL Server and PowerShell. Any questions? Let me know: @DimensionIT Dimitri Koens on LinkedIn dimitrikoens at gmail dot com Don’t forget to rate with the Whova App. Thnx! — Dimitri

Continue reading about SQL Server and PowerShell

Dimitri Koens on May 24th, 2012

Here are my personal SQL Server Installation Best Practices. Please note: they’re best practices. Maybe most of them can be hulpfull for most situations, in other situations some options must be configured otherwise. Please let me know if you have any questions or suggestions. When using 4 (or preferably more) CPU’s reserve the first core […]

Continue reading about Microsoft SQL Server Installation Best Practices

Dimitri Koens on May 21st, 2012

Here’s a list with a feature comparison of the three most popular DB products (imho). Please let me know if you have any  additional information, especially on the Oracle topic. References http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems http://en.wikipedia.org/wiki/Microsoft_SQL_Server http://en.wikipedia.org/wiki/MySQL http://en.wikipedia.org/wiki/Oracle_RDBMS

Continue reading about Feature comparison Microsoft SQL Server, Oracle, MySQL

Dimitri Koens on January 23rd, 2012

Studying for SQL exam 70-432? Make sure you take training 6231 AND 6232. The Microsoft website doesn’t mention the 6432 training: http://www.microsoft.com/learning/en/us/exam.aspx?id=70-432#tab3 When you take a look at the learning plan (mentioned on the same webpage) you will find that Microsoft recommends both 6431 and 6432 courses. The 6432 training contains information on partitioning, triggers, […]

Continue reading about SQL exam 70-432