Tags » SQL Server 2008 R2

Resetting SQL Server Account Passwords

Recently ran into an issue where I needed to reset the SQL sa account password. The problem is, no one had administrative access to the SQL instance. 136 more words


Sql Server : Verify if backup is valid

Quick one today:

In production environments, its a common practice to perform full VERIFICATION of backup files, as part of backup it self. Following script shows verification of backup file: 48 more words


How to terminate sqlcmd immediately after execution completed? - Stack Overflow

The subtle difference between -q and -Q: the latter will exit after executing the command (regardless of the SQL server version; I think this was introduced in SQL Server 2005 or 2000). 196 more words


Sql Server : How to enable or disable Sql Agent Jobs using T-SQL

Quick one today:

Occasionally, during deployments, we need disable some Sql Agent jobs as we are making pertinent changes. If it is just one or two, may be doing it manually is okay ( 118 more words


T-SQL useful functions

Its been quite a while we have been working on SQL Server and and we know with every new release Microsoft comes up with improvised system function. 529 more words

T-SQL Code Snippets

How to Encrypt and Decrypt Text in SQL Server (2008+)

Here’s a simple example on how to encrypt (and decrypt) values in SQL Server:

--How to Encrypt and Decrypt Text in SQL Server (2008+)
--Example by Clint Huijbers…
100 more words

SQL Server 2012

SQL Server 2008 R2 (x86x64) - Hệ quản trị cơ sở dữ liệu

SQL Server 2008 R2 là phiên bản mới nhất của SQL Server tích hợp các tính năng doanh nghiệp thông minh cùng các nền tảng từ trung tâm dữ liệu đến điện toán đám mây và khả năng mở rộng hệ thống cấp doanh nghiệp. 368 more words