Professional Reading

1421 posts

This category contains links to items I have been reading lately. As I tag them in my workflow, they will show up here to share. The topics will vary widely, but will usually relate to my work one way or another.

/ Link, Professional Reading
Introduction to PowerShell with SQL Server Using Invoke-SQLCMD - Simple Talk

Introduction to PowerShell with SQL Server Using Invoke-SQLCMD – Simple Talk

PowerShell is the preferred scripting tool used by Windows and Active Directory administrators. It can also be used to administer SQL Server or even just export data. In this article, Greg Moore demonstrates how to use the PowerShell cmdlet Invoke-SQLCMD to export data from SQL Server.

Source: Introduction to PowerShell with SQL Server Using Invoke-SQLCMD – Simple Talk

/ Link, Professional Reading
The Crimes of Chicago: Working with Data in MongoDB - Simple Talk

The Crimes of Chicago: Working with Data in MongoDB – Simple Talk

NoSQL databases like MongoDB are gaining popularity, but using the right tools for the job at hand is most important. In this article, Phil Factor demonstrates how to work with a MongoDB database and how to use PowerShell with MongoDB so that the process can be automated.

Source: The Crimes of Chicago: Working with Data in MongoDB – Simple Talk

/ Link, Professional Reading
Power BI Introduction: Working with SQL Server data in Power BI Desktop — Part 5 - Simple Talk

Power BI Introduction: Working with SQL Server data in Power BI Desktop — Part 5 – Simple Talk

Data for Power BI can come from many sources, but often the data is hosted in SQL Server. In this article, the fifth of the series, Robert Sheldon demonstrates how to work with SQL Server data in Power BI Desktop, including relationships between tables.

Source: Power BI Introduction: Working with SQL Server data in Power BI Desktop — Part 5 – Simple Talk

/ Link, Professional Reading
Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4 - Simple Talk

Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4 – Simple Talk

Power BI allows you to use parameters to make your reports dynamic. In this article, Robert Sheldon demonstrates how parameters can be used to substitute connection information, query filters, or even calculations within the query.

Source: Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4 – Simple Talk

/ Link, Professional Reading
Why Everyone Developing T-SQL Needs to Learn About Graphical Execution Plans - Simple Talk

Why Everyone Developing T-SQL Needs to Learn About Graphical Execution Plans – Simple Talk

Microsoft provide graphical execution plans to show just what is going on behind the scenes when a query runs. For example, the plan tells you which tables, indexes, or views were accessed and how joins are physically performed. It’s not a mystery once you know what is going on.

Source: Why Everyone Developing T-SQL Needs to Learn About Graphical Execution Plans – Simple Talk

Loading...