Skip to content

The Dummy Programmer

Stories of daily programming

  • Home
  • The Dummy Programmer Robot
    • Overview
    • Version history & downloads
    • Tutorials
      • TDP Robot – The basics
      • A simple SQL Server backup solution
      • A simple SQL Server backup solution – A next step
  • My other dummy projects
  • Donate
  • About

Category: Sql Server

Posted on July 20, 2022July 21, 2022

Sql Server error: A severe error occurred on the current command.  The results, if any, should be discarded.

In recent days I was working on one of my projects, in which it was necessary to install Sql Server 2019. I restored the databaseRead more…

  • Sql Server
  • Sql Server 2019
by 0 comment
Posted on March 7, 2022March 7, 2022

Sql Server error: Cannot construct data type date, some of the arguments have values which are not valid.

Imagine waking up on a cold winter morning, and receiving an error from your customer that reads as follows: “Cannot construct data type date, someRead more…

  • Sql Server
  • Sql Server 2016
by 0 comment
Posted on March 6, 2021March 6, 2021

Getting SQL Server sample databases

Good morning my friends! It’s been exactly a month since we last spoke! I’m very busy with a new project, which I hope to shareRead more…

  • Sql Server
  • Sql Server 2016
by 0 comment
Posted on February 6, 2021February 7, 2021

SQL Server and SARGables predicates

Today I will share with you some suggestions about using SARGable predicates. First of all let’s start explaining what is a SARGable predicate…SARGable stands forRead more…

  • Sql Server
by 0 comment
Posted on December 20, 2020December 22, 2020

Sql Server Instant File Initialization

Sql Server Instant File Initialization is a Sql Server option that, I have to admit, I didn’t know. Activating this option you can slightly improveRead more…

  • Sql Server
  • Sql Server 2016
by 0 comment
Posted on March 21, 2020May 3, 2020

Sql Server add constraint WITH NOCHECK

Good morning guys! Today I want to talk about a Sql Server feature that you could use when creating foreign key constraints: the WITH NOCHECKRead more…

  • Sql Server
  • Sql Server 2016
by 0 comment
Posted on March 10, 2020March 10, 2020

Get SQL Server version in T-SQL

Hi guys!! Today I want to share a simple but useful trick to show the version of your SQL Server. Just type the following command:Read more…

  • Sql Server
  • Sql Server 2016
by 0 comment
Posted on December 17, 2019

Get all referencing tables of a table in Sql Server

Today I want to talk about how to get all referencing tables of a Sql Server table. It is useful, for example, if you needRead more…

  • Sql Server
  • Sql Server 2016
by 0 comment
Posted on October 5, 2019

Sql Server: apply an aggregate function to fields values in a row

Did you ever need to apply an aggregate function to fields values in a row? It happened to me just few days ago… I willRead more…

  • Sql Server
  • Sql Server 2016
by 0 comment
Posted on September 15, 2019June 14, 2020

How to know who is blocking a query in Sql Server

It’s been a while since we last heard… The Dummy Programmer was really really busy and couldn’t write any post. But now I’m back toRead more…

  • Sql Server
  • Sql Server 2016
by 0 comment

Posts navigation

Older

Search

Subscribe to our newsletter

Categories

  • .NET 6 (1)
  • AJAX (1)
  • Android (2)
  • Apache (4)
  • ASP.NET (8)
  • ASP.NET MVC (3)
  • Avalonia UI (1)
  • BCP (1)
  • Bitlocker (2)
  • C# (14)
  • CentOS (4)
  • ClosedXML (1)
  • CLR (1)
  • DNS (1)
  • Encryption (3)
  • Excel (2)
  • FuelPHP (3)
  • Google Chrome (1)
  • GSuite (1)
  • Imagick (2)
  • Kindle (1)
  • LAMP (3)
  • Linux (6)
  • MariaDB (2)
  • Mathematics (2)
  • MySql (4)
  • NPOI (1)
  • Office 365 (1)
  • Perl (1)
  • PHP (6)
  • Programming (1)
  • Remote desktop (1)
  • SFTP (2)
  • Sockets (3)
  • Sql Server (18)
  • Sql Server 2016 (14)
  • Sql Server 2019 (1)
  • SSL (2)
  • Task scheduler (1)
  • Telerik ASP.NET AJAX (2)
  • The Dummy Programmer Chat (2)
  • The Dummy Programmer Robot (6)
  • Threading (5)
  • Tools (1)
  • TPL (3)
  • TypeScript (2)
  • Ubuntu (4)
  • Virtualization software (3)
  • Visual Studio (1)
  • Visual Studio Code (2)
  • Web fonts (1)
  • Web programming (6)
  • Windows (12)
  • Windows 10 (15)
  • Windows Forms (1)
  • Windows Server (5)

Copyright © 2022 The Dummy Programmer

All Rights Reserved | Mega Blog by Theme Palace