Sign in
|
Join
|
Help
Home
Blogs
WordPress Blogs
Media
All Tags
»
SQL Server 2008 R2
»
SQL Server 2008
»
sql server 2005
(
RSS
)
MVP WordPress Blogs
Loading...
Tags
.NET
Advisories / Bulletins
ASP.NET
C#
Community
ConfigMgr 2007
Digital Media
Events
Exchange
General
General Security News
Media Center
Microsoft
News
Rants
Security
Sharepoint
SPPS03_Tips
SQL Server
System Center
Tools
VB
Vista
Windows 7
Windows Server
Browse Blog Posts by Tags
Showing related tags and posts for the
Blogs
application. See
all tags in the site
Administration
Community
Conference
Logon Triggers
ms sql server 2005
script
Security
sql
sql 2000
sql 2005
sql 2008
sql 2008 r2
sql 2012
sql 2012 r2
sql server
sql server 2000
sql server 2008 ctp
sql server 2008 november ctp
sql server 2008 R2 CTP
SQL Server 2011
sql server 2012
SQLBits
How to collect cluster Information using TSQL
Sometime back I was involved in a project which was to collect information for the servers we are supporting – creating inventory of servers. Logging into each server and collecting information is bit tedious when you have hundreds of server in your environment...
Posted to
SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami
by on Mon, Apr 29 2013
Filed under:
Filed under:
script
,
sql server 2005
,
Sql server 2008
,
sql server 2000
,
sql server 2008 r2
,
sql server 2012
,
Administration
Collecting HOST Machine Information using TSQL
Sometime back I was involved in a project which was to collect information for the servers we are supporting – creating inventory of servers. Logging into each server and collecting information is bit tedious when you have hundreds of server in your environment...
Posted to
SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami
by on Mon, Apr 29 2013
Filed under:
Filed under:
script
,
sql server 2005
,
Sql server 2008
,
sql server 2000
,
sql server 2008 r2
,
sql server 2012
,
Administration
SQL Server # Database Backup Report using T-SQL
Today, I am going to share few very useful scripts which will report us on Database Backup from different view points. To get the List/History/Log of all the Successful Backups SELECT b.machine_name, b.server_name, b.database_name as DBName, b.backup_start_date...
Posted to
SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami
by on Wed, Oct 17 2012
Filed under:
Filed under:
sql
,
sql server
,
sql 2005
,
script
,
sql 2000
,
sql server 2005
,
Sql server 2008
,
sql server 2008 ctp
,
sql server 2000
,
sql 2008
,
sql server 2008 november ctp
,
sql 2008 r2
,
sql server 2008 R2 CTP
,
sql server 2008 r2
,
sql 2012
,
sql server 2012
,
sql 2012 r2
Last Execution Date Time of a Stored Procedure
On many forums I have found a very basic yet important query - “How can I know when was my Stored Procedure last executed?” And today through this blog I will try to answer this question. Actually speaking, without explicit logging or tracing, it is not...
Posted to
SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami
by on Sun, Mar 11 2012
Filed under:
Filed under:
sql 2005
,
script
,
sql server 2005
,
Sql server 2008
,
ms sql server 2005
,
sql 2008
,
sql 2008 r2
,
sql server 2008 r2
Restricting logons during certain hours for certain users
Following a an email in a DL I decided to look at implementing a logon restriction system to prevent users from logging on at certain ties of the day. The poster had a solution but wanted to add auditing. I immediately thought of the My post on logging...
Posted to
SimonS Blog on SQL Server Stuff
by on Fri, Dec 3 2010
Filed under:
Filed under:
SQL Server 2008
,
SQL Server 2008 R2
,
SQL Server 2005
,
Security
,
SQL Server 2011
,
Logon Triggers
SQL Bits session subsmission
Don't forget to submit sessions for SQLBits V in November. For anyone that hasn't spoken before as a speaker you will get exclusive access to the speaker dinner, we will cover one nights hotel and provide you with, the best of all, a SQLBits polo...
Posted to
SimonS Blog on SQL Server Stuff
by on Tue, Aug 18 2009
Filed under:
Filed under:
SQL Server 2008
,
SQL Server 2008 R2
,
SQLBits
,
Community
,
Conference
,
SQL Server 2005
Page 1 of 1 (6 items)