Tags » T-SQL

How to identify the location of the SQL Server Error Log file

So you want to find out where the SQL Server Error Log file is located for a specific SQL Server instance?

The Error Log is a great place to start tracking down reasons why SQL Server might be experiencing problems. 169 more words

SQL Server

SQL Injection

SQL Injection (SQLi) refers to an injection attack wherein an attacker can execute malicious SQLstatements (also commonly referred to as a malicious payload) that control a web application’s database server. 220 more words

Database Administration

Restoring objects in SQL Server

This is a code googled in panic after occasional deletion of a stored procedure.

Does real magic saving hours of work that could be spent on re-writing: 143 more words

Installing SQLCMD

For anyone who wasn’t aware SQLCMD is a command line tool for running T-SQL statements and scripts. Before anyone says anything I want to point out that yes, I realize that you can use Powershell instead. 222 more words

SQLServerPedia Syndication

SQL: ISNULL - What is it? How do I use it?

Imagine this scenario…

You want to show the anniversary date of when an employee was hired, but you’ve also got a field for a rehire date. 57 more words


Installing SQL Server 2016 Language Reference Help from disk

A couple of years ago I blogged about Installing the SQL Server 2014 Language Reference Help from disk.

With SQL Server 2016 things changed significantly: we have the new Help Viewer 2.2, which is shipped with the Management Studio setup kit. 703 more words

SQL Server

Using Snippets

A while ago I talked about Templates. This is an easy way to get a, well, template of a piece of code. But a much faster way to get a simple template is to use a… 200 more words

SQLServerPedia Syndication