Using logon trigger, users from valid IP addresses can be restricted, but what if you forgot to add in safe list. You will be unable to login though you have sysadmin rights. Use DAC to disable logon trigger.

SQL-Server

SQL-Server-2008

SQL-Server-2005

SQL Server: Smarter Way of Query Load Testing at Testing Server

17 Sep 2012 by aasim abdullah

Smarter Way of Query Load Testing at Testing Server

SQL-Server

SQL-Server-2008

SQL-Server-2005

SQL Server: Placing Alert for Compatibility Level Change in SQL 2005

22 Oct 2012 by aasim abdullah

In SQL Server 2005, there is no way to find out WHO AND WHEN someone changed the compatibility level of a database. Here is a trick for this functionality.

SQL-Server

SQL-Server-2005

SQL Server: Three Common DDL Change Log Methods

30 Dec 2012 by aasim abdullah

Three common DDL change log methods for SQL Server.

SQL-Server

SQL Server: A Query Slow in SSMS, Fast in Application, WHY?

9 Jan 2013 by aasim abdullah

SQL Server: A Query Slow in SSMS, Fast in Application, WHY?

Uploading the Files – HTML5 and jQuery Way!

28 Nov 2014 by Afzaal Ahmad Zeeshan

Uploading the files - HTML5 and jQuery way

How to Connect ASP.NET Website to Remote Database for CRUD Operations

10 Jan 2015 by Afzaal Ahmad Zeeshan

An overview for connecting an ASP.NET website or a web application to a remote SQL Server database

Considerations for SQL Server on Linux

18 Dec 2016 by Afzaal Ahmad Zeeshan

Overview of SQL Server on Linux

Linux

SQL-Server

XML Databases

21 Apr 2012 by AlexTatiyants

JSON-oriented document stores like Mongo and Couch have really become the darlings of the web application crowd. Of course, JSON (or BSON) isn't the only game in town. When it comes to document store formats, the other white meat if you will is XML.

Adding Items in Comma-separated String into Separate Rows in SQL Server

2 May 2013 by Amogh Natu

This post shows how to insert a comma-separated string into multiple rows in a table in SQL Server.

New Features for Database Developers in SQL Server 2012: Simpler Paging, Sequences and FileTables

20 Aug 2012 by Andrei Ion Rînea

Simpler paging, sequences and FileTables in SQL Server 2012

SQL

SQL-Server

Random Performance Findings

20 Aug 2012 by Andrei Ion Rînea

Some performance tips

Using Nightly Populated Tables for Faster SQL Queries

6 Jun 2011 by Andrew Zwicker

A discussion about nightly populated tables and how they have reduced SQL Server load

SQL-Server

Dev

DBA

Using a Staging Environment for Tracking Down Bugs

8 Jun 2011 by Andrew Zwicker

A discussion why having a staging environment with data that mirrors production is vital to tracking down issues.

SQL-Server

Dev

DBA

Database Table Documentation with a Data Dictionary

10 Jun 2011 by Andrew Zwicker

Why table and column documentation is useful and some SQL for setting up the data dictionary tables

Database Documentation with a Data Dictionary - Part 2

13 Jun 2011 by Andrew Zwicker

A continuation of the data dictionary discussion with information about how the documentation is done

Table Backups and the TableArchive Database

24 Jun 2011 by Andrew Zwicker

A discussion of how a separate database is used for storing table backups.

SQL-Server

Dev

DBA

Test Cases Statistics with SSRS and TFS Data Warehouse

26 Apr 2015 by Anton Angelov

Tutorial how to create test cases statistics for the automation status and their distribution by priority. Steps how to setup SSRS and TFS Data Warehose.

C#. Static Cache and Multithreading

22 Sep 2017 by Anton Burtsev

A few months ago, I had to optimize web portal (classified ad). The portal was built on ASP.NET 1.1. It seemed that portal had two main problems. Here is how I solved them.

SQL-Server

ASP.NET

SQL Server – What Exactly are UNION and UNION All?

26 Jan 2014 by Arun Ramachandran India

What exactly are UNION and UNION ALL in SQL Server

SQL-Server

