Some year’s ago – I got introduced to SQL. At that time, I recall, I was sitting in a lab and one of the first exercises we did was to create a table in a database and adding data in it. In next lab, we ran SQL commands that updated records and deleted few. After we’re done – our instructor told us what we learned were the most basic programming functions i.e CRUD operations
CRUD stands for Create, Read, Update and Delete.
C: Create
R: Read
U: update
D: delete
Let’s see the SQL equivalent of CRUD operations:
Operation
SQL
Create
INSERT
Read
SELECT
Update
UPDATE
Delete
DELETE
Is the concept of CRUD just applicable to SQL?
No. in fact, if you start learning programming or web development – one of the first things that you get to learn is how to run CRUD operations with that particular language.
Conclusion:
In this blog post, I documented four (4) basic programming functions i.e. Create, Read, Update and Delete.
In this blog-post, we would see what does it mean to lock a knowledge base in Data Quality Services? So the lock on the Knowledge Base indicates that there are unsaved changes in the Knowledge base when you or someone else was working on it.
In the Data Quality Client, Here’s how a lock on the Knowledge Base looks:
And here are few points for a locked knowledge base:
1) If you did not lock the Knowledge Base then you can open it in read-only only
2) if you locked the Knowledge base, you can open and edit it. The Knowledge base would be opened in the state that it was closed in.
3) A user working on the Knowledge base can unlock it by publishing it or by unlocking the knowledge base.
4) By positioning the cursor on the knowledge base – you can see who locked it:
Conclusion:
In this blog post, we saw what does a lock on a knowledge base in Data Quality Services mean?
I installed StreamInsight 2.0 on my demo machine today and so I thought I would document the process.
Before we begin, few references to existing documents on the interwebs: Official documentation about Installation is here: http://msdn.microsoft.com/en-us/library/ee378749.aspx and Introduction to concepts of StreamInsight can be accessed via the following resources:
Now, here are the steps that I took to install StreamInsight on my demo machine:
1) I located the StreamInsight installer inside the SQL Server 2012 Developer edition setup that I had:
Note that even though StreamInsight is licensed with SQL Server – It is different “software” that solves different technical problem(s). And note that StreamInsight does not have dependencies on SQL Server. It is a separate install.
2. On the Instance Configuration page, I added “StreamInsightInstaller” as the instance name. This is the first instance of StreamInsight that I am installing on my demo machine
3. On next dialog box, I added the product key that I have for SQL Server Developer edition. You also have the option to activate 180 day trial.
4. Then specify the StreamInsight service and group settings
5. Click on Install on next dialog box
6. You would also need to install the SQL compact edition. To do that, I navigated to C:Program FilesMicrosoft StreamInsight 2.0Redist
Note that, if you have chosen the x64 version then you would have to first install the x86 version of SQL Server compact and then the x64 version of SQL Server Compact.
7. Now installation is complete at this point.
8. If the StreamInsight Service is not started, then go to services and start it.
In services: Right click > Start:
9. Now, You can run samples. To access them you can go to Start > all programs > StreamInsight Samples
Conclusion
In this blog-post, we saw how to install StreamInsight 2.0 on your machine.
In this blog-post, we would see how you can stop programs from automatically running when windows start. We’ll see how you do that using MSConfig. Before we begin, let’s discuss why would you want to stop few programs from automatically running when windows starts? Well, programs consume memory and thus lowers overall system performance. So by switching unwanted (or infrequently used) programs – you are increasing system performance. So ready? here are the steps:
1) Start > type “msconfig.exe” > open msconfig.exe
2) In MSConfig.exe > switch to “startup” tab
3) Disable the programs by unchecking the check-box.
Note: Before Disabling, please verify what a program is. You do not want to disable programs like Microsoft Security Essentials or third part firewall. That would be bad!
4) So I unchecked check boxes for Google Toolbar, Skype and Spotify on my netbook – and so these programs would not run automatically when my net-book starts.
5) When you’re done – Click OK > And You can choose to restart your computer – changes would be applied only after the restart.
That’s about it.
Note that here are other methods too like one’s listed here, research and use the method that suits you – But do NOT forget to switch off the unwanted programs from running automatically when windows starts.
I was playing with Excel 2013 and wanted to see the Formula Bar for something. Turned out, by default, It was hidden and so I learned how to unhide it. Here are the steps:
1. Go to View Tab
2. Check the “Formula Bar” check-box:
3. And it’s unhidden now!
Conclusion:
In this blog-post, we saw how to unhide the formula bar in Excel 2013.
The Hadoop on Azure’s Javascript console has basic graphing functions: Bar, Line & Chart. I think this is great becuase it gives an opportunity to visualize data that’s in HDFS directly from the Interactive Javascript Console! Here’s a screenshot:
In the console, I ran the help(“graph”) command to see how I can use this function: Draw a graph of data graph.bar(data, options) Bar graph graph.line(data, options) Line graph graph.pie(data, options) Pie chart
Parameters data (array) Array of data objects options (object) Options object, with x (string) Property to use for x-axis values y (string) Property to use for y-axis values title (string) Graph title orientation (number) x-axis label orientation in degrees tickInterval (number) x-axis tick interval
Conclusion:
In this blog-post, I posted that Hadoop on Azure’s Javascript Interactive Console has basic graphing functions.
This seems like a great way to visualize where your fans are from. In my case, most of them are from India and so one actionable insight would be to schedule posts based on Time Zone in India. And I can imagine that such reports could be very helpful to brands who have sizable fan following on Facebook.
Here’s the screenshot:
Thanks to the following blog-posts for inspiration:
In this post, I am going to write the Book Review for The Data Journalism Handbook
Earlier, I had shared an insight from the Book with you, Here it is: “World has changed, from what’s NEW to “what does it all Mean” – This means that Professionals who focus on reporting “what’s new” would soon be “out of job”. And they should start equip themselves with Analytics skills that helps them uncover insights from all the news around us and help us all make sense of information that’s all around us.
To that end, The book “Data Journalism” is a great inspiration for Journalist and it seems it’s meant to encourage journalist to start embracing the change. It inspires Journalists to think of stories and find data about it. So what’s it for Data Geeks? It encourages Data Geeks to help journalists weave story around the data that they found. The book also outlines resources that Data Geeks could use.
Now, Two things I really Liked about the book:
1. Examples & case-studies, Lots of them! very inspiring!
2. I came to know about Tools that I didn’t knew about before. I am going to use them!