LaConnecta Loading please wait..
Back to Home

Sql Top Stories

Sql's History

Steve Jones - SSC Editor, SQLServerCentral Blog

2020 Advent of Code–Day 3

This series looks at the Advent of Code challenges. As one of my goals, Im working through challenges. This post looks at day 3. Part 1 Day 3 was...The post 2020 Advent of Code–Day 3 appeared first o..

Continue reading at source

Randolph West, SQLServerCentral Blog

Welcome to the Azure Data Community, empowered by Microsoft

After the Professional Association of SQL Server PASS unceremoniously closed down in January this year and its video library & brand names were bought by Red Gate Software Ltd, it...The post Wel..

Continue reading at source

Steve Jones - SSC Editor, SQLServerCentral Blog

Daily Coping 24 Feb 2021

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. Im...The post Daily Coping 24 Feb 2021 appea..

Continue reading at source

SQLEspresso, SQLServerCentral Blog

Identifying SQL Server Performance Problems Part 3

Continuing with our Performance Tuning series as you have learned baselining and knowing your normal system performance metrics is an important part of performance tuning. In part 1 we...The post Iden..

Continue reading at source

matthew.mcgiffen 73574, SQLServerCentral Blog

Automatic Sample Sizes for Statistics Updates

Looking at how SQL Server samples your data when doing auto-stats updates. Part of a series on understanding statistics, to help you achieve optimal performance of your queries on...The post Automatic..

Continue reading at source

Rahul Mehta, SQL Shack

Analyze Azure Cosmos DB data using Azure Synapse Analytics

This article will help you understand how to analyze Azure Cosmos DB data using Azure Synapse Analytics. Introduction Azure Cosmos DB is a multi-model NoSQL database that supports hosting various type..

Continue reading at source

Aveek Das, SQL Shack

Exporting data with Pandas in Python

In this article, I am going to discuss the various ways in which we can use Pandas in python to export data to a database table or a file. In my previous article Getting started with Pandas in Python,..

Continue reading at source

Pinal Dave, Journey to SQL Authority with Pinal Dave

Kindle eBook – How to Become Successful Blogger

The name of the book is How to Become Successful Blogger and it is available to download via Kindle eBook over here. Let us discuss.First appeared on Kindle eBook – How to Become Successful Blog..

Continue reading at source

Rajendra Gupta, SQL Shack

Deploy Azure Data Lake Analytics database using the U-SQL scripts

In this 3rd article of the Azure Data Lake Analytics series, we will explore deploying a database, tables using U-SQL scripts. Introduction In the earlier articles of the series, we explored the U-SQL..

Continue reading at source

kleegeek, SQLServerCentral Blog

Cannot expand VMDKs with NVMe storage controller on VMware without a reboot

After doing some digging today with a Client, we hit a roadblock on something that I need to share with using the NVMe virtual disk controller on the VMware...The post Cannot expand VMDKs with NVMe st..

Continue reading at source

Brent Ozar, Brent Ozar Blog

New SQL ConstantCare® Feature: One Serious Query to Tune

Our monitoring tool, SQL ConstantCare®, is different. Some monitoring tools send you a whole bunch of emails for every little thing that’s happening on every one of your server – and havin..

Continue reading at source

Devin Knight, SQLServerCentral Blog

Power BI Monthly Digest – February 2021

In this months Power BI Digest Matt and I will again guide you through some of the latest and greatest Power BI updates this month.The post Power BI Monthly Digest – February 2021 appeared first on S..

Continue reading at source

Pinal Dave, Journey to SQL Authority with Pinal Dave

SQL SERVER – Fix: There is already an object named ‘MyFirstTable in the database

Recently I had a very interesting scenario with a client when they faced an error about already object named that exist in the database.First appeared on SQL SERVER – Fix: There is already an ob..

Continue reading at source

Rayis Imayev, SQLServerCentral Blog

Upgrading Durable Function Extension of my Azure Function App

2021-Feb-22 With more applications and services being placed into a vendor cloud environment, it does require almost no effort to manage and maintain the infrastructure these applications and servic..

Continue reading at source

Randolph West, SQLServerCentral Blog

Calgary Data User Group – 24 February 2021 at 5pm MST

This Wednesday, from 5pm to 7pm Mountain Standard Time, the Calgary Data User Group is presenting two sessions for your virtual attendance. 15 minutes: A lightning talk on Kubernetes...The post Calgar..

Continue reading at source

Steve Jones - SSC Editor, SQLServerCentral Blog

The PASS Pro Videos are Live

The PASS Pro program was an interesting educational opportunity that came out last year. A number of people subscribed, including me. I did this more to support the org...The post The PASS Pro Videos ..

Continue reading at source

ThatJeffSmith

Launching SQL Developer Web from your Oracle Autonomous Cloud Service Console

A quick but important update for working with your database tools in Oracle Autonomous Database in the Oracle Cloud.The post Launching SQL Developer Web from your Oracle Autonomous Cloud Service Conso..

Continue reading at source

Steve Jones - SSC Editor, SQLServerCentral Blog

Daily Coping 22 Feb 2021

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. Im...The post Daily Coping 22 Feb 2021 appea..

Continue reading at source

Omelchenko Alexander, SqlBak Blog

How to Automate MongoDB Database Backups in Linux

NoSQL databases allow us to redefine the way we interact with data. However, data protection requirements remain the same as for SQL databases. One of the main ways to protect your data is to back it ..

Continue reading at source

Diligentdba 46159, SQLServerCentral Blog

Old but not gone

I am part of a weekly talk show we run at the TriPASS user group, called ‘Shop Talk. Shop Talk was the brainchild of Kevin Feasel, our key user...The post Old but not gone… appeared first on SQLServe..

Continue reading at source