• SQL Server 2019 | Query faster from any database. (Microsoft Ignite)
    Articles,  Blog

    SQL Server 2019 | Query faster from any database. (Microsoft Ignite)

    (logo sliding) (upbeat music) – Welcome to Microsoft Mechanics Live. (audience clapping) Hoo. Coming up, we take a closer look SQL Server 2019, now generally available. We’ll look at its expanded role as a data integration platform allowing you to bring in data from any source including on the Edge for analysis. In fact, we’ll show you how data location becomes irrelevant with a scenario that goes from the ground to the cloud, and introduce you to Azure SQL Database Edge. So, I’m please to be joined today by Buck Woody, an applied data scientist from the SQL engineering team. Welcome! Thanks for having me on the show. – It’s…

  • Importing data from CSV To SQL Server Table
    Articles,  Blog

    Importing data from CSV To SQL Server Table

    Hi friends I am Ved Prakash and today I am going to show you demo to import data from CSV file and insert into SQL Server table using SSIS So I’ll open Microsoft Visual Studio that is IDE for SSIS development I’ll go to file the new then project and I will select integration services project. There are so many other type of projects you can select here . CSV to SQL is okay here I’ll select data flow task if I double click I’ll come here and I can select my source so as I want to select data from CSV file that is flat file and select flat…

  • Introducing SQL Server 2019 | Data Exposed
    Articles,  Blog

    Introducing SQL Server 2019 | Data Exposed

    [MUSIC].>>Hey everyone. Welcome to this episode of data exposed. I’m Travis Wright, Group Product Manager for the SQL Server and Azure data engineering team at Microsoft. Today I’m excited to introduce to you a SQL Server 2019, the most recent released SQL Server. SQL Server is celebrating its 25th anniversary this year. That’s quite awhile. By look back on the early days of my career, I started on SQL Server 2000. In that 25-year history, SQL Server has really come a long ways. It’s really expanded to meet the needs of our customers over time as the different types of data that customers need to collect and process and query…

  • Artificial intelligence and machine learning with SQL Server 2019
    Articles,  Blog

    Artificial intelligence and machine learning with SQL Server 2019

    (upbeat music) Hello and welcome. My name is Sanjay Soni. Here is a micro-learning, readiness video. Hi Sanjay, thanks for having me. I’m Anna Thomas. I’m an applied data scientist on the Azure data team, and today I hope to show you a little bit more about ML and AI and some of the things we’re bringing to 2019. Awesome, yeah I know that SQL Server has had some kind of machine learning capabilities in the past, but what’s new? Yeah, sure. Let’s actually take a step back and kind of walk through this evolution of what’s happened with SQL Server ML. Maybe about four years ago, we acquired a…

  • Deploying and Exploring SQL Server on Linux
    Articles,  Blog

    Deploying and Exploring SQL Server on Linux

    >>Hi. I’m Bob Ward, from Microsoft from the SQL engineering team. I’m here to show you today a brief demonstration of the deployment experience of SQL Server on Linux, and a brief tour of some of the tools we’ve built to connect to SQL Server on Linux. Now in front of you, is a popular tool called MobaXterm that I’m running on Windows. I’m using that to connect it into a secured shell to a Linux server running Red Hat Enterprise Linux. On Red Hat, the package manager’s called Yum and so we have an RPM package format that adheres the yum package manager. So the first step I’m going…

  • SQL Server Scanner | How to find all SQL servers on network
    Articles,  Blog

    SQL Server Scanner | How to find all SQL servers on network

    When Lansweeper scans a Windows asset, it automatically retrieves SQL Server information found on the client machine. Lansweeper now also scans SQL Server cluster information, which can be useful for determining your licensing costs. In Lansweeper, under the software section of an asset, you can find all scanned SQL Server information. Valuable info such as SQL edition, License, Version and if the SQL Server is clustered or not can all be found here. Of course, there are also a number of built in reports available, so you can get a more global overview of the SQL servers in your network. Retrieving and centralizing all this IT asset information in one…

  • 2016 TESTLAB 3 : Implement WSUS in SERVER 2016 first time, everytime!
    Articles,  Blog

    2016 TESTLAB 3 : Implement WSUS in SERVER 2016 first time, everytime!

    hey guys and welcome to the video today i’m going to be bringing you the most exciting video of them all we’re going to be looking at SUS software update services so for those that don’t know what SUS is a break it down for you quick style services the way of bringing windows update on prep and that’s about it it just basically just reduce your bandwidth and stops you from hammering microsoft all the time for all of the update and to be honest it’s the most interesting video I’ve ever done sorry nodded off there so some services seems to be an elusive subject for so many…

  • It Just Runs Faster: SQL Server 2019 TempDB Improvements | Data Exposed
    Articles,  Blog

    It Just Runs Faster: SQL Server 2019 TempDB Improvements | Data Exposed

    [MUSIC]>>Hi. I’m Pam, and I’m a Program Manager with the SQL Server Engineering team in the storage engine area. Today in this video, I’d like to talk to you a little bit about some of the improvements that are coming in SQL Server 2019 for TempDB performance. So let’s start with a little bit of a background on TempDB. What is it? It’s essentially just a database like any of your other user databases. The difference with TempDB is it’s used for temporary storage. So that means it’s not durable. We recreate it every time the server is started, and we’re able to do things like minimally logged transactions, because…