NameSQLinConfioIgnite (SolarWinds DPA)
This will name Ignite SQL hashes that have not been named yet, based on the object (or batch) they are within.
2014-02-05 (first published: 2014-01-25)
734 reads
Scripts
Convert Months,Days,ShortMonths to different Languages
Convert Months,Days,ShortMonths to Different Langauges with out sql server set language function can be used in views tables and stored procedures also includes proper case conversion
2014-02-03 (first published: 2014-01-21)
1,307 reads
Calculate Table Size and row count
This script calculates table row count and size(MB), as well as the used space and free space.
2014-01-31 (first published: 2014-01-17)
2,741 reads
2014-01-30 (first published: 2012-10-07)
2,216 reads
2014-01-28 (first published: 2013-01-16)
2,298 reads
2014-01-24 (first published: 2010-11-02)
27,350 reads
2014-01-21 (first published: 2013-12-28)
2,274 reads
2014-01-17 (first published: 2014-01-03)
1,797 reads
TEMPDB Configuration per vCPU
A simple script for automation of additional secondary data files of tempdb.
2014-01-14 (first published: 2013-12-27)
2,444 reads
To check the full backup duration of an SQL Instance
This script will check the full backup time taken by all the databases of an SQL Server instance.
2014-01-13 (first published: 2014-01-07)
1,385 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
SQL Server Audit Failures
Comments posted to this topic are about the item SQL Server Audit Failures
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers