sharing my experiences with SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Dashboards & Visualization (by Paul Turley)
http://sqlserverbiblog.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Friday
LOAD TIME
0.8 seconds
16x16
32x32
64x64
PAGES IN
THIS WEBSITE
16
SSL
EXTERNAL LINKS
98
SITE IP
192.0.78.12
LOAD TIME
0.828 sec
SCORE
6.2
Paul Turley's SQL Server BI Blog | sharing my experiences with SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Dashboards & Visualization | sqlserverbiblog.wordpress.com Reviews
https://sqlserverbiblog.wordpress.com
sharing my experiences with SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Dashboards & Visualization (by Paul Turley)
sqlserverbiblog.wordpress.com
Books | Paul Turley's SQL Server BI Blog
https://sqlserverbiblog.wordpress.com/books
Paul Turley's SQL Server BI Blog. Sharing my experiences with SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Dashboards and Visualization. Power BI Hands-on Workshop. SQL Server Ver Poll. SQL Server Analysis Services 2012 Cube Development Cookbook. Baya Dewald, Steve Hughes, Paul Turley. Professional SQL Server 2012 Reporting Services. Paul Turley, Robert Bruckner, Thiago Silva, Ken Withee, Grant Paisley. SQL Server MVP Deep Dives Volume 2. Paul Turley, Dan Wood.
Datazen Visual Control Categories | Paul Turley's SQL Server BI Blog
https://sqlserverbiblog.wordpress.com/2015/08/12/datazen-visual-control-categories
Paul Turley's SQL Server BI Blog. Sharing my experiences with SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Dashboards and Visualization. Power BI Hands-on Workshop. SQL Server Ver Poll. Datazen Visual Control Categories. August 12, 2015. These controls are used to filter the data displayed in other controls. Displays a range of time/date values. Supports years, quarters, months, days, hours. Supports one or multiple metric fields. Similar to Time Navigator.
Learn How to Use Datazen this Week | Paul Turley's SQL Server BI Blog
https://sqlserverbiblog.wordpress.com/2015/07/29/learn-how-to-use-datazen-this-week
Paul Turley's SQL Server BI Blog. Sharing my experiences with SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Dashboards and Visualization. Power BI Hands-on Workshop. SQL Server Ver Poll. Learn How to Use Datazen this Week. July 29, 2015. SQL Server Pro Magazine is hosting my 3-part series, Designing a Mobile Dashboard Solution with Microsoft DataZen on Thursday. Session 1: Introducing DataZen and Building a Server 11am EDT. Click to email (Opens in new window).
BI Components Poll | Paul Turley's SQL Server BI Blog
https://sqlserverbiblog.wordpress.com/polls-2/bi-components-poll
Paul Turley's SQL Server BI Blog. Sharing my experiences with SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Dashboards and Visualization. Power BI Hands-on Workshop. SQL Server Ver Poll. Click to email (Opens in new window). Share on Facebook (Opens in new window). Click to share on Twitter (Opens in new window). Click to share on LinkedIn (Opens in new window). 2 thoughts on “ BI Components Poll. September 8, 2014 at 8:35 pm. September 14, 2014 at 8:09 pm. Enter...
SQL Server Community World Tour with GeoFlow | Paul Turley's SQL Server BI Blog
https://sqlserverbiblog.wordpress.com/2013/03/05/sql-server-community-world-tour-with-geoflow
Paul Turley's SQL Server BI Blog. Sharing my experiences with SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Dashboards and Visualization. Power BI Hands-on Workshop. SQL Server Ver Poll. SQL Server Community World Tour with GeoFlow. March 5, 2013. Click to email (Opens in new window). Share on Facebook (Opens in new window). Click to share on Twitter (Opens in new window). Click to share on LinkedIn (Opens in new window). This entry was posted in BI Industry.
TOTAL PAGES IN THIS WEBSITE
16
MukkuMuku備忘: 2014/02 - 2014/03
http://mukkumuku.blogspot.com/2014_02_01_archive.html
Office 365 Access アプリ -44- Office用 アプリ. Access も Apps for Office に対応となるというお話。まだ、詳細な情報はないけれども。 ちょっと強引なところから追加するような感じになっているのだけど、Access アプリ のビュー上に挿入するという感じになるはずです。ビューに紐づけられたレコードセットを Office用 アプリで参照などしてお好きなように表示（特にグラフィカル）などするという感じになろうかと。 Office 2013 Service Pack 1 リリース. Description of Microsoft Office 2013 Service Pack 1 (SP1). Office 365 Access アプリ -43- イメージフィールド. デザイン時や単純に Access アプリ を使っている分には特に対応する必要はないけれども、イメージデータの格納が内部的に分割されているので Access アプリ のデータを別のアプリケーションで使用したいとするときイメージデータについては多少の工夫は必要になる。 Reporting Ser...
MukkuMuku備忘: 2014/04 - 2014/05
http://mukkumuku.blogspot.com/2014_04_01_archive.html
Access 2013 Runtime ServicePack 1 公開. Microsoft Access 2013 Runtime ja-jp. Microsoft Access 2013 Runtime en-us. Office 365 Access アプリ -47- Access 用コンテンツ アプリ - 1. 一応やっておかないとかなと。MSDN ライブラリだけ読んでやってみる。 Content apps for Access. JavaScript API for Office (v1.1). JavaScript API for Office (v1.1). レコード移動時 / OnCurrent や レコード更新時 / AfterUpdateなどイベントでフィールドの値が取れたりすればいいかなと。 Windows 8.1 Update をインストールした. MSDNで先行して公開されたWindows 8.1 Update を新規インストールしてみた。スタート画面とか私にはどうでもいいのだ。 ラベル: Windows 8.1. Chris Webb's BI Blog. SharePoi...
MukkuMuku備忘: 2015/07 - 2015/08
http://mukkumuku.blogspot.com/2015_07_01_archive.html
Power BI - 3 - OneDrive 上のファイルをソースにしてみる. OneDrive for Business に保存したファイル(*.xlsx)をソースとしてインポートしてみる。 Office 365 を使っているなら OD4B 使っているでしょうし、データセットの更新ができるので手軽でよいかなと。 データの取得] - [データのインポートまたは接続] - [ファイル]. Power BI - 2 - Excel ファイルをソースにして試してみる. ローカルのExcel ファイル(*.xlsx)のファイルをソースとして Power BI にインポートしてみる。 直接インポートすることになるのだけど、あらかじめの データ整形が必要なことがわかった。 まずは、[データの取得] - [データのインポートまたは接続] - [ファイル]. Power BI - 1 - GA ですよ. Power BI is Generally Available today. Power BI がリリースされたので使ってみる。 Office 365 ProPlus でインストール. Sentiment Analy...
MukkuMuku備忘: 2014/05 - 2014/06
http://mukkumuku.blogspot.com/2014_05_01_archive.html
Office 2013 クイック実行 Office 展開 - 7. New Application Selection feature offered with the May 2014 update of Office 2013 Click-to-Run. The Garage Series for Office 365: Updates to Office 365 ProPlus for admins and first look at upcoming shared computer support. かいつまむと、クイック実行 / Click-to-Run の Office 2013 および Office 365 ProPlus の展開において Office 製品のインストールをそれぞれカスタマイズできるというお話。 Office Deployment Tool for Click-to-Run. 更新されたツールと Build : 15.0.4615.1001 （2014/05/13公開分）以降のOffice が対象となる。 SPC 2014 で公開されていた Access 用コンテンツ アプリ.
MukkuMuku備忘: 2014/06 - 2014/07
http://mukkumuku.blogspot.com/2014_06_01_archive.html
Access 2013 ODBC リンク テーブル と SQL Server - 5. 集計クエリについても見ておく。Where条件を持つ選択クエリと概ね同じ。少しだけ気を付けておけば、SQL Server側で集計が実施されるはず。 SELECT Table 1.F Text, Sum(Table 1.F Num) AS SumOfF Num FROM Table 1 GROUP BY Table 1.F Text HAVING Sum(Table 1.F Num) 100;. SQLExecDirect: SELECT F Text ,SUM(F Num ) FROM dbo.Table 1 GROUP BY F Text HAVING (SUM(F Num ) 100 ). 期待通りの集計がされて、全レコードを取得するようなことはない。ただし、. Access 2013 ODBC リンク テーブル と SQL Server - 4. SQLExecDirect: SELECT ID ,F Num ,F Date FROM dbo.Table 1. SQLExecDirect: SELECT dbo&...
BI « sqlconcept.com
http://sqlconcept.com/category/bi
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. Creating and populating Date dimension in a DW for use in SSAS. Here is a script I found on SQLDusty’s blog on how to populate a Date dimension. I am re-posting this script here so I can have access to it at any time. Props to Dustin! View Code TSQL–Make sure you set the Start and End Date below on row 58 and 59. 8211;Create the tables.
Baselining « sqlconcept.com
http://sqlconcept.com/category/baselining
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. SQL Server 2012 Full-Text search and XML Search - the Wiki project. Finally, here are some results from the Wiki project. After a few days of development, here is the accounting for the wiki project:. Desktop PC with 8Gb RAM, single home use HDD. SQL Server 2012, using XML and Full-Text search. The total amount of data to be imported: 39.2 GB. The rea...
Becoming a sponsor « sqlconcept.com
http://sqlconcept.com/becoming-a-sponsor
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. So far I have been keeping this site away from advertisement at any rate. And yes, the rate is high. I pay out of my pocket for:. My family and friends’ free time. However, I am open to suggestions. If you think that this site should get colored by advertisement – feel free to drop me a line. And make me an offer. Who knows, I might go for it.
My Articles « sqlconcept.com
http://sqlconcept.com/my-articles
Contact . . . Tools . . . . . Products . . . SQL GAP . . . About . . . Extracting value from data: learning, exploring, visualizing. SQL Server Agent jobs. HDDs, SSDs and Database Considerations. By Feodor Georgiev, 09 January 2013. In this article Feodor clears up a few myths about storage, explains the difference in how HDDs and SSDs work and looks into the considerations every DBA should have in mind when choosing / working with SSDs. Read more…. How come the Hourglass? As the volume of data increases...
TOTAL LINKS TO THIS WEBSITE
98
SQL Server Best Practice – SQL Server Installation and Configuration Best Practices
SQL Server Best Practice. SQL Server Installation and Configuration Best Practices. Host Memory and SQL Server. Local Security Policies for SQL Service Account. Implementing relevant SQL Server Best Practices. Is the first step in attaining this flexibility and therefore having a happy thriving business. Preparation is the key to attain a good SQL Server performance baseline and therefore limiting significant IT costs further down the line. Your Privacy is Safe. SQL Configuration Health Checks.
SQL SERVER E B.I
SQL SERVER E B.I. Edições do novo SQL Server 2012. Como era de se esperar, o lançamento do SQL Server 2012 veio com muitos recursos novos. Mas antes de falar sobre esses recursos vamos falar sobre as mudanças na linha de produtos do SQL Server 2012. Nessa nova linha de produtos do SQL Server 2012 teremos as seguintes edições: Enterprise, Standard, Business Intelligence, Web, Developer e Express. Vamos a uma rápida visão sobre cada edição:. SQL SERVER 2012 ENTERPRISE. SQL SERVER 2012 STANDARD. Essa edição...
SQL Server Blog – Informationen für Einsteiger und Profis von Benjamin Hoch
Informationen für Einsteiger und Profis von Benjamin Hoch. Sperren von Seiten im Speicher. Level – Einsteiger. Wie verhindert man, das die Daten des SQL Server im Pagefile landen. MCSA SQL Server 2016. Seit kurzem ist die Microsoft Prüfung 765: Provisioning SQL Databases für den SQL Server 2016 aus der Beta Phase raus und kann nun regulär abgelegt werden. SQL Express – Sicherung mit der Powershell. Hinweise: 11.11.2016 Anleitung für die Aufgabenplanung ergänzt. Die SQL Express Edition erfreut sich gerade...
Paul Turley's SQL Server BI Blog | sharing my experiences with SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Dashboards & Visualization
Paul Turley's SQL Server BI Blog. Sharing my experiences with SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Dashboards and Visualization. Power BI Hands-on Workshop. SQL Server Ver Poll. Podcast, SSRS Book and PASS Business Analytics Day. January 8, 2017. This past week, I had the honor of being interviewed by Carlos Chacon and Steve Stedman from the SQL Data Partners Podcast. PASS Business Analytics Day in Chicago. If you are attending, make sure you have the la...
SQL Server Bible: Smart Database Design Seminar
Follow PaulNielsen at http:/ twitter.com. Why use Stored Procs? 10 lessons from 35K tps. Welcome to SQLServerBible.com. Smart Database Design Seminar. Oct 26,27,28. Design for scalability, extensibility, usability, and integrity. Go beyond Normalization and design flexible data-drive databases. Use best practicesto build out your abstraction layer. Know when and how to optimize. The layers: Schema, Queries, Indexes, and Concurrecy. SQL Server MVP Deep Dives. SQL Server 2008 Bible. Your free monthly dose ...
Paul Turley's SQL Server BI Blog | sharing my experiences with SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Dashboards & Visualization
Paul Turley's SQL Server BI Blog. Sharing my experiences with SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Dashboards and Visualization. Power BI Hands-on Micro Workshop. SQL Server Ver Poll. Datazen Visual Control Categories. August 12, 2015. These controls are used to filter the data displayed in other controls. Displays a range of time/date values. Supports years, quarters, months, days, hours. Supports one or multiple metric fields. Similar to Time Navigator.
sqlserverbisolutions.blogspot.com
SSIS,SSRS,SQL Server Information
SSIS,SSRS,SQL Server Information. The Sqlserverdb provides maximum information about ssis,ssrs,sql server technologies and provides interview questions and videos and real time scenarios. Saturday, January 24, 2015. SQL SEVER INTERVIEW QUESTION. 1 What is the default "SORT" order for SQL SEVER? 2 select adresses which are between " 1/1/2015" and "1/04/2015"? 3why should you use CTE rather than using simple views? Labels: best sql server interview questions. Sql server interview questions. NULL, 'Q' ),.
SQL Server BI Tips | Lessons learned from the day-to-day work of a BI practitioner
SQL Server BI Tips. Lessons learned from the day-to-day work of a BI practitioner. Questions About SQL Server Scalability. May 15, 2014. Here are the latest TPC-H results, which is the standard for benchmarking data warehousing workloads:. SQL Server 2014 sets world record breaking performance according to TPC benchmarks:. Http:/ blogs.technet.com/b/sqlman/archive/2014/04/23/sql-server-2014-sets-world-record-breaking-performance-according-to-tpc-benchmarks.aspx. Top Ten Price/Performance Results:. Excel ...
sqlserverblogforum.blogspot.com
SQL Server Blog Forum
SQL Server Blog Forum. Helping SQL server DBAs and Developers. Wednesday, October 19. Website redirected www.sqlserverblogforum.com. Hello readers, followers and subscribers my website redirected from here to http:/ www.sqlserverblogforum.com/. Subscribe the same on my new website(Top corner right side - Enter your email) and get a new post automatically via email. Please Give me your feedback/comments http:/ www.sqlserverblogforum.com/about-me/. Wednesday, October 19, 2011. Links to this post.
Sql server Blog Forum - Helping SQL server DBAs and Developers
Sql server Blog Forum. Helping SQL server DBAs and Developers. Lost Administrator SA password SQL server 2012. Published on: July 27, 2014. Tags: recover sa password. There are many blog posts talking about, how to recover SysAdmin password in case if it’s lost OR the server is new to you and no idea that has own and access to it. In my case the second option J. In my opinion, it’s very easy to work on GUI instead of command line CMD. I used a SSMS. 1 Stop the SQL server agent. 3 Reboot the SQL service.
SQLServer Bloggen
SQL server tips av Joel Sjöö. Tisdag 14 juni 2016. Kul med Transact SQL och Windowing funktioner. När jag tittade över min tjänstepension senast så funderade jag på hur mycket utdelningar har man fått sen starten på den. Tittade lite på vilket data man kunde få ut från Nordnet. Enkelt gick det ju att exportera all transaktionshistorik sen starten så sagt och gjort. Efter ett par försök så hade jag datat i en tabell i SQL servern. Bokföringsdag] [date] NULL,. Affärsdag] [date] NULL,. Antal] [int] NULL,.
SOCIAL ENGAGEMENT