-
Change ”select top 1000” to ”Select top XXX”
In SQL server management studio, when you right click on a table, there is a shortcut to select top 1000 or edit top 200 rows. Se pic below. It is an easy way, when you just want to see some of the data in a table, or if you want to edit some values in… Continue reading
-
Unboxing Azure part 1: The new Portal & how to create an Azure SQL database
Not so long ago, Microsoft(MS) announced a lot of new and cool features to their Azure platform at their event “Meet windows Azure” There is no doubt that MS is expanding fast in the cloud, and with this blog series I will try to give a short overview of the business intelligence(BI) capabilities that are… Continue reading
-
SSAS translation problems with Excel
I just revisited an old customer, where they had a setup with a SSAS 2008 and are using Excel 2007 as a frontend. They had a problem when they tried to log on to one of the cubes. They didn’t get any errors, but when they had filled out all the connection information, they just… Continue reading
-
Unboxing MS SQL Server 2012 – The new analytic functions
As mentioned in my previous blot post, SQL server 2012 comes with 8 new analytic functions: LEAD LAG LAST_VALUE FIRST_VALUE PERCENTILE_CONT PERCENTILE_DISC PERCENT_RANK CUME_DIST All the new analytic functions work with the window functions I described earlier in this blog series, and calculate an aggregate in the given window. Let’s start by looking at the… Continue reading
-
Monitor the process of long running SQL queries like DBCC SHRINKDATABASE
When a query runs a little longer than I would expect, I sometimes starts to get nervous. Especially in the cases, where there is no status telling me when it will finish; Like for instance when I run a shrink database cmd. You can get information about the queries running like this. Especially the percent_complete… Continue reading
-
Unboxing MS SQL Server 2012 – The new window functions
SQL server 2012 comes with a new set of window functions and analytically possibilities, which I will look into in this blog post. Prior to 2012 Prior to the 2012 version, windows functions were also possible. The syntax looked like this: Ranking Window Functions < OVER_CLAUSE > :: = OVER ( [ PARTITION BY value_expression… Continue reading
-
Unboxing MS SQL Server 2012 – Installing the database server and the Adventure works databases
The new MS SQL server version 2012 was released not so long ago. With this article series, I will log my first experiences with it, regarding installation and setup, new features, look and feel etc. First things first. Let’s install it. If you don’t have a developer edition in you company, download a trial version… Continue reading
-
Search text in SP
*Just as a note to myself* I’ve just joined a big project with thousands of stored procedures. To get an overview of it, it would be nice if I could get the SP’s which inserted data in to table a, or update column b in table c etc. That is easily done, like so: SELECT… Continue reading
-
MS, seriously!!! SSIS and System.Runtime.InteropServices.COMException (0x800A03EC)
Let me describe my problem. Maybe you have the same, if you have googled for the error code, and found this page. So, I’m downloading an old Excel file from a German webpage. The Excel file is in a spreadsheetML format, which is impossible to read from SSIS. No worries, I can easily with a… Continue reading