Beginner Guide to In-Memory Optimized Tables in SQL Server

Microsoft added the In-Memory OLTP (aka memory optimized tables) feature to SQL Server 2014. Operations to this type of table do not need locks, therefore eliminating blocking and deadlocking. In this Article, Monica Rathbun demonstrates how to get started using memory optimized tables.

16th Feb 2020

Methods to script SQL Server database objects

In this article, we will explore various ways for scripting SQL Server database objects. DBAs and developers manage environments for a SQL database. While managing multiple copies, sometimes we require the following tasks.

16th Feb 2020

How to Delete Millions of Rows Fast with SQL

It's a rare event. Removing data from a table. But every now and then you may need to do a bit of spring cleaning and clear down data. This is easy to do with delete.

14th Feb 2020

I can do better; we can do better; let’s do better

In the past week or so, the Microsoft Data Platform community has begun having a discussion about inclusivity, both on Twitter and across community blog posts.

14th Feb 2020

Unlocking the Benefits of MariaDB’s Certified Associate Program

Businesses around the globe continue to accumulate colossal amounts of data. An estimated 50 billion connected devices are expected by 2030¹. Database administrators (DBAs) are the central technologists within these business organizations, ensuring data integrity and competency.

14th Feb 2020

Learn SQL: SQL Data Types

What are SQL data types, why do we need them, and how to use them? Today, we’ll try to answer these questions by giving an overview of some most common data types used in SQL Server.

14th Feb 2020

SQLDev Quick Tip: Labeling your SQL Query Results

I’ve been watching you. It gets worse, I’ve seen how many Chrome tabs you have open too. Hint…it’s a LOT.

14th Feb 2020

A quick search without an index – SQLServerCentral

We all have days at work when someone comes to us with that truly impossible request which will require a miracle to accomplish.

14th Feb 2020

Improving Data Imports in CockroachDB with `nodelocal`

This past fall, I had the opportunity to intern on the relatively new Bulk I/O team at Cockroach Labs. Our team’s focus is to improve bulk data operations on CockroachDB.

13th Feb 2020

T-SQL Tuesday #123: SSMS tips to make your day easier

I thank Jes Pomfret (blog|twitter) for hosting T-SQL Tuesday #123. The topic for this month is Life hacks to make your day easier. I also want to acknowledge Adam Machanic’s vision behind this project. I learned a lot from some of the #TSQL Tuesday’s and participated in a few.

13th Feb 2020

Default Job History Limits

Recently I needed to diagnose why a weekly, multi-step SQL Agent Job was taking so long. I thought, no worries, I’ll go and look at the history to see which step it was. Except…there was no history.

13th Feb 2020

FileMaker Shopify Integration

Shopify is used by more than a million businesses in over 175 countries, including Nestle and Staples, making it one of the leading e-commerce companies in the world.

13th Feb 2020

Is it really that hard to be polite, kind and respectful of those around you?

I dislike the term Politically Correct. Not because the original idea of it is a bad one, but it’s been misused and is now sometimes used as something derogatory. So instead of wondering if I’m being politically correct I like to do this.

13th Feb 2020

Azure Data Studio extension – help wanted

I’ve created a sample ads extension that checks TSQL syntax in real-time for potential bad practice. Right now the extension is using regex, which isn’t the best for parsing SQL but it works for the few test cases I’ve added.

13th Feb 2020

The February 2020 release of Azure Data Studio is now available

We are excited to share that the February release of Azure Data Studio is now available. Download Azure Data Studio and review the Release Notes to get started.

13th Feb 2020

What is a foreign key in SQL Server

In this article, we will seek an answer to an important question – “What is a foreign key in SQL Server?”. At the same time, we will give some seconder answers to this question. In this way, we can understand the foreign key concept more clearly.

13th Feb 2020

Introduction to MySQL 8.0 Recursive Common Table Expression (Part 2)

This is the second part of a two-articles series. In the first part, we introduced the Common Table Expression (CTE), a new feature available on MySQL 8.0 as well as Percona Server for MySQL 8.0. In this article, we’ll present the Recursive Common Table Expression.

13th Feb 2020

Compression of PostgreSQL WAL Archives Becoming More Important

As hardware and software evolve, the bottlenecks in a database system also shift. Many old problems might disappear and new types of problems pop-up. There were days when CPU and Memory was a limitation.

13th Feb 2020

Steps to Take if You Have a MySQL Outage

A MySQL outage simply means your MySQL service is not accessible or unresponsive from the other's perspective. Outages can be originated by a bunch of possible causes.. In this blog post, we’ll look at some steps to take if you’re having a MySQL outage (Linux environment).

12th Feb 2020

SQL Server Backup and Restore Strategy Step by Step

Introduction: Who is not aware of a SQL Database? It was the first business language introduced for E.F Codd’s Relational Database management system. In addition, MySQL, Oracle, Informix, Sybase, MS Access-all use SQL as the standard database query language.

12th Feb 2020

How to use SQL Server Configuration Manager

SQL Server configuration manager is a tool provided by Microsoft SQL Server. When we install SQL Server, it is installed automatically. It is used for the following purposes. The SQL Server configuration manager is a Microsoft console management snap-in and is in the start menu.

12th Feb 2020

Dealing with rejection

This serves as notice that your session submission was not selected for our upcoming event. We had a lot of sessions to sort through, and unfortunately there were not enough spots available to take everyone.

12th Feb 2020

Flexible MariaDB Server Query Cache

The Server Query Cache (QC) is a well-known feature of MariaDB Server–it caches SQL statements and the corresponding result sets. If a subsequent query then matches a cached SQL statement, the query can reuse the result set.

12th Feb 2020

Index Advisor Service for Couchbase N1QL(Feb refresh)

This is our Feb drop for Index Advisor service after fixing some of the bugs that were found. We plan to keep improvising the Index Advisor service(What is it?). The fixes in Index Advisor that you would normally see in the next maintenance release will now be available to you every month.

12th Feb 2020

Top 3 Database Life Hacks

Woohoo, it is an illuminating time of the month this second Tuesday of February 2020 and that also means it is time for another group blog party called TSQLTuesday.

12th Feb 2020

How to Use CockroachDB with Your Django Application on Ubuntu

Django is a high-level flexible framework for building Python applications quickly.

12th Feb 2020

What to Look for if Your MySQL Replication is Lagging

A master/slave replication cluster setup is a common use case in most organizations. Using MySQL Replication enables your data to be replicated across different environments and guarantees that the information gets copied.

12th Feb 2020

Creating Backups on SQL Server for Disaster Recovery

This tutorial explains three types of backups and demonstrates how to create full and differential backups using Microsoft SQL Server. Backups are one key to a successful disaster recovery plan.

First 156 157 158 159 Last