How to unit test SQL Server 2008 database using Visual Studio 2010

22 Aug 2010 by atverma

In this article I’ll discuss about unit testing SQL Server 2008 Database project using Visual Studio 2010.

How to unit test SQL Server 2008 database using Visual Studio 2010 – Part 3

23 Aug 2010 by atverma

This is the last article of the series “How to unit test SQL Server 2008 database using Visual Studio 2010”.

How to Unit Test SQL Server 2008 Database Using Visual Studio 2010 – Part 2

23 Aug 2010 by atverma

In this article I will explore the important features that can be configured to build comprehensive database unit tests.

Merge Statement in SQL Server 2008

21 May 2013 by Basavaraj P Biradar

The new Merge statement in SQL Server 2008.

Comparing the Performance of AppFabric Against SQL Server

19 May 2011 by Ben Liebert

Comparing the performance of AppFabric against SQL Server

SQL-Server

How We Improved Database Code Quality

4 Sep 2013 by Betclic Tech

How we improved database code quality

SQL-Server

Processing SQL Server FILESTREAM Data - Part 1

21 Sep 2014 by Bob McGowan

Processing SQL Server FILESTREAM Data - Part 1

Processing SQL Server FILESTREAM Data: Part 2 - The Setup

22 Sep 2014 by Bob McGowan

Utilizing SQL Server FILESTREAM capabilities from .NET

Processing SQL Server FILESTREAM Data: Part 3 - Creating Tables

24 Sep 2014 by Bob McGowan

Utilizing SQL Server FILESTREAM capabilities from .NET

Processing SQL Server FILESTREAM Data, Part 4 - Readin' and Writin'

14 Oct 2014 by Bob McGowan

In this final installment, we'll finally see some C# code that I used to read and write the FILESTREAM data.

SQL-Server

Resource: Brad's Sure Guide to SQL Server Maintenance Plans

17 Aug 2012 by Bryan O'Connell

Review of the ebook: Brad's Sure Guide to SQL Server Maintenance Plans.

Three-tier .NET Application Utilizing Three ORM Technologies

23 Dec 2009 by Bryan Thomas Weikel

CodeProject"LEK" is a three-tier .NET WinForms accounting application that can be configured at run time to use either LINQ to SQL, Entity Framework or NHibernate to access data in either a "main" or "testing" SQL Server database.

How to Use ROW_NUMBER() to Enumerate and Partition Records in SQL Server

31 Dec 2011 by Dave C Andrews

Use ROW_NUMBER() to enumerate and partition records in SQL Server

“Keyset does not exist” error while installing SharePoint 2010

15 May 2011 by David Truxall

How to fic this error, in Windows Phone 7.

SQL-Server

Dev

Configuring CRM 4.0 for SSRS Without the Data Connector

15 May 2011 by David Truxall

Configuring CRM 4.0 for SSRS Without the Data Connector

SQL-Server

Map Data from Database Context to Excel Sheet using LINQ & Microsoft.Office.Interop.Excel

16 Nov 2013 by Debopam Pal

Using Microsoft.Office.Interop.Excel library, you can bring your data from your database against LINQ query and store them into an Excel Sheet.

What are the Different Types of Database Backups?

14 Sep 2014 by derekman9707

Different types of database backups

Some Hidden Facts: Stored Procedure and Its Optimization

9 Jul 2011 by Dinesh K Mandal

Some Hidden Facts about Stored Procedure and Its Optimization

Deploying Full Stack ASP.NET Core with API and SQL Server Databases to Docker Containers

1 Dec 2022 by DotNetLead.com

Deploy existing ASP.NET Core UI, API, and SQL Server to Docker containers

Image in C#: Save, Resize, and Convert to Binary

28 Apr 2010 by Duy H. Thai

Some frequently-used methods for image handling in .NET

Get Ready to Learn SQL Server: 14. Introduction to Outer Joins

22 Oct 2014 by essentialSQL

Introduction to Outer Joins in SQL Server

SQL

dbase

SQL-Server

Get Ready to Learn SQL Server: 13. Introduction to Inner Joins

22 Oct 2014 by essentialSQL

