In yesterday’s post MongoDB: How to backup and restore databases we looked at how to backup and restore a database, today we are going to look at how to restore a collection from a backup. Be aware that mongorestore and mongodump have to be executed from a command window in the bin directory where mongodb is. To execute the MongoDB commands you need to connect to mongodb first. On my PC this is in the directory C:NoSQLmongodbbin>
This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
This blog is part of my series Making Data Tell a Story With SSRS Properties. Property: Columns The purpose of this property is to allow you to display more than one column of data on the report. To access this property go to Report properties. Choose Columns. The options are Columns and Column Spacing. Columns: the number of columns the final report will have. ColumnSpacing: the space between the columns.
Today it is time to learn how to backup and restore databases in MongoDB. You do have jobs setup that automatically create backups right? If you do not, please close this window and go set that up first, your data is the most important part of the organization, without data you got nothing, just ask ma.gnolia. That site is not around anymore because they didn’t back up their database. Enough of that let’s get started.
This blog is part of my series Making Data Tell a Story With SSRS Properties. Property: Background Image The purpose of this property is to allow you to show an image in the background of a report, table, list, and more. To access the property, go to Report, Body, Table, or Matrix properties and select Background Image. The options are Source, Value, MIMEType, and BackgroundRepeat. Source: External – an image that can be accessed via a URL.
Whoa whoah. Aren't you supposed to increase your data flow buffer size in order to speed up your packages? If you have enough memory and you can process more rows at the same time because your buffer is larger, that's what we want, right? Yes, this is confirmed by the old blog post Adjust buffer size in SSIS data flow task by the SQL Server Performance Team. But this is only true when your source is fast enough to fill those buffers.
SQL Server Reporting Services is one of my favorite parts of the Microsoft SQL Server stack. Making data tell a story is incredibly valuable, and fun. Which one of these tells the story better? I’ve used SSRS for years, and discovered many little tips and tricks to make reports stand out. For the next month, I’m going to be blogging about various properties in SSRS. Some are simple to find and set; some are more complex and require a few steps or expressions.
What is Microsoft Business Intelligence? I’m not asked this question very often because it’s typically an assumption. As we know, assumptions can lead to misguidance or misrepresentation of a topic. This topic has been defined in so many different ways; I ask it in almost every interview I perform that has the word, “Data” in it. The reasoning for asking that question isn’t directly to say a person is wrong or right but to see the range they’ve taken on in knowing all the factors that lead to end solutions in data.
On 5, 6 and 7 March 2013 Microsoft Belux is organizing Techdays 2013, 3 days of sessions for IT Pro’s and developers. But when checking the calendar there are no sessions about SQL Server. The reason is that the Belgian SQL Server User Group organizes yearly a 2 day event about SQL Server the SQL Server Days and this is where the SQL Server enthusiasts should get their knowledge. But I disagree, as a full-time SQL Server consultant, I can’t justify going to an event where there is no SQL content at all.
Introduction So last weekend I poste about Nancy an jtable and all was well. This morning I wanted to add a column with a link and a date with a datetime to it. Neither were obvious but it is possible. And pretty easy once you know how. I have put the code on github. Column with a link This is what I want. And in a sense it is very easy to do.
The question is often asked: when will SQL Server statistics update if auto update stats is enabled? The short answer: When auto update stats is enabled in a database, statistics will update when 20% + 500 rows have changed in the table. This change can be adding new rows, removing rows or updating rows. If you attend sessions or read many tuning articles that involve statistics on the internet, you may have seen the statement, “20% + 500 rows” more than a few times.