Microsoft SQL

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet).

www.microsoft.com/sql-server

SQL String Concatenation

Have you ever wanted to retrieve a list of values from a table, storing the results in a string? Here is simple yet effective method without having to rely on cursors, while loops, or other complex structures. declare @string varchar(8000) select...

Scheduled restart 🔄 of SQL server

As you may notice, Microsoft SQL Server will gradually consume more and more memory after it starts…Most people (myself included) will wonder if this means that there are memory leaks or unclosed connections.  While you should make sure to close all...

How to find and stop SQL injection 💉 attacks

There’s a lot of stuff out there about SQL injection attacks but there’s not much that will help you figure out how to stop these attacks from occurring. First, let’s talk about what a SQL Injection Attack really is. Some people think it’s a virus...

⚠️ SQL server: Terminate database connections

Each application taht uses your SQL Server database creates a connection on the database and this connection continues unless the session is killed or terminated privately within the application. A similar connection is established even for each...

Cover Image by MilesAndryPrower on DeviantArt

☑ Optimize a MySQL database

If you have deleted a large part of your table or updated many variable length rows, you should consider running the optimize command. If you want to quickly generate the optimize commands for every table in you database, executing the...

⚠️ SQL 2012 Reporting not starting

Error Message: Microsoft.Reporting.WinForms.ReportServerException: The Report Server Windows service ‘ReportServer$SCE’ is not running. The service must be running to use Report Server. (rsReportServerServiceUnavailable)at Microsoft.Reporting...