Microsoft SQL Server Articles

Article

Table data compression, a multi-valuable database feature.

byTomas Helgi Johannsson

2022-12-02

Data compression is a feature offered by many modern databases like Db2, Oracle, MySQL, MariaDB and SQLServer. However, many companies do not use this feature in their database systems. Either they lack the knowledge of its existence in the application/systems design phase or due to budget issues.

Article

Some Useful Tips to Configure SQL Server Log Shipping

byPriyanka

2022-01-26

With the introduction of AlwaysOn Availability Group (AAG) in SQL Server 2012, log shipping seems to be less widely used than before. AlwaysOn Availability Group provides real-time log shipping as transactions are committed/applied to the primary database server.

Article

Union All Handling in SQL Server

byRyan Chong

2021-05-05

The UNION ALL (or UNION) operator is used to combine different result sets. This article focuses on handling the UNION ALL operator in a better way.

Article

Transform Text copied from Excel Table into Real Table in SQL

byRyan Chong

2021-04-24

After looking into a question at EE, a thought came to my mind that I considered would make a good article. "Transform Text copied from Excel Table into Real Table in SQL" as it is totally possible to do. Here's the result.

Article

How to Resolve DBCC CHECKDB Stuck in a Killed/Rollback State

byRaja Jegan R

2021-04-24

This article discusses various scenarios that can end up in a DBCC CHECKDB process getting stuck in a Killed/Rollback state and how to resolve the problem.

Article

Unpivotting by CROSS APPLY and VALUES

byPortletPaul

2021-03-30

Using a combination of CROSS APPLY and VALUES one can efficiently "unpivot" data into normalised results that are far better for analysis.

Article

Who filled transaction log of SQL Server database?

byMáté Farkas

2021-01-21

This article guides you in finding the user, process and host, which produced too many transactions filling the transaction log and preventing you from shrinking it.

Article

How to Fix SQL Server Login Failed Error 18456 State 38

byRaja Jegan R

2021-01-28

One of the most common issues faced while connecting to a SQL Server instance is "Login failed for …

Article

SQL Server Database Health Checks

byRaja Jegan R

2020-12-29

An introduction article to discuss about the various Database states for troubleshooting or health check purposes. More articles will be available in this series to see how to troubleshoot each and every states described in this article.

Article

Estimate Execution time of DBCC CHECKDB

byRaja Jegan R

2020-10-22

A clarification of some common doubts about DBCC CHECKDB for Database Administrators. Includes estimated times to repair database corruption's in production databases.

Article

Add Security Protections for Data Extraction

byRyan Chong

2020-09-12

The Get & Transform Data Wizard in Excel is a powerful tool. It allows the users to extract the data from the connected sources. But by delegating the privilege to users to access the connected sources, how could we ensure there is at least some degree of security is in place?

Article

AutoComplete feature with ASP.NET and SQL Server

byRyan Chong

2020-07-181

One of my friends recently asked me how to do an AutoComplete feature. I thought it was easy and there are already a lot of examples online. But I wish to provide him with a working solution instead of providing links. And in this article, I will explain the steps that I used to build that solution.

Article

How to run a SQL Server stored procedure asynchronously from Microsoft Access

byNatchiket

2022-04-05

When running slow stored procedures from Access it may be useful to have the application do something else rather than just show the hourglass. In this example a form flashes a message while the stored procedure executes, and then closes itself once the procedure has finsihed.

Article

Deny SA account for Developers in Microsoft SQL Server

byMáté Farkas

2020-05-13

This article shows how to force SQL and Web Developers to not use SA account while other services are already deployed to connect to SQL Server via SA account. So we will not touch existing services and applications only developers must be prevented.

Article

Storage savings with Microsoft SQL Server

byMáté Farkas

2020-04-28

This article shows how to use different types of data compression in SQL Server and they drawbacks.

Article

How to load JSON's data into SQL Server in different ways

byRyan Chong

2020-04-28

Data can be kept in different media, Sometimes, the data need to be extracted, transformed or loaded in different ways. For this article, I'm going to demonstrate some of the popular ways of importing JSON data into MS SQL Server.

Article

How to load Excel's data into SQL Server in different ways

byRyan Chong

2020-03-293

Article

Get Partition Info

bylcohan

2019-02-08

I recently had a few questions about how to quickly check the buckets on a particular partitioned table before performing a manual split or merge to make sure there will be no data movement and came up with the code below.

Article

Business intelligence development using BIML / BIML Script / BIDS Helper / Mist / BIML Studio

byAlpesh Patel

2019-02-25

Hey ETL Developer. Are you bored after developing the same nature of SSIS packages? Here are some snap /steps to overcome this work. In this article, I will walk you through step by step development and maintenance of SSIS packages using BIML (Business Intelligence Markup Language)

Article

Disaster Recovery in SQL Server and Repair Suspect Databases

byDevi Prasanthi

2018-10-021

SQL Server, like all other major RDBMS, supports ANSI SQL, the standard SQL language. SQL Server also contains T-SQL and its implementation. SSMS- the SQL Server Management Studio known as Enterprise Manager earlier is SQL Server’s main interface tool supporting 32-bit and 64-bit environments.

Explore SQL Server on Experts Exchange