Get Database information in mail using PowerShell !
Would you love to get a weekly status report of all the databases hosted on your mission critical servers? ,Would...
2013-02-26
1,922 reads
SQLSailor.com
Check the version of Windows Installer !
This post is a quick tip to find the version of Windows Installer installed on your box.
You might wonder why...
2013-02-09
1,202 reads
Quick alert on servers which are not compliant for policies set using PBM
Last month I wrote about leveraging policy based management for regular DBA compliance checks. You can read that post here.
Policy based management(PBM) is indeed...
2013-02-06
797 reads
Leverage Policy Based Management for regular Page Verify =Checksum compliance monitoring
Page Verify = Checksum is one option which I like all my servers to be compliant. By default all the new...
2013-01-17
1,040 reads
DBCC Memorystatus SQL2012 – A quick observation for node Process/System Counts
This post is not a detailed explanation of DBCC Memorystatus for SQL2012,but a quick observation I made recently for the...
2013-01-11
3,289 reads
SQLAgent Job related reports and out of box real time job monitoring tool !
Lets start New Year with a very simple yet useful topic.
I am a big fan of out of box reporting...
2013-01-08
1,252 reads
2012 in review !
Year 2012 was super special for me in many ways. Made lot of new friends, Attended SQLPASS Summit 2012 and had...
2012-12-31
1,329 reads
Next Gen File System ReFS(Resilient File System) and SQLServer !
“ReFS”, this term was absolutely new to me when I was reading this white paper from Microsoft ‘Storage Windows Server...
2012-12-13
1,093 reads
Plan cache bloat by SQLAgent (Prior to SQL2008) !
Recently I was checking the plan cache utilization with the help of the below query which I normally use for...
2012-12-05 (first published: 2012-11-29)
2,456 reads
PASS Summit 2012 News – Check- in Experience!
Registration and Check in for PASS Summit 2012 was opened yesterday (Nov 4th), and I decided to utilize this opportunity...
2012-11-05
788 reads
Blogs
A Small LLM Fail
By Steve Jones
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...
Unused Indexes in SQL Server: Find them, vet them, and drop them safely
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
T-SQL Tuesday #191 Round Up
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
SQL Newbie HELP: The query references an object that is not supported in distr..
Hi everyone! I'm new to SQL and am trying to query a view (dbo.)...
Are topic notifications working?
This is a topic to test whether reply notifications are working or not.
Question of the Day
Slip Streaming Installs
What does a slipstream installation mean?
See possible answers