• Rebuild and reorganize indexes with Index Manager for SQL Server
    Articles,  Blog

    Rebuild and reorganize indexes with Index Manager for SQL Server

    Index Manager by Devart lets you quickly and easily find out the status of indexes and discover which tables need maintenance. Index Manager is launched from within the SQL Server Management Studio. Just choose a database you want to analyze and invoke the tool from the shortcut menu. As you can see, the tool has automatically defined the database indexes that require defragmentation. Index Manager automatically chooses indexes to be rebuilt or reorganized depending on the preset thresholds. To view the index maintenance script in a new SQL document, click the Script Changes button and select the corresponding option from the dropdown list. Click Fix fragmentation to make dbForge Index…

  • DevOps Automation tool for SQL Server database
    Articles,  Blog

    DevOps Automation tool for SQL Server database

    We’re glad to present dbForge DevOps Automation for the SQL Server product, which can be integrated with PowerShell and Jenkins and allows setup of the DevOps process. With the help of our solution, you can set up your company’s DevOps process all the way from development to production server deployment, with the ability to monitor the server’s performance. The whole process is wrapped in a single logical chain which includes all products from dbForge’s mainline – each one of them being a crucial link in this chain. Let’s look at how you can organize a simple DevOps process through PowerShell by using dbForge DevOps Automation. First, we’ll need to create…

  • 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…

  • How Do I Analyze a SQL Server Execution Plan? (Dear SQL DBA Episode 50)
    Articles,  Blog

    How Do I Analyze a SQL Server Execution Plan? (Dear SQL DBA Episode 50)

    Welcome to Dear SQL DBA, a podcast for SQL Server developers and database administrators. I’m Kendra Little from SQLWorkbooks.com. This week I’m talking about a question that I recently got from a student– but I’ve gotten it from different people by email over the years, too. We’re talking about how to analyze a SQL Server execution plan. Here’s how the question came in this time: a student asked, “I’ve got a terribly performing query, and I’ve collected a complex execution plan for it. But I’m not sure how to interpret valuable information from the plan. Big picture: What do i do? How do i attack this thing?” We’re gonna talk…

  • 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…