Your first speakers in the lineup for PASS Data Community Summit 2023 have been announced! Check out the full details for this year's Pre-Cons and Learning Pathways, and find out why some of our speakers are particularly excited for what’s in store this year.
The post First speakers announced for Summit 2023 appeared first on SQLServerCentral.
How to Reduce the Need for Bookmarks Using Parameters in Power BI
Learn how to implement parameters in Power BI.
The post How to Reduce the Need for Bookmarks Using Parameters in Power BI appeared first on SQLServerCentral.
The post How to Reduce the Need for Bookmarks Using Parameters in Power BI appeared first on SQLServerCentral.
Paging Data in T-SQL
This article will show you how to page through a set of results using the OFFSET and FETCH options of the ORDER BY clause.
The post Paging Data in T-SQL appeared first on SQLServerCentral.
The post Paging Data in T-SQL appeared first on SQLServerCentral.
[Video] Office Hours: Professional Development & Training Questions
A lot of today’s questions from https://pollgab.com/room/brento have a common theme, but it’s just a coincidence. Listen to the answers.
The post [Video] Office Hours: Professional Development & Training Questions appeared first on SQLServerCentral.
The post [Video] Office Hours: Professional Development & Training Questions appeared first on SQLServerCentral.
SQL Server Resumable Index Operations
The ability to pause and then resume index rebuilds has been added to SQL Server. This is a fantastic feature, and with the release of SQL Server 2019, we can now replicate it on the actual create index process. Learn how to use this feature in this short article.
The post SQL Server Resumable Index Operations appeared first on SQLServerCentral.
The post SQL Server Resumable Index Operations appeared first on SQLServerCentral.
Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, Blocking and Performance
It seems like every DBA has a USB stick or a shared drive filled with scripts they can pull up in almost any situation. How can I build such a library of T-SQL files?
The post Cheat Sheet for SQL Server DBAs - Monitoring Current Activity, Blocking and Performance appeared first on SQLServerCentral.
The post Cheat Sheet for SQL Server DBAs - Monitoring Current Activity, Blocking and Performance appeared first on SQLServerCentral.
Pipelining Configuration Information Securely to Flyway
This article demonstrates two techniques for allowing Flyway to read extra configuration information from a secure location, possibly encrypted. The first technique pipes the contents of the config file to flyway via STDIN, and the second uses PowerShell splatting. This makes it much simpler to use Flyway to manage multiple development copies of a database using role-base security.
The post Pipelining Configuration Information Securely to Flyway appeared first on SQLServerCentral.
The post Pipelining Configuration Information Securely to Flyway appeared first on SQLServerCentral.
Call for Panelists – WIT Panel at PASS Data Community Summit, 2023
Take a moment and submit to be on the WIT panel at the PASS Data Community Summit in Seattle this November. We would like to see more women taking part in this.
The post Call for Panelists – WIT Panel at PASS Data Community Summit, 2023 appeared first on SQLServerCentral.
The post Call for Panelists – WIT Panel at PASS Data Community Summit, 2023 appeared first on SQLServerCentral.
