Dustin Ryan is an MSBI consultant, trainer, speaker & author specializing in data warehousing, SSAS, SSIS, SSRS, Power BI and SharePoint (by Dustin Ryan)
http://www.sqldusty.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Tuesday
LOAD TIME
0.6 seconds
16x16
32x32
64x64
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
87
SITE IP
192.0.78.24
LOAD TIME
0.625 sec
SCORE
6.2
SQL with Dustin Ryan | Dustin Ryan is an MSBI consultant, trainer, speaker & author specializing in data warehousing, SSAS, SSIS, SSRS, Power BI and SharePoint | sqldusty.com Reviews
https://sqldusty.com
Dustin Ryan is an MSBI consultant, trainer, speaker & author specializing in data warehousing, SSAS, SSIS, SSRS, Power BI and SharePoint (by Dustin Ryan)
sqldusty.com
SSIS | SQL with Dustin Ryan
http://sqldusty.com/category/ssis
SQL with Dustin Ryan. Refreshing Excel Power Query and Pivot Tables with SSIS and Task Factory. August 14, 2015. With SSIS 2014 and earlier there is currently not native way to refresh an Excel workbook which include Power Query queries. Now that functionality is rumored to be included with SQL Server 2016 but if you’re currently running SQL Server 2014 or 2012 you are out of luck. But that’s why Pragmatic Works put together the Excel Power Refresh component for SSIS. July 21, 2015. January 6, 2014.
Refreshing Excel Power Query & Pivot Tables with SSIS and Task Factory | SQL with Dustin Ryan
http://sqldusty.com/2015/08/14/refreshing-excel-power-query-pivot-tables-with-ssis-and-task-factory
SQL with Dustin Ryan. Refreshing Excel Power Query and Pivot Tables with SSIS and Task Factory. August 14, 2015. With SSIS 2014 and earlier there is currently not native way to refresh an Excel workbook which include Power Query queries. Now that functionality is rumored to be included with SQL Server 2016 but if you’re currently running SQL Server 2014 or 2012 you are out of luck. But that’s why Pragmatic Works put together the Excel Power Refresh component for SSIS. First create a Connection. Power BI ...
SSAS | SQL with Dustin Ryan
http://sqldusty.com/category/ssas
SQL with Dustin Ryan. 10 SQL Server Data Warehouse Design Best Practices to Follow (Part 1 ). May 16, 2016. This past Saturday I had the pleasure of speaking at SQL Saturday #552 here in beautiful Jacksonville, Florida. My good friend, Mitch Pearson ( blog. And I presented our session, Designing a Data Warehouse from the Ground Up. We had a great crowd and lots of great questions from the audience! Watch Designing a Data Warehouse from the Ground Up Webinar Recording. March 24, 2016. For having me to pre...
dataviz | SQL with Dustin Ryan
http://sqldusty.com/category/dataviz
SQL with Dustin Ryan. Power BI Desktop Designer. 5 More Power BI Tips. June 29, 2016. I’ve had this blog post in my mind to write for the past month or so and I’m finally just getting around to it while I’m waiting to board my flight back home. Check out my first 5 Power BI Tips here. Continue reading 5 More Power BI Tips. Power BI calculated column. Power BI and the Bing Maps API. April 26, 2016. New to Power BI? Start with these 5 tips! Power query Bing Map api. Power BI Desktop Designer. Make no mista...
#PowerBI Tip: Use the Treemap, Column or Funnel Chart as a Colorful Slicer | SQL with Dustin Ryan
http://sqldusty.com/2015/08/03/power-bi-tip-use-the-treemap-chart-as-a-colorful-slicer
SQL with Dustin Ryan. Power BI Desktop Designer. PowerBI Tip: Use the Treemap, Column or Funnel Chart as a Colorful Slicer. August 3, 2015. Power BI Desktop has been out for GA for over a week now and some of the pro’s out there have come up with some pretty cool tricks. For instance:. You’ve got Jason Thomas and his custom Power BI indicators. Adolfo Socorro came up with a neat way to view map data at a high level and low level simultaneously. What do you think? Leave me a comment below and let me know&...
TOTAL PAGES IN THIS WEBSITE
19
Use BIxPress Package Builder Wizard To Recreate SSIS Packages | The SQL Lounge
https://thesqllounge.com/2014/05/18/tired-of-recreating-similar-ssis-packages-use-bixpress-package-builder-wizard
Use BIxPress Package Builder Wizard To Recreate SSIS Packages. SQL Server Integration Services. Use BIxPress Package Builder Wizard To Recreate SSIS Packages. Posted by Anthony Coleman. On May 18, 2014 in BI xPress. BIxPress simplifies SSIS and makes your life much easier as developer. BIxPress is a plug in for your BIDS environment and removes a lot of redundancy in everyday SSIS development. It can be launched within BIDS or as a standalone application. So the question is how can BIxPress help you?
PDW | The SQL Lounge
https://thesqllounge.com/pdw
Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. You are commenting using your Facebook account. ( Log Out. You are commenting using your Google account. ( Log Out. Notify me of new comments via email. Create a free website or blog at WordPress.com. My thoughts on Data. Anthony Martin's Blog.
Anthony Coleman | The SQL Lounge
https://thesqllounge.com/author/anthonycoleman5
Posts by Anthony Coleman. Author Archives: Anthony Coleman. Posted by Anthony Coleman. One of my current goals is to take the 70-461 Querying Microsoft SQL Server 2012 exam. I am already confident in my skills as a SQL Developer, but studying and passing this exam will help reinforce some of the topics that I already know and will be an exciting opportunity to learn more! If you’re […]. Use DocxPress to Document Your Environment. Posted by Anthony Coleman. BixPress SSIS Unit Testing. BIxPress simplifies ...
SQL Server Integration Services | The SQL Lounge
https://thesqllounge.com/tag/sql-server-integration-services
SQL Server Integration Services. Tag Archives: SQL Server Integration Services. Use BIxPress Package Builder Wizard To Recreate SSIS Packages. Posted by Anthony Coleman. BIxPress simplifies SSIS and makes your life much easier as developer. BIxPress is a plug in for your BIDS environment and removes a lot of redundancy in everyday SSIS development. It can be launched within BIDS or as a standalone application. So the question is how can BIxPress help you? One way that this product […]. My thoughts on Data.
BixPress SSIS Unit Testing | The SQL Lounge
https://thesqllounge.com/2014/06/08/bixpress-ssis-unit-testing
BixPress SSIS Unit Testing. BixPress SSIS Unit Testing. Posted by Anthony Coleman. On June 8, 2014 in BI xPress. SSIS Unit Testing is an exciting new feature in BixPress that allows developers and users to ensure that a package is performing exactly the way that it was intended to. Today I will walk you through an example of how I used SSIS Unit Testing to take advantage of some of its cool features. There are a lot of other cool features in the SSIS Unit Testing framework, like creating custom data sets...
SSAS | The SQL Lounge
https://thesqllounge.com/ssas
Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. You are commenting using your Facebook account. ( Log Out. You are commenting using your Google account. ( Log Out. Notify me of new comments via email. Blog at WordPress.com. Azure Business Intelligence. SQL Server. Nerd Stuff. My thoughts on Data.
July | 2014 | The SQL Lounge
https://thesqllounge.com/2014/07
Posts made in July, 2014. Monthly Archives: July 2014. Use DocxPress to Document Your Environment. Posted by Anthony Coleman. SQL Anthony On Twitter. Books I’ve Worked On. SQL Server Integration Services. Create a free website or blog at WordPress.com. Azure Business Intelligence. SQL Server. Nerd Stuff. Business Intelligence, Big Data and Other Ramblings. My thoughts on Data. Anthony Martin's Blog. SQL Server and Microsoft BI. Data Adventures with a Architect. SQL with Dustin Ryan.
BIxPress | The SQL Lounge
https://thesqllounge.com/tag/bixpress
Use BIxPress Package Builder Wizard To Recreate SSIS Packages. Posted by Anthony Coleman. BIxPress simplifies SSIS and makes your life much easier as developer. BIxPress is a plug in for your BIDS environment and removes a lot of redundancy in everyday SSIS development. It can be launched within BIDS or as a standalone application. So the question is how can BIxPress help you? One way that this product […]. SQL Anthony On Twitter. Books I’ve Worked On. SQL Server Integration Services. My thoughts on Data.
Use DocxPress to Document Your Environment | The SQL Lounge
https://thesqllounge.com/2014/07/06/use-docxpress-to-document-your-environment
Use DocxPress to Document Your Environment. Use DocxPress to Document Your Environment. Posted by Anthony Coleman. On July 6, 2014 in DocxPress. BixPress SSIS Unit Testing. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. You are commenting using your Facebook account. ( Log Out. My thoughts on Data.
HDInsight | The SQL Lounge
https://thesqllounge.com/hdinsight
Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. You are commenting using your Facebook account. ( Log Out. You are commenting using your Google account. ( Log Out. Notify me of new comments via email. Create a free website or blog at WordPress.com. My thoughts on Data. Anthony Martin's Blog.
TOTAL LINKS TO THIS WEBSITE
87
Sqldude's Blog | A random Collection of SQL
A random Collection of SQL. Month name from month number. December 13, 2010. At times, we have to get the month name and all that we have is a month number, here is a quick smart way to get the name of the month corresponding to the month number:. SET @month = 4. SELECT DateName(mm,DATEADD(mm,@month,-1) Month. To get the list of all the months spelled our along with their corresponding month numbers:. SELECT Number 1 as [Month Number],. DateName(mm,DATEADD(mm,Number,0) as [Month Name]. From → Scripts.
SQL Dumbass
Fighting dumbasses, one query at a time…. This is the top bar widget. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis quis ipsum magna, sit amet ultricies nulla. Phasellus justo neque, interdum sed porta tempus, dapibus eu augue. Curabitur quis dolor ac nunc accumsan ultricies. Praesent et diam orci, id tincidunt massa. Nunc ut tortor turpis. Share the Love, Dumbass! September 6th, 2011. Enjoy and have fun, and don’t make it personal (or offensive) or you will find yourself banned. July 20t...
Welcome my SQL Dump - Marcus' SQL Dump
Oracle queries and stuff that I need frequently. Perf, Traceing, Auditing. Hint for a good optimizer index cost adj value. Deleteing failed datapump jobs. Query PGA/UGA sizes by SID. Last analyzed - Statistics. PROCESSES Parameter to low? Converting Date to TIMESTAMP TZ. Size PGA and SGA. It seems you have no tags attached to pages. To attach a tag simply click on the. Button at the bottom of any page. Add a new page. Welcome my SQL Dump. Use the navigation bar on top to get to the real content. Notify a...
sqldumps.com - Registered at Namecheap.com
This domain is registered at Namecheap. This domain was recently registered at Namecheap. Please check back later! This domain is registered at Namecheap. This domain was recently registered at Namecheap. Please check back later! The Sponsored Listings displayed above are served automatically by a third party. Neither Parkingcrew nor the domain owner maintain any relationship with the advertisers.
SQL Database Resources & Data Base Dumps for MySQL, CSV, Access & Oracle
Food and Drink databases. Welcome Guest, please login. Welcome to SQL Dumpster. Hello We provide databases in ready to use formats including CSV and SQL database dumps. We provide databases for website designers. Software developers, direct marketing and market research. We supply website content. Marketing lead databases, directory data for location based services and other business listings. Range from postcode data. To football player databases. And everything in between! Car makes and models.
SQL with Dustin Ryan | Dustin Ryan is an MSBI consultant, trainer, speaker & author specializing in data warehousing, SSAS, SSIS, SSRS, Power BI and SharePoint
SQL with Dustin Ryan. Here’s the New #Excel 2016 Chart Types! Power BI Desktop Designer. PowerBI Tip: Use the Treemap, Column or Funnel Chart as a Colorful Slicer. Power BI Desktop Designer. Three Best Practices for #PowerBI. MDXMonday: Previous Year Month to Date Calculation. Power BI Desktop Designer. Power BI Desktop: My First Run Through. 3 SSAS Dimension Design Best Practices to Live By. Refreshing Excel Power Query and Pivot Tables with SSIS and Task Factory. August 14, 2015. Once you create your c...
SQLDV - SQL with data Domains and Versions
SQLDV - SQL with data Domains and Versions. SQLDV is not a product (yet). SQLDV is rather a request for SQL features and a request for comments. I expect this to exist already. If not: this can't be patented anymore because now it's published. After over 20 years of application development I have come to a point where I miss 2 features in standard SQL implementations. The letters D and V stand for the missing features. Data domains on record level. Versions on record level. Versions on record level.
SQLDVP
Friday, October 29, 2010. Meyyapan's sql fly demo. He is a gifted speaker. Very down to earth but very sharp. My taek away from the session is that:. 1 Make sure there are no sort warnings. If that is happening , the cache is spilling to tempdb. 2 best practices like one file on tempdb per core may be counter producitonve if your streaming is geared for only sequential I/O. If you have SAn infra-structure then it can handle up to 16 streams? Tuesday, December 22, 2009. Works for SQL Server 2005. FK NOT F...
SQL Delta
SQL Delta has been re-engineered from the ground up and is better than ever. With a new tabbed interface you can run multiple projects simultaneously, whether comparing the data within two tables or the schema of two large databases. You can even start designing a new database structure while running a large data compare in background. Find out more. New and Improved Features. Learn about what's new. SQL Delta for SQL Server now supports all modern releases of Microsoft SQL Server. What is SQL Delta?
宿迁格力中央空调|宿迁美的中央空调|宿迁空调维修保养-宿迁零度制冷官网
SOCIAL ENGAGEMENT