Windows Group Membership Checker
A script to reveal which logins have access to your sql server via windows groups.
2010-12-09 (first published: 2010-08-26)
2,378 reads
Scripts
2010-12-08 (first published: 2010-12-03)
1,970 reads
2010-12-07 (first published: 2010-11-30)
2,178 reads
2010-12-06 (first published: 2010-11-22)
2,603 reads
2010-12-03 (first published: 2010-11-22)
1,676 reads
Average Page Life Expectancy
A useful script that I wrote that will sample the DMV sys.dm_os_performance_counters table to provide an average PLE captured in (1) minute intervals.
2010-12-01 (first published: 2010-11-16)
1,647 reads
SQL Function to Split Comma Separated Values and Insert into Table
SQL Function to Split Comma Separated Values and Insert into Table
2010-11-30 (first published: 2010-11-07)
4,204 reads
2010-11-26 (first published: 2010-11-04)
577 reads
2010-11-18 (first published: 2009-07-20)
2,932 reads
Get SQLServer Name and Uptime SPROC
Stored procedure to provide clean output of system name and uptime since last restart
2010-11-16 (first published: 2010-11-08)
1,244 reads
Blogs
Finding fields used in a Power BI report in PBIR format with Semantic Link Labs
Have you ever wondered where a certain field is used in a report? Or...
Adding Test data to msdb.sysjobhistory
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
Microsoft Ignite Announcements Nov 2024
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
Forums
Import data from json file with special characters
I am using the following script to import data from a json file. This...
% processor Time in Activity monitor is greyed out
When I connect to my SQL Server using SQL Server Management Studio (SSMS) from...
Tools for MySQL memory estimations and optimization?
Hi all! I’ve been using MySQLCalculator.com for memory calculations, but I’m looking for alternatives...
Question of the Day
The Hash Join II
Which of these inputs is the smaller input to a hash join?
See possible answers