Skip to main content
snippets
S
nippets
SQL
Snippets
Date
•
Title
Show Active SQL Server Connections
SQL
9 years ago
dba
mssql
Get SQL Server Listening Ports
SQL
9 years ago
dba
mssql
port
tcp
Get SQL Server Time Zone
SQL
9 years ago
dba
mssql
timezone
View for SQL Agent Job Histories
SQL
9 years ago
dba
mssql
sqlserveragent
ssis
view
Reseed Table Identity Value
SQL
9 years ago
database
dba
delete
identity
mssql
reseed
rows
table
truncate
Get SQL Server CLR Details
SQL
10 years ago
dba
mssql
sqlclr
UDF to Check for SQL Injection
SQL
10 years ago
mssql
security
sqlinjection
udf
Get SQL Server Error Numbers and Messages
SQL
10 years ago
dba
error
mssql
Paging Through A Result Set
SQL
10 years ago
examples
mssql
pagination
Get Logged-in User Session Details
SQL
10 years ago
cursor
dba
mssql
session
Show SQL Server Error Log Entries
SQL
10 years ago
dba
error
log
mssql
Normalize and Rename Database Constraints
SQL
10 years ago
constraint
database
dba
mssql
normalize
rename
Get File Size and Log Usage for all Databases
SQL
10 years ago
dba
log
mssql
size
Get Database Table IO Ratios
SQL
10 years ago
dba
io
mssql
performance
ratio
statistics
Show Failed and Successful Login Attempts
SQL
10 years ago
audit
dba
login
mssql
Get SQL Server Version
SQL
10 years ago
dba
details
mssql
os
server
version
Check if SQL Command Mode is Enabled
SQL
10 years ago
dba
mssql
sqlcmd
Remove Non-Alpha Characters from String
SQL
10 years ago
alpha
character
loop
mssql
remove
string
Show Active Connections
SQL
10 years ago
connection
dba
mssql
Change SQL Database Recovery Model to Simple
SQL
10 years ago
database
dba
mssql
recovery
«
1
2
3
4
5
6
7
8
9
10
11
»
Last
More »