Introduction to Inner Joins in SQL Server

SQL

SQL-Server

DBA

Get Ready to Learn SQL: 7. Simplified Data Modeling

23 Oct 2014 by essentialSQL

Simplified Data Modeling in SQL

Get Ready to Learn SQL Server: 6 – Group and Summarize Your Results

29 Oct 2014 by essentialSQL

Grouping results returned from your queries using the GROUP BY clause

Get Ready to Learn SQL Server 20: Using Subqueries in the Select Statement

6 Feb 2015 by essentialSQL

This is the second in a series of articles about subqueries. In this article, we discuss subqueries in the SELECT statement’s column list. Other articles discuss their uses in other clauses.

SQL

SQL-Server

Introduction to SQL Server’s Common String Functions

2 Jan 2016 by essentialSQL

Introduction to SQL Server’s Common String Functions

SQL

SQL-Server

Introduction to SQL Server’s Built-In Conversion Functions

2 Jan 2016 by essentialSQL

Introduction to SQL Server's built-in conversion functions

SQL

SQL-Server

Introduction to SQL Server’s Built-In Logical Functions

4 Jan 2016 by essentialSQL

Introduction to SQL Server's built-in logical functions

SQL-Server

Commonly used SQL Server Data Types

5 Jan 2016 by essentialSQL

Commonly used SQL Server data types

SQL-Server

Built-In Functions (SQL Server)

11 Jan 2016 by essentialSQL

Basic concepts of built-In functions in SQL Server

SQL-Server

Non Recursive CTEs Explained

14 Jul 2016 by essentialSQL

In this article, we explore non recursive CTEs (Common Table Expressions). This is a broad class, and basically covers every form of CTEs except those that call themselves. This other class is called the recursive CTEs; they are covered in the next article.

SQL

SQL-Server

CTE

Introduction to SQL Server Data Modification Statements

4 Nov 2016 by essentialSQL

Introduction to SQL Server Data Modification statements

SQL-Server

Cross Join Introduction – Create Row Combinations

29 Dec 2016 by essentialSQL

Introduction to cross join - create row combinations

Uncommon SQL Server Data Types

29 Dec 2016 by essentialSQL

Uncommon SQL server data types

SQL-Server

Introduction to Stored Procedures for SQLServer

30 Dec 2017 by essentialSQL

Benefits of stored procedures and how to create and execute them

SQL-Server

SQL Server and Set Operations

30 Dec 2017 by essentialSQL

SQL set operations

SQL-Server

Learn How to Calculate the Median Value using PERCENTILE_DISC

30 Dec 2017 by essentialSQL

In this puzzle, we’re going to learn how to find the person whose birthday, among others, is in the middle.

SQL

SQL-Server

Learn to Use the Data Dictionary in SQL Server

30 Dec 2017 by essentialSQL

In this puzzle, we’re going to learn how to query the data dictionary using SQL Server.

SQL

SQL-Server

What is a Dynamic Pivot Table?

30 Dec 2017 by essentialSQL

In this puzzle, we’re going to learn how to create a dynamic pivot table using SQL Server.

SQL

SQL-Server

Use SQL Server to Create a Cross Tab Query

30 Dec 2017 by essentialSQL

In this puzzle, we’re going to learn how to create a cross tab query using SQL Server.

SQL

SQL-Server

Learn How to Work Joins and Messy Data

30 Dec 2017 by essentialSQL

How to join dirty data using SQL Server

SQL

SQL-Server

How Do I Use the Like Clause in SQL Server?

30 Dec 2017 by essentialSQL

In this video, we'll walk you through how to use the LIKE clause.

SQL

SQL-Server

Use Subquery with Bill of Materials

3 Mar 2019 by essentialSQL

In this puzzle, we’re going to learn how to work with the AdventureWorks Bill of Materials table. Companies use a BOM (Bill of Materials) to itemize the products that are used or contained in another product. Solving puzzles is a great way to learn SQL.

SQL

SQL-Server

SQL DISTINCT Clause For SQL Server

25 Apr 2019 by essentialSQL

SQL DISTINCT Clause For SQL Server

SQL

SQL-Server

combination

