Sql Server 2016 Certifications Announced


sql2016

Hot on the heels of the release of the latest version of Microsoft’s flagship database software  SQL Server, Microsoft has  announced upgraded certification exams that will validate you competency and skills in providing world class solutions using SQL Server 2016 Continue reading

Data Science : South Africa Leads The Way


datascience

The 2015 O’rielly Data Science survey is out and it contains some interesting findings. The survey explores patterns in tools, tasks and compensation patterns for recognized Data Scientists around the world. Over 600 respondents from a variety of industries completed the survey, two-thirds of whom are based in the United States.  1% of the respondents came from Africa, and all the African respondents came from South Africa! Continue reading

SQL SERVER : Understanding Date & Time Data Types


Time_PiecesI’m reminded of an old bible phrase which loosely translated says, “How shall they know, unless somebody teaches them . . .”. You see, one sure concept that does not come naturally in SQL Server Database Management is the skill to manage date and time data values. Even after years of SQL database management once still needs to refresh themselves time and time again in order to to meet the tricky requirements that date and time data management pauses. Continue reading

SQL Server : Understanding String Data Types


stock-footage-group-of-online-branding-related-d-words-part-of-a-business-concepts-seriesFollowing up to my last post on understanding numeric data types in SQL Server, in this post I would like to touch on the issue of string data types. One perhaps may want to call them non-numeric data types, however I would not be quick to say so as there is an in-between group of data types that has roots in both numeric data types and string data types. Continue reading

SQL Server Tip : Preventing Duplicate Records Using the “Unique” Constraint


ParCon_HP_Headerbilder_Folgeseite_Dubletten_01Sometimes as a Software Developer or Database Administrator, you almost always have to manage a database table that must must be free from any duplications whatsoever.

So how do you solve the problem? There are two ways of managing such a table, either by building-in functionality into your application code (C#, VB.NET for example), resulting in several lines of code, or you could do it the easy way, which is simply letting SQL Server do all the heavy lifting for you. Lets focus on the SQL Server route, the easy way! Continue reading

Understanding SQL Server Numeric Data Types


numbers2 (1)After completing my first stint as a Trainer at LGIT training the Course 40364 : Database Administration Fundamentals, some few topics stood out from my class which I would like to weigh on via an upcoming series of blog posts which I hope will assist to give clarity pertaining to certain SQL Server concepts. In this particular blog post I would like to deal with the concept of Numeric Data Types in SQL Server. SQL Server provides a number of numeric data types, hence there is often confusion at decision time as to what data type should I use for the data I would like to store in a particular column. Continue reading

New Electives for MCSA


Electives for MCSA Certifications Now Available:

Applies to Windows Server 2012 R2 and SQL Server 2012 / 2014

Effective 15 September  2014, Microsoft is introducing electives to the Windows Server 2012 R2 and the SQL Server 2012 / 2014 MCSA certifications. This new electives process gives flexibility in choosing the path that’s right for you and your organization.

MCSA Electives

Two exams in each path will be required, and you can choose from one of four exams to satisfy the requirement for the third exam.

For MCSA: Windows Server 2012 > Exams 410 and 411 are required. You can choose one of the following exams to fulfill the requirements for the third exam in the path:

  • Exam 346: Managing Office 365 Identities and Requirements
  • Exam 409: Server Virtualization with Windows Server Hyper-V and System Center
  • Exam 412: Configuring Advanced Windows Server 2012 R2 Services
  • Exam 462: Administering Microsoft SQL Server 2012 / 2014 Databases

For MCSA: SQL Server 2012 / 2014 > Exams 461 and 462 are required. You can choose one of the following exams to fulfill the requirements for the third exam in the path:

  • Exam 411: Administering Windows Server 2012 R2
  • Exam 412: Configuring Advanced Windows Server 2012 R2 Services
  • Exam 463: Implementing a Data Warehouse with Microsoft SQL Server 2012 / 2014
  • Exam 483: Programming in C#