SQL Server

How to filter non-existing records in SQL

  • Article

Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]

4 (6)

2019-11-04

4,712 reads

“Included columns” for non-clustered indexes explained

  • Article

Microsoft SQL Server has the feature to use “Included columns” for the creation of non-clustered indexes. This feature and its benefits and disadvantages will be explained in the following article. Included columns can be used to create a covering indexes without including all the data into the key columns. This covering index has the advantage […]

4.17 (6)

2019-09-17

5,189 reads

Managing SQL Server containers using Docker SDK for Python - Part 2

  • Article

There are multiple ways to interact with the Docker daemon, as command line client API or GUI based tools like Kitematic. Docker also provides a SDK for Go and Python,  this SDK can be used to create and manage Docker containers the same way it works with the Docker engine API.

2019-09-16 (first published: )

1,395 reads

Some T-SQL INSERTs DO Follow the Fill Factor! (SQL Oolie)

  • Article

With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to one's duties but tests one's knowledge of a system or process to the limit. Introduction Contrary to what many […]

5 (9)

2019-08-08

4,625 reads

A Step by Step Guide to the Availability Group (AG) Listener

  • Article

Availability databases hosted on SQL Server Always On Availability Groups (AG) can be connected using a unique Virtual Network Name (VNN), called the Availability Group Listener. When an Availability Group is enabled, clients can connect to databases in both primary and secondary replicas without explicitly specifying the SQL Server instance name. You don’t even need […]

5 (3)

2019-07-02

6,930 reads

Blogs

Azure Data Studeo- Nov 2019 Release

By

SQL Server Management studio is now can be installed separately not part of SQL...

Azure Synapse Analytics new features

By

Almost lost in all the announcements from Ignite was a bunch of amazing new...

Docker, Git and DBATools

By

For those who don’t know, last week was the PASS Summit. It’s an amazing...

Read the latest Blogs

Forums

https://dragonsdenketo.com/evoelite-keto/

By matationsjarrens

EvoElite Keto Another thing the best diet for Weight Loss needs is to make...

SQL'De Yedek alirken %90 da hata veriyor ve mdf dosyasi erisilemez diyor

By erdogan

Hi Friends, I'm using SQL 2014, Everything works fine I gave the following error...

Basic Avaialbility setup but replicas went to resolving mode

By pols

Hi, I configured the Basic Alwayson setup in two of the test SQL standard...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers