SQL Server

Power BI Small Multiples Visual Example

• by Additional Articles

• MSSQLTips.com

• Power BI

• Article

Power BI has a new feature which is the Power BI Small Multiples visual. In this article we cover how to enable this feature and also walk through an example of how to use this in a Power BI report.

2021-03-05

SQL Server 101 Tutorial

• by Additional Articles

• MSSQLTips.com

• SQL Server

• Article

Since its initial release in 1989, SQL Server has come a long way from its base functionality as an enterprise level database platform. While the core of SQL Server is still it's database engine, it is now so much more than just a relational database plat

2021-03-04

Using Azure SQL Data Sync to Replicate Data

• by Additional Articles

• MSSQLTips.com

• Azure
• Azure SQL

• Article

Learn how to setup and use Azure SQL Data Sync to synchronize and replicate data from various locations including Azure SQL Database, cloud and on-premises databases.

2021-03-02

sqldf in R Example for SQL Server

• by Additional Articles

• MSSQLTips.com

• R Language

• Article

R has a package called sqldf that allows developers to manipulate data inside a dataframe in the same way a SQL developer queries a SQL table which we will cover with examples in this article.

2021-03-01

Partitioned Tables Cause Longer Plan Compilation Times

• by Additional Articles

• Brent Ozar Unlimited Blog

• Partitioning

• Article

Folks sometimes ask, “When a table has more indexes, and SQL Server has more decisions to make, does that slow down execution plan generation?”. Brent Ozar talks through his response in this article.

2021-02-26

Learning SQL Server

• by Additional Articles

• MSSQLTips.com

• Professional Development

• Article

Learn about the core SQL Server concepts to build your skill set including the architecture, database design, development, administration and more.

2021-02-24

DBA in training: SQL Server under the hood

• by Additional Articles

• SimpleTalk

• SQL
• Training

• Article

In this article of the series, Pamela Mooney explains the architecture of SQL Server under the hood, including some query anti-patterns to avoid.

2021-02-23

Securing SQL Server with DoD guidelines

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

Making sure your SQL Servers are secured against malicious users is difficult. The United States Defense Information Systems Agency (DISA) publishes a set of guidelines for organizations securing different pieces of software that connect to the US Department of Defense’s networks (DoD). Whether you’re working with the DoD or not, these Security Technical Implementation Guides (STIGs) are a good resource to help you understand potential security vulnerabilities and mitigate them.

2021-02-22

Mastering TempDB: The basics

• by Additional Articles

• SimpleTalk

• Learn SQL

• Article

Mastering TempDB is a critical skills for SQL Server DBAs. In this article, Monica Rathbun explains the basics of TempDB including configuration.

2021-02-19

SQL Server triggers: The good and the scary

• by Additional Articles

• SimpleTalk

• Database Administration

• Article

SQL Server triggers are another tool in your DBA or Dev toolbox. Edward Pollack explains what can go wrong with triggers and how to correct those issues.

2021-02-18