Question of the Week - 11/1/2014

Question:- Suppose there are two tables A and B and we need to write 3 SQL queries which returns the record...

Answer - Objective Question (In which database temporary tables are created in SQL Server)

Question :- In which database temporary tables are created in SQL Server?

1) User database (where temporary table are defined)
   
2) Master...

Who Owns SQL Backups?

I was asked by Idera to take a look at the things that could cost a DBA their job. This...

Applied SQL: Find and replace using regular expressions in SSMS

Regular expressions are searches on steroids, the wildcats of the wildcard world*.  Even if you  never ever write CLR, regex...

T-SQL – Monitoring DiskSpace of Multiple Servers

This post talks about step by step approach to capture the disk space using T-SQL. This is a request from...

The DBA That Practices Database Restores

We are often told that we need to practice our restores. And it might not be obvious, but the reason...

Reblog: January 3 to January 9

Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...

The SQLSaturday Wiki–Revisited

I saw a discussion on Twitter yesterday where Kendal Van Dyke referenced the SQLSaturday wiki as a resource, I thought...

Schedule Time To Review Your Passwords & Using a Password Manager

I use a password manager and it currently has more than 150 accounts in it, ranging from my checking account...

SSRS – Identify a scheduled SSRS Report

Initiating subscription is a tedious task in SQL Server Reporting Services. Each subscription in Reporting Services is setup as a...