THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server 2016   (RSS)
Showing page 1 of 5 (46 total posts)
  • SQL Server 2016 Import and Export Wizard and Excel

    SQL Server 2016 is a 64-bit application and it comes with two versions of the Import and Export Wizard. If you launch the Import/Export Wizard from the SSMS, the 32-bit version is invoked. The 64-bit version does not natively provide support for Excel files. There’s a lot of bad, outdated, or complex advice on how to fix the problem. I was able to ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 11, 2017
  • From ElasticSearch back to SQL Server

    Sharing with the community why we decided to move back from ElasticSearch to SQL Server Sometimes it happens: you move to something that is considered cool and bleeding edge back to something that has dust over it. Well, at least this is how SQL Server has been perceived lately by the majority of developers and software architects. Microsoft ...
    Posted to Davide Mauri (Weblog) by manowar on May 23, 2017
  • PASS AppDev next webinar: “Introducing R”

    On May 25th the PASS Application Development Virtual Group will host a new webinar delivered by the well know Dejan Sarka and the topic will be R (https://www.r-project.org/) that is more and more used also by developers: Introducing R R is a free software programming language and software environment for statistical computing, data mining, ...
    Posted to Davide Mauri (Weblog) by manowar on May 4, 2017
  • PASS AppDev Recording: “Building REST API with SQL Server using JSON functions”

    Last week Jovan Popovic (SQL Server Program Manager for JSON support and other nice things) delivered a very interesting webinar on JSON and SQL Server / Azure SQL for the PASS Application Development Virtual Group. If you’re interested in the subject, here’s a couple of links that will make you happy: Full recording is on PASS Development ...
    Posted to Davide Mauri (Weblog) by manowar on April 30, 2017
  • PASS Application Development Virtual Group

    I've been involved with PASS, once named Professional Association of SQL Server users, now just...PASS, since 2006 when I stepped up as president of SQL Server Italian User Group. Now that I moved to Redmond, WA, I'm still involved with it, but of course, I'm not leading the Italian User Group anymore. Since I do really think that community ...
    Posted to Davide Mauri (Weblog) by manowar on April 11, 2017
  • For The Better Developer: SQL Server Indexes

    Indexes? Indexes are a key factor for a database, relational or not. Without indexes the only option for a database would be to read all the data and discard what is not needed. Very inefficient. If a query has a where or a join or a group by clause and you feel performances are not good, before trying to figure out how to cache results in order ...
    Posted to Davide Mauri (Weblog) by manowar on April 1, 2017
  • Speaking at the SQL Server Seattle User Group in April

    I’m happy to share that I’ll be speaking at the next SQL Server Seattle User Group meeting on April 13th. The topic is again Temporal Tables a subject I love a lot and that is 100% useful in possible roles: dev, dba or bi guy. Temporal Tables with SQL Server 2016, vNext and Azure SQL Keeping track of how data changed over time in a table has ...
    Posted to Davide Mauri (Weblog) by manowar on March 24, 2017
  • A new (to me, and possibly you) SSMS feature - Query Plan Comparing

    Wow, Microsoft has really changed in culture recently. This new rapid release cycle for SSMS is seemingly paying dividends in a major way. In a recent build of SSMS (okay, perhaps not "recent", more like this October of 2015, according to this blog by the MSSQL Tiger Team:), they added the ability to compare query plans. I tried it on a ...
    Posted to Louis Davidson (Weblog) by drsql on January 26, 2017
  • SQL Server 2016 SP1 shocks the world!!!

    The entire World has been shocked today! We have never expected to see something like this. Go, grab SQL Server 2016 SP1 and you get all those: (picture from SQL Server Release Services page) Holly Molly!!!! Now in SQL Server 2016 Express you have (for FREE): row level security dynamic data masking database snapshot columnstore ...
    Posted to Damian Widera (Weblog) by Damian Widera on November 16, 2016
  • New Server Timings features in DAX Studio 2.5.0 #dax #powerbi #ssas #tabular

    Last week, a new version of DAX Studio (2.5.0) has been released. You can find a summary of the new features in the blog post from Darren Gosbell - thanks Darren for your wonderful job with this tool! My small contribution to this tool is mainly in the area of performance analysis. In the last few months, I worked on implementing a support for ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 1, 2016
1 2 3 4 5 Next >
Privacy Statement