SQL Server

Article

Innovating in the database is crucial for success, and we’re seeing new trends impact the database, like cloud migration, SRE, and the growing need for big data and tools to support growing estates. On 23 June, Redgate Streamed brings you organizations who have implemented these database technology trends, including speakers from Google, Microsoft, and AWS, who will share their success stories and tips for embracing technology changes.

2021-06-07

DBA in training: SQL Server high availability options

by Additional Articles

SimpleTalk

Article

DBAs must make sure data is highly available, and there are many SQL Server high availability options. Pamela Mooney discusses those options in this article.

2021-06-07

CTE in SQL Server Examples

by Additional Articles

MSSQLTips.com

Article

In this article we cover what a Common Table Expression CTE is and how to write a CTE for doing selects, inserts, deletes, updates and more.

2021-06-02

Introducing the PASS Data Community SUMMIT

by Additional Articles

Redgate

Conferences, Classes, Events, and Webinars

Article

Join the world’s largest gathering of data professionals at this year’s free online PASS Data Community SUMMIT. Connect and network with 1000s of your peers and learn from some of the brightest minds in the data industry. This year’s must-attend online event is completely free, so sign up now to be notified when registration opens.

2021-05-28

SQL Server security – Providing a security model using user-defined roles

by Additional Articles

SimpleTalk

Article

Greg Larsen continues his series and shows how user-defined roles roles can control SQL Server security.

2021-05-24

SQL Server plan cache mining – Plan attributes

by Additional Articles

SimpleTalk

Performance

Article

Edward Pollack demonstrates how SQL Server plan cache mining can uncover a wealth of information to help with troubleshooting performance issues.

2021-05-21

A Step by Step Guide to the Availability Group (AG) Listener

by Rathish kumar B

SQLServerCentral

Article

Availability databases hosted on SQL Server Always On Availability Groups (AG) can be connected using a unique Virtual Network Name (VNN), called the Availability Group Listener. When an Availability Group is enabled, clients can connect to databases in both primary and secondary replicas without explicitly specifying the SQL Server instance name. You don’t even need […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2021-05-17

10,535 reads

Discuss

SQL Server T-SQL CASE Statement Examples

by Additional Articles

MSSQLTips.com

T-SQL

Article

This tip will teach you when and how you can use CASE in T-SQL statements with several code examples to give you a better understanding.

2021-05-14

Your Top 10 Ideas for SQL Server

by Additional Articles

Brent Ozar Blog

SQL Server

Article

You’ve submitted thousands of bug reports and feature requests at feedback.azure.com. Brent Ozar goes through what you’ve voted as the top 10 requests right now.

2021-05-14

SQL Server Sequence Numbers

by Additional Articles

MSSQLTips.com

IDENTITY

Article

In this tip we look at the Sequence Number feature in SQL Server and compare it to the use of identity columns.

2021-05-10

SQL Server

Redgate Streamed: Embracing technology trends for database success

DBA in training: SQL Server high availability options

CTE in SQL Server Examples

Introducing the PASS Data Community SUMMIT

SQL Server security – Providing a security model using user-defined roles

SQL Server plan cache mining – Plan attributes

A Step by Step Guide to the Availability Group (AG) Listener

SQL Server T-SQL CASE Statement Examples

Your Top 10 Ideas for SQL Server

SQL Server Sequence Numbers

Blogs

Getting the SQL Server MCP Server Running

Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations

Rambling about Data on Wheels – origins, branding, expansion

Forums

Make It Routine

DBCC CHECKDB Limits III

CROSS APPLY Fundamentals: Part 1

Question of the Day

DBCC CHECKDB Limits III