Query Active Directory to Display Login Information
Query Active Directory to get information on user logins.
2013-01-18 (first published: 2011-05-16)
3,829 reads
Rudy Panigas
Top 10 Wait State Issues Reporter
This script will produce the top 10 wait state issues along with their descriptions.
2012-11-22 (first published: 2012-10-22)
1,754 reads
Calculate the values for MAX Memory for SQL Server
Use this script to calculate MAX memory setting on a dedicated SQL server.
2012-01-27 (first published: 2011-12-14)
3,449 reads
Installing SQL Server 2008R2 on a Windows 2008R2 Core Server
This article will show you how to install SQL Server on to a Windows Core Server host.
2011-11-15
4,325 reads
Using SQL Server to collect information from your Oracle server
Using linked connections you can collect system information on your Oracle server from SQL server.
2011-06-06
3,458 reads
Show SQL authentication login information
View login information for all accounts that use SQL authentication.
2011-05-12 (first published: 2011-05-09)
2,928 reads
Collect SQL Server/Process Information - Quickly
Execute this script to get information on SQL server, databases, processes, memory, buffer, locks, etc.
2011-04-21 (first published: 2009-09-03)
5,622 reads
How to Connect to a SQL 2005 Server When You Are Completely Locked Out
If you need to connect to a SQL server and don't have the 'sa' password plus the builtin\administrators account has been removed then Rudy Panigas shows us what you need to know.
2011-03-11 (first published: 2009-11-03)
30,470 reads
Rebuild SQL Server Master Databases in Less than 5 Minutes
How to rebuild your master database quickly and safely.
2011-02-03
12,336 reads
2011-01-21 (first published: 2011-01-11)
2,883 reads
Blogs
SQL Server Time Bombs
By Kevin3NF
Common Reasons for Emergency SQL calls If you are a production DBA (or Accidental...
Book Review: A Radical Enterprise
By Steve Jones
I grabbed this book over the 2024 holiday season as it was on sale...
Advice I Like: Investing and Growing Rich
By Steve Jones
Investing small amounts of money over a long time works miracles, but no one...
Forums
Dateadd with a numeric value
Comments posted to this topic are about the item Dateadd with a numeric value
A Poor Data Model
Comments posted to this topic are about the item A Poor Data Model
Determining Whether Home Addresses Fall Within a Tornado Polygon Using Spatial Functions
Comments posted to this topic are about the item Determining Whether Home Addresses Fall...
Question of the Day
Dateadd with a numeric value
What is returned from the following query ?
declare @currentDateTime DATETIME = '2025-01-01 00:00:00.000' select dateadd(hour, 3.0/2, @currentDateTime);See possible answers