SQL Prompt Tips #6 - Insert Semicolons
A quick SQL Prompt tip to automatically add semicolons to your code.
2015-11-18 (first published: 2015-01-20)
5,350 reads
Redgate Software
Automating Red Gate SQL Compare with MSSQL Server Agent
How to compare two databases and email the results to every one who needs to know
2014-10-29
1,561 reads
GenesisOne T-SQL Unscrambler
This industry-first T-SQL source code unscrambler automatically reads the details hidden in T-SQL stored procedures without altering the source code. With this granular information, it generates organized and precise data flow diagrams along with plain-language descriptions of each programming step within any database object. Resulting documentation can be generated in PDF, Word or HTML.
2014-02-05
4,014 reads
New SQL Monitor Metric: Principals with Sysadmin Login
This metric counts the number of principals who are members of the sysadmin fixed server role. SQL Server relies on role-based security to manage permissions. If multiple IT system administrators have permissions to set up new SQL Server logins, they might be inclined to do so as part of the sysadmin role. Adding a normal user to the sysadmin role could pose a security risk and is not recommended unless the principal is highly trusted.
2013-11-11
3,175 reads
SQL Monitor Performance Metric: SQL Server: Plan Cache: Cache Pages Total
This metric collects the total amount of memory, in kilobytes, used by the plan cache of an instance to help identify memory pressure or plan cache pollution. It is similar to the SQL Server: memory manager: SQL cache memory counter, but instead of providing the number of 8-kilobyte pages that make up the plan cache, it provides the total memory used.
2013-10-01
3,002 reads
SQLServerCentral Webinar Series #26: Best Practices in Database Deployment Part 2
This Tuesday Grant Fritchey and David Simner will give you a step-by-step guide to how you can automate your database deployment Process using Red Gate Deployment Manager.
2013-09-02
1,775 reads
New SQL Monitor Custom Metric: Failed SQL Server logins
This metric returns the number of ‘login failed’ error messages found in the SQL Server error log file in the last hour.
2013-08-02
3,642 reads
SQLServerCentral Webinar #24: Prepare for When Disaster Strikes
Steve Jones presents some disaster stories with ideas on how you might prevent, or mitigate the effects, of those problem situations.
2013-07-29
177 reads
Free eBook: SQL Server Hardware
SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.
2016-08-16 (first published: 2013-07-24)
58,113 reads
SQL Monitor Custom Metric: Top Buffer Cache Object
This metric measures the amount of memory used in the buffer cache by the largest object (based on the number of pages). It checks the sys.dm_os_buffer_descriptors to identify the object, and returns the relative percentage used. You should use this metric if you want to monitor what is in the buffer area, or if you are having performance-related disk read problems.
2013-07-22
3,313 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers