March | 2015 | SQL Studies

Monthly Archives: March 2015

Using Solutions in SSMS
3
March 11, 2015 by Kenneth Fisher

There are a handful of scripts I use on a regular basis. Adam Mechanic’s (b/t) sp_WhoIsActive, My sp_DBPermissions and sp_SrvPermissions, …
Continue reading

Category: Documentation, Microsoft SQL Server, SQLServerPedia Syndication, SSMS | Tags: microsoft sql server, SSMS
Who’s using that database?
Leave a comment
March 9, 2015 by Kenneth Fisher

A common problem when trying to alter a database (take it offline, add a filegroup, whatever) is that someone else …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL | Tags: code language, DMV, language sql, locks, microsoft sql server, sql statements, system functions, T-SQL
I want to blog but …
Leave a comment
March 4, 2015 by Kenneth Fisher

I don’t know how to get started. Pretty simple. There are a number of free blogging sites out there. Personally …
Continue reading

Category: Blogging, Microsoft SQL Server, SQL Judo's Monthly DBA Challenge, SQLServerPedia Syndication, T-SQL Tuesday | Tags: blogging, language sql, microsoft sql server, SQL Judo's Monthly DBA Challenge, T-SQL Tuesday
SQL Judo’s Monthly Challenge – March 2014 – Powershell something
Leave a comment
March 2, 2015 by Kenneth Fisher

Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be …
Continue reading

Category: Microsoft SQL Server, Powershell, SQL Judo's Monthly DBA Challenge, SQLServerPedia Syndication | Tags: code language, Powershell, SQL Judo's Monthly DBA Challenge, Steve Jones

ToadWorld Pro of the Month November 2013

Follow

Follow “SQL Studies”

Build a website with WordPress.com