jonmorisissqlblog.blogspot.com
Jon Morisi's SQL Blog: SQL Server 2014 Service Pack 2
http://jonmorisissqlblog.blogspot.com/2016/07/sql-server-2014-service-pack-2.html
Jon Morisi's SQL Blog. Jon Morisi's SQL BlogRoll. SQLSkills - 2014 Insider videos. SQL Server 2014 Service Pack 2. This months T-SQL Tuesday topic is: "treat yourself to a birthday gift". As it so happens Microsoft provided us an excellent gift in the form of SQL Server 2014 Service Pack 2. FIX: "Unable to create restore plan due to break in the LSN chain" error when you restore differential backup in SSMS. TYPE: BULK / bcp. Import support is added to the BCP utility and to the BULK INSERT Export support...
jonmorisissqlblog.blogspot.com
Jon Morisi's SQL Blog: sp_help returns the wrong length, or does it?
http://jonmorisissqlblog.blogspot.com/2016/07/sphelp-returns-wrong-length-or-does-it.html
Jon Morisi's SQL Blog. Jon Morisi's SQL BlogRoll. SQLSkills - 2014 Insider videos. Sp help returns the wrong length, or does it? This is just a quick blog about a basic sp help / data type storage gotcha. I was working with a contractor today who was having difficulty providing me back details on a table definition. I was specifically interested in a particular column's data type and size. (This was related to an ETL process I was working on, and my desire to avoid any implicit conversions). Oracle Linke...
jonmorisissqlblog.blogspot.com
Jon Morisi's SQL Blog: CAST as numeric rounding issue (Oracle Number to SQL Server numeric)
http://jonmorisissqlblog.blogspot.com/2016/07/cast-as-numeric-rounding-issue-oracle.html
Jon Morisi's SQL Blog. Jon Morisi's SQL BlogRoll. SQLSkills - 2014 Insider videos. CAST as numeric rounding issue (Oracle Number to SQL Server numeric). In working on a migration project, I discovered two different versions of SQL rounding and/or truncating implicit conversions from an Oracle NUMBER data type to a SQL Server numeric data type differently. Here's my test case:. Two servers, one running Microsoft SQL Server 2014 and another running SQL Server 2008 R2. Setup an Oracle 11g Linked Server.
jonmorisissqlblog.blogspot.com
Jon Morisi's SQL Blog: Hadoop in real world (UDEMY online course)
http://jonmorisissqlblog.blogspot.com/2016/09/hadoop-in-real-world-udemy-online-course.html
Jon Morisi's SQL Blog. Jon Morisi's SQL BlogRoll. SQLSkills - 2014 Insider videos. Hadoop in real world (UDEMY online course). In taking the Hadoop in real world online course at udemy.com. I ran into a couple of issues / items to work through in order to be successful with several of the lectures. I used this to download the hirw-workshop folder from the lab server. Eclipse Java EE IDE. The use of codenames can make things very confusing for first time users. There's another breakdown here. Control Pane...
jonmorisissqlblog.blogspot.com
Jon Morisi's SQL Blog: Recently Executed Stored Procedures
http://jonmorisissqlblog.blogspot.com/2016/01/recently-executed-stored-procedures.html
Jon Morisi's SQL Blog. Jon Morisi's SQL BlogRoll. SQLSkills - 2014 Insider videos. Recently Executed Stored Procedures. I put together the following in order to find a distinct list of the most recently executed stored procedures for auditing (reverse engineering) purposes:. Dm exec query stats. Sysdm exec sql text. Careful, it can take a while in prod. Subscribe to: Post Comments (Atom). Hadoop in real world. Amabari integration with Active Directory. Ambari Metrics Collector: Errno 111. Configure a pol...
jonmorisissqlblog.blogspot.com
Jon Morisi's SQL Blog: Jump into PowerBI!
http://jonmorisissqlblog.blogspot.com/2016/02/jump-into-power-bi.html
Jon Morisi's SQL Blog. Jon Morisi's SQL BlogRoll. SQLSkills - 2014 Insider videos. T-SQL Tuesday #75 Invitation: Jump into Power BI! At first look at PowerBI I immediately knew I wanted to use some of the more interesting visualizations like the Map. I'm also well of the viral video status of Hans Roslings TED talk. So I also looked for some sort of timeline visualization. Although not a native visualization I did find the Timeline. Although it's no Gapminder. That said, here's what I put together. OLE D...
jonmorisissqlblog.blogspot.com
Jon Morisi's SQL Blog: Oracle Linked Server Setup
http://jonmorisissqlblog.blogspot.com/2016/05/oracle-linked-server-setup.html
Jon Morisi's SQL Blog. Jon Morisi's SQL BlogRoll. SQLSkills - 2014 Insider videos. Oracle Linked Server Setup. First things first, you're going to need to know which version of Oracle you're going to be hitting and download the corresponding client. I'm downloading the 11g 64 bit client from here today:. Http:/ www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html. You can safely ignore this error message, by clicking "Yes". More installation type details are here:...
jonmorisissqlblog.blogspot.com
Jon Morisi's SQL Blog: OLE DB error: OLE DB or ODBC error: Query timeout expired; HYT00.
http://jonmorisissqlblog.blogspot.com/2016/04/ole-db-error-ole-db-or-odbc-error-query.html
Jon Morisi's SQL Blog. Jon Morisi's SQL BlogRoll. SQLSkills - 2014 Insider videos. OLE DB error: OLE DB or ODBC error: Query timeout expired; HYT00. When running Proactive Caching. In SQL Server Analysis Services Event ID 3, Category 289 is logged repeatedly. This is due to Proactive Caching Notification, tracking tables, and the ExternalCommandTimeout. The Event ID 3 errors can be ignored. Date: 4/11/2016 2:11:10 PM. OLE DB error: OLE DB or ODBC error: Query timeout expired; HYT00. OLE DB error: OLE DB ...
jonmorisissqlblog.blogspot.com
Jon Morisi's SQL Blog: R Services Roundup
http://jonmorisissqlblog.blogspot.com/2016/05/r-services-roundup.html
Jon Morisi's SQL Blog. Jon Morisi's SQL BlogRoll. SQLSkills - 2014 Insider videos. The SQL Server 2016 release date is June 1, 2016. Among the new features everyone is talking about is "R Services". Below is a quick reference of links related to "R Services":. Editions and Components of SQL Server 2016. Differences in R Features between Editions of SQL Server. In-database Advanced Analytics with R in SQL Server 2016. There are additional links at the bottom of this article including this video:. OLE DB e...
jonmorisissqlblog.blogspot.com
Jon Morisi's SQL Blog: Snarfing Data from a website and importing via the Import and Export Wizard
http://jonmorisissqlblog.blogspot.com/2016/05/snarfing-data-from-website-and.html
Jon Morisi's SQL Blog. Jon Morisi's SQL BlogRoll. SQLSkills - 2014 Insider videos. Snarfing Data from a website and importing via the Import and Export Wizard. Step 1, Snarf the data. In my example I'm going to a publicly facing website and simply copying and pasting the html table into excel:. Next save this as a csv file. This is pretty much a next, next, next, finish scenario (with a few selections that need to be made). Just follow along with the screenshots:. Flat File Source (choose your .csv).