SQL COALESCE Function and NULL

26 Apr 2019 by essentialSQL

SQL COALESCE Function and NULL

SQL

SQL-Server

SQL Server Hierarchical Query using the hierarchyid Type

26 Apr 2019 by essentialSQL

SQL Server Hierarchical Query using the hierarchyid type

SQL

SQL-Server

Learn to Use SQL Server Date Functions

14 Aug 2019 by essentialSQL

How to use SQL Server Date functions

SQL

SQL-Server

What is a SQL Server Data Dictionary?

14 Aug 2019 by essentialSQL

What is a Data Dictionary in SQL Server?

SQL

SQL-Server

Query Plans in SQL

14 Aug 2019 by essentialSQL

Query plans in SQL

What is a Database Trigger?

14 Aug 2019 by essentialSQL

What is a Database Trigger?

Learn about Stored Procedures

14 Aug 2019 by essentialSQL

In this blog post, you will learn about stored procedures

SQL Truncate and Delete

14 Aug 2019 by essentialSQL

Truncate and Delete in SQL

SQL

Oracle

SQL-Server

What is the Difference between WHERE and HAVING Clauses?

14 Aug 2019 by essentialSQL

Difference between WHERE and HAVING clauses

SQL

SQL-Server

How Do I Combine Results from Several SQL Tables (Hint: There Are Three Ways)

14 Aug 2019 by essentialSQL

How to combine results from more than one table

SQL

SQL-Server

What are the Major Parts of a SQL DB?

14 Aug 2019 by essentialSQL

This post discusses the major parts of a SQL database

SQL COALESCE Function and NULL

23 Feb 2020 by essentialSQL

SQL COALESCE function and how you can test for null, and when present, substitute it for another value

SQL

SQL-Server

Common Data Types used in SQL Server

13 Mar 2019 by essentialSQL

Examples of common data types in SQL Server and how to define them

SQL

SQL-Server

Use SQL to Calculate Median Values

29 Dec 2019 by essentialSQL

How to calculate the median value using SQL

SQL

SQL-Server

calendar

SQL Full Outer Join

29 Dec 2020 by essentialSQL

Understanding SQL full outer join and its reconstruction through other join clauses

SQL

Oracle

SQL-Server

Why Would You Use Common Table Expressions?

10 Apr 2018 by Gaston Verelst

Why you would use Common Table Expressions

Stored Procedures – Another look

28 Aug 2010 by Gediminas Geigalas

This article reviews how my opinion on Stored Procedures changed over time and what disadvantages they bring into your application.

SQL

SQL-Server

Design

Serializing System.DateTime for SQL Server

28 Aug 2010 by Gediminas Geigalas

Learn how to serialize System.DateTime for use in SQL Server stored procedures

Windows

SQL-Server

How to Shrink SQL Server Database Log File

2 Nov 2019 by Ghanshyam N Patel

How to shrink SQL Server database log file

SQL

SSMS

SQL-Server

Revisiting XML Configurations In Unity

6 Jan 2011 by Gil Fink

Revisiting XML Configurations In Unity In the past I wrote a few tutorials about Unity application block. One of the things I wrote about was how to configure a Unity container using design time configuration.

WPF: Merged dictionary parser depends on XML attribute order

13 Aug 2010 by Ivan Krivyakov

Attribute order should not matter in XAML, but sometimes it does...

Christmas Carol: XML Signatures

30 Dec 2015 by Ivan Krivyakov

Christmas Carol: XML Signatures

Log4j2.xml Tweaks

3 Mar 2016 by Jameson Triplett

Log4j2.xml Tweaks

Building a plug-in model to load VistaDB - Part II

22 Jun 2010 by JasonShort

Plugins are used in data applications to support more than one provider from a single codebase. The Provider Factories in ADO.NET is one such example, but you cannot work with the provider specific features when you use these factories since they only implement generic ADO.NET functions.

ADO.NET

All-Topics

SQL-Server

Random Value Per Row in SQL

8 Jan 2019 by Jeremy Hutchinson

Update table rows with varying random values in SQL

SQL

SQL-Server

Repository Generator

5 Feb 2016 by jgauffin