I guess most of you know that feature of Visual studio where you can easily publish your site, either via MS Deploy or just to a shared folder. You can even have different profiles, one for the server, one for QA and one for Dev. Or you can just deploy straight to production and leave out all the fiddly bits. I have been doing this webdev thing for a few months now and have been using the publish method to Deploy to Dev and then I would copy that code to prod (technically it is not yet in production), making sure I did not copy/paste the config files over or the log files. I also had a build configuration on teamcity to build and run the tests. I gathered the copy/paste to prod step was kind of unprofessional and I should make it better.
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.
Eric Ligman has posted a nice collection of ebooks available in pdf, epub and mobi formats. The books cover Office, Office 365, SharePoint, SQL Server, System Center, Visual Studio, Web Development, Windows, Windows Azure, and Windows Server Here is what is available for SQL Server 5 Tips for a Smooth SSIS Upgrade to SQL Server 2012 A Hitchiker’s Guide to Microsoft StreamInsight Queries Data Mining Extensions (DMX) Reference Data Quality Services
I love and am very familiar with SQL Server. But, as a consultant, I need to step outside of that box pretty often, and advise people on applications, storage, and networking. I have general knowledge of those topics, gathered from many years in IT, seeing a lot of systems, and always being willing to learn. But having to work with some things on my own is the hardest part. I’ve been struggling with virtualization for some months. I have WMware Workstation on my personal laptop – I went and bought a full license because I really needed the full capabilities – and I decided to conquer some of my fears.
Did you know that you can get your twitter analytics straight from twitter? Here is how you can do it, go to https://ads.twitter.com/, sign in with your twitter username and password. click on the Analytics tab on the tab of the page (see image below) [][1] Here is what you will see if you pick timeline activity [][2] Looks very nice and clean, you can see how many followers you got and also how many people unfollowed you. The number of favorites, retweets and clicks is also available. If you have tweets that have a higher than usual reach it will be highlighted. The dashboard is realtime, if you tweet something it will be visible within a second or so
SQL is hard. Who’s to say whether it’s harder for the person that has no technical background or the one that is comfortable with object oriented, procedural, or functional styles and has to cross the great divide to set-based, declarative queries. In either case, there’s a journey ahead of you. Luckily there are a lot of great resources out there to help. From live webcasts like SQLLunch and 24 hours of PASS, to local SQL Saturday events, from recorded TechEd sessions to hundreds of books to blogs posts on sites like this….the list goes on.
In this week’s puzzle we are going to try to figure out how many uppercase, how many lowercase characters are in a column, we are also interested in how many are neither uppercase or lowercase Here is the table and the data CREATE TABLE Puzzle (Col1 varchar(10)); INSERT INTO Puzzle (Col1) SELECT 'ABCD01234Z' UNION ALL SELECT 'AAAAAAAAAA' UNION ALL SELECT 'aaaaaaaaaZ' UNION ALL SELECT 'a&a&a&a&aA' UNION ALL SELECT '1234Tt7890' This is the expected output Col1 UpperCase LowerCase Neither ABCD01234Z 5 0 5 AAAAAAAAAA 10 0 0 aaaaaaaaaZ 1 9 0 a&a&a&a&aA 1 5 4 1234Tt7890 1 1 8 For bonus points, you can add 3 more columns to the output, one column will hold only uppercase characters, one column will hold only lowercase characters, one column will hold only characters that are neither uppercase or lowercase
In exactly one week I'll be giving a session with my colleague Valentino Vranken (blog | twitter) at the Belgian Community Day. We'll be talking about Data Visualization. I'll be talking about the tips: how do you need to visualize your data without the audience scratching their eyes out because of the ugly colors you used? Why would or wouldn't you use pie charts? And what's the difference between an analytical dashboard and an operational dashboard? You can find answers on such question in this session.
In the final part of this series, we will create a BI subsite in our site collection. You can use this site as the starting point for your SharePoint BI demos. Browse to the PowerPivot site we created earlier in part 7 and go to Site Contents. Click on the new subsite link to create a new SharePoint site. In the following dialog, configure the name, URL, permissions and navigation. Select the Business Intelligence Center template, listed under Enterprise. Click Create to finish the configuration.
Finally we are getting to the really sweet stuff: Power View. But first we have to install Reporting Services in SharePoint integrated mode. The steps we are going to follow are described in the following MSDN document: Install Reporting Services SharePoint Mode for SharePoint 2013. Attach the SQL Server image to the virtual machine and launch the SQL Server setup. Go through the usual steps of the setup wizard until you need to choose the installation type. Choose Add features to an existing instance of SQL Server 2012 and make sure you select the correct instance from the dropdown if you have multiple instances on your machine. Click Next.
After configuring SharePoint in the part 7, we will now verify if the configuration was successful and if everything works correctly. The verification process is described in the following MSDN article: Verify a PowerPivot for SharePoint Installation. First of all let's start by verifying the site level integration. Navigate to our newly created PowerPivot site, http://sp2013bi. Click on the PowerPivot Gallery link in the navigation menu. You probably get the Silverlight icon, telling you to install it. Click on the icon to start the installation process. You might have to refresh the browser after the setup to see take it effect. This step is necessary, the PowerPivot libraries and Power View make use of this technology.