GDS Consulting

Creating the right data management policies, procedures, and processes to ensure it remains accurate, secure, accessible, and usable for analytics insights should be a top priority.

  Tuesday, 7 August  2018 By Fred Mintah

Creating a new or attaching a database

Once you have established connection to your LocalDB server, you may want to attached an existing database files or create new ones.(If you don't know how to connect to the LocalDB, please follow this link Connecting to Microsoft SQL Server LocalDB )

To do this, you have a number of options.

  1. Create a new database
  2. Attached existing database files (graphical and scripting)
  3. Restore a backup file

Creating a new database

     Right-Click on the Databases tree in Management Studio and select New Database   


Read more ...

 Tuesday, 7 August  2018 By Fred Mintah


Tuesday, 7 August 2018

Connecting to Microsoft SQL Server LocalDB can be very simple however it may seem daunting if you don't know how to do it, even among SQL experienced users.

Firstly, Microsoft SQL Server Express LocalDB is a lightweight "on demand" version of SQL Server Express and it's intended for developers. It is very easy to install and doesn’t require any complex configuration task to create an instance or to use the database. The Introduction on the installation of Local DB be found on “How to install Microsoft SQL Server Express LocalDB” article or  SQL Server 2016 Express LocalDB

Firstly, determine the version of LocalDB version you have installed. To do this,

Read more ...

Even if you just passively follow the data management space, you've no doubt heard a lot about the practice of data governance over the past several years. If you do a Google search on terms related to the pillars of data governance (people, processes and technology), you'll get dozens of results. While data governance has evolved with the IT space over the years to include new technologies and different employee roles, one thing has remained constant: The universal belief that governance is crucial to an organization's long-term success.


Read more ...

I get asked a lot of questions by customers at all levels. They all want to know how to solve their problems, and it is part of my role to help them find answers.

The range of questions is extremely broad. Data scientists want to know how they can improve collaboration and speed up data preparation, or combine what they have with open source elements. More senior people have different questions.


Read more ...

In a recent #SASchat we explored the intersection of artificial intelligence and human creativity. Posing questions like, "How is AI impacting human creativity?" And, "What will it take for the public to fully trust AI?" In the lively online conversation, a few themes prevailed:

Automation enabled by AI frees humans from tedious tasks to focus on more visionary and creative ideas. Seeing real-world use cases and positive results will help the general public have more trust in AI.


Read more ...

4th Floor, The Firs, Cnr Bierman & Cradock Avenue,
Rosebank, Johannesburg, 2196, South Africa

Get Direction
Contact details

Phone: +27-11-759-4048


Open Hours

Monday - Friday: 8 AM - 5 PM


Contact Us 

Copyright © 2022. GDS Consulting. 

Our website is protected by DMC Firewall!