Querying SQL Server Agent Job Information
Is there an easy/automated way to get information on SQL Server Agent jobs instead of connecting to each server and manually getting the information through the SSMS GUI?
2012-01-02
3,521 reads
Articles
A Simple way of Automating Scripts
Deploying changes to your environments can be challenging, especially when you have multiple script files. Sadequl Hussain brings us a technique that works well and handles mutliple files.
2011-12-30 (first published: 2009-07-30)
51,411 reads
SQL Saturday #104 - Colorado Springs
Start your 2012 off right with a free day of training in Colorado Springs. Bring the kids as well, as the venue is very family friendly.
2011-12-30 (first published: 2011-12-06)
1,117 reads
Understanding the SQL Server SELECT @@VERSION command
Check out this tip to learn about the SELECT @@VERSION command in SQL Server.
2011-12-30
4,818 reads
An Introduction to Integration Services log providers
SSIS features log-providers that can write to five different types of logging destinations; three of them are files, one is the 'dbo.sysssislog' table, and the last is the Windows Event Log.
2011-12-29
4,346 reads
2011-12-29 (first published: 2010-06-09)
8,899 reads
Great SQL Server Debates: Lock Pages in Memory
There has been much debate over the need for the Lock Pages in Memory privilege, on 64-bit versions of SQL Server. Jonathan Kehayias presents a "warts and all" account of its history, the confusions surrounding its use, and why he believes it's still a good default configuration for 64-bit SQL Server instances, even when running Windows Server 2008 and Windows Server 2008R2.
2011-12-29
2,878 reads
Writing New Hash Functions for SQL Server
This blog, explores ideas for extending SQL Server with new, fast hash functions. As will be shown, the high speed, built in functions CHECKSUM and BINARY_CHECKSUM are not always optimal hash functions, when you require the function to spread data evenly over an integer space.
2011-12-28
2,595 reads
Mirroring and different sector sizes? BAD IDEA!
Be carefull when replacing a defective (FLASH) storage device, its sector sizes may vary without you knowing it.
2011-12-27
4,644 reads
2011-12-27 (first published: 2010-06-02)
11,234 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers