Tagged in

Sql Server

SQL, Code, Coffee, etc.

Data and stuff by @MarlonRibunal

More information

Followers

254

More, on Medium

Sql Server

Marlon Ribunal in SQL, Code, Coffee, etc.

Nov 2, 2018

How I Work: Data Professionals at Work

It has been a busy year so far. Last March, I did a review, as a Technical Reviewer, for a SQL 2017 Machine Learning book. In the summer, the whole family went to the Philippines for a 3-week vacation. Between the Machine Learning book and the vacation, I was…

Marlon Ribunal in SQL, Code, Coffee, etc.

Apr 10, 2018

Creating Facets in SQL Server 2017 Using R

SQL Server 2017 In-Database Machine learning has brought the analytics closer to the…

Marlon Ribunal in SQL, Code, Coffee, etc.

Jun 6, 2012

Getting started with SQL Server on private cloud

I have been invited to a private beta of SQLDirector by ScaleGrid. “SQLDirector is a MS SQL as a Service (SaaS) solution for the private cloud.” It is a software solution for your private cloud or virtualization infrastructure.

Marlon Ribunal in SQL, Code, Coffee, etc.

May 9, 2012

Your SQL Server database just failed, can you restore the backup?

It’s one thing to be able to backup a database, it’s another thing to be able to restore it into an operational database in case of failure. We can run a simple TSQL to check the validity of a backup file. We can do…

Marlon Ribunal in SQL, Code, Coffee, etc.

Apr 23, 2012

Who are the sysadmins in this sql server?

Sysadmins are pretty much powerful in the SQL Server environment. They can put the whole SQL Server infrastructure under their control. That said, it is important to know who else has this fixed server role.

Marlon Ribunal in SQL, Code, Coffee, etc.

Apr 11, 2012

Limiting user access to your database

There are situations where you need to grant SELECT permission to a particular user and limit that access to a particular OBJECT, say a TABLE.

Here’s a quick way of accomplishing this. In this example we’re using the AdventureWorks2008R2…

Marlon Ribunal in SQL, Code, Coffee, etc.

Apr 4, 2012

The evolving role of the database professional

The role of the database professional is quickly evolving to conform with the ever changing demands of the business world. The new game of the data pro is adaptation.

Marlon Ribunal in SQL, Code, Coffee, etc.

Mar 29, 2012

Save yourself from despair with full database documentation

Your ability to document thoroughly will determine your efficiency and productivity when it comes to managing your SQL Server databases. Aside from the question of productivity, there’s always the concern of having to come…

Marlon Ribunal in SQL, Code, Coffee, etc.

Jan 8, 2014

Laying The Ground For A Successful Reporting Project

Building a reporting system from the ground up is a daunting task. Such a big project usually involves intricate resource movement. Reporting is an important component of Business Intelligence (BI). Therefore, perceptive implementation…