SQLServerCentral Article

PostgreSQL 101: A guide to PostgreSQL documentation & useful resources

In the latest webinar of our PostgreSQL 101 series, join Ryan Booz, PostgreSQL Advocate at Redgate, and Grant Fritchey, Microsoft Data Platform MVP, and discover:

How to navigate PostgreSQL documentation
The essential things you need to know about PostgreSQL documentation
Other useful learning resources to help make your journey to using PostgreSQL easier

Please register to watch the recording.

SQLServerCentral Editorial

Community at PASS Summit

Last Saturday, September 23, was the first day of Fall. Regardless of how much has happened and changed over the last three and a half years, time keeps marching forward. And yet, there's exciting familiarity every time I see November approaching because I know something special is about to happen for those of us in […]

External Article

Profiler and Server Side Traces

Profiler is a GUI based tool that runs a SQL Server trace to capture the metrics listed above as well additional data. This data can then be used to determine where your SQL Server performance issues are related to your TSQL code. Running a trace without using Profiler is known as a Server Side Trace. You can create and start the trace using TSQL commands instead of having to use the GUI.

Blogs

SQL Prompt Quick Access to Helper Code

By

We’ve been doing some events as part of the Redgate Roadshow, and at one...

How to Fix Some Common MySQL Database Import Errors: A Comprehensive Guide

By

While working with WordPress and MySQL databases, users might occasionally encounter import errors during...

Common Mistakes in SQL Server – Part 3

By

Last week we discussed advantages of recompilation in Common Mistakes in SQL Server – Part...

Read the latest Blogs

Forums

Convert common Separated number to # table

By ralahari

@reportParameter 1008,1009,1011,1014 values need to insert to #Table Note: @reportParameter is not returning values...

Things to be considered before implementing database auditing

By vsamantha35

Hi All, As part of security compliance, we are told to audit DML &...

The Need for DevSecOps

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Need for DevSecOps

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers