Writing R Code in SQL Server - Level 3 of the Stairway to Machine Learning Services
In this level, learn about how to get the tools needing for coding in R and how to execute some code that connects to SQL Server.
2019-05-06
5,202 reads
Stairway Series
Stairway to Database Containers Level 2: Persisting Storage in Containers
The second level of the Stairway to Database Containers looks at the basics of persisting storage in your containers.
2019-02-25
1,218 reads
Stairway to Database Containers Level 1: Getting Started with Database Containers
In the first level of the Stairway to Database Containers, we learn how to get started with Docker for Windows, downloading an image, and starting a container.
2019-02-04
3,168 reads
Stairway to SSAS Tabular
SSAS (SQL Server Analysis Services) is available in two modes, tabular and multidimensional. The new tabular model is easier for those companies who are not already invested in the traditional, multidimensional model. In this stairway, Thomas LeBlanc will teach you how to create tabular models used for reports and dashboards.
2018-06-13
8,906 reads
Exploring SQL Server Indexes: Stairway to Exploring Database Metadata Level 3
This level of the Stairway to Exploring Database Metadata focuses on indexes and all the information you can gather about them.
2020-08-05 (first published: 2016-09-28)
4,406 reads
Stairway to U-SQL Level 4: U-SQL and Data Lake Tooling with Visual Studio
A guide to using Visual Studio to create U-SQL projects and scripts.
2016-07-20
2,788 reads
Stairway to Exploring Database Metadata
In addition to the data that our clients and customers store in a database, there is a tremendous amount of meta data, 'data about data', that describes how the database is set up, configured, and what the properties are for the various objects. This stairway aims to demystify and explain how you can query and use this meta data to more effectively manage your SQL Server Databases.
2016-07-15
3,167 reads
Permissions and Security in Dynamic Data Masking - Step 4 of the Stairway to Dynamic Data Masking
Learn about the permissions associated with Dynamic Data Masking as well as some of the security implications of using this feature.
2020-08-19 (first published: 2016-06-29)
5,585 reads
Stairway to U-SQL
As Microsoft continues to expand the Azure platform, they have enhanced its ability in ways that are quite different from what we've come to expect from SQL Server. Learn about the new language from Microsoft, U-SQL, designed to work with Data Lakes and Big Data in Azure.
2016-06-07
5,103 reads
Stairway to SQL Server Extended Events
Erin Stellato, a Principal Consultant with SQLskills.com, explores the use of Extended Events as a diagnostic data collection tool or SQL Server. She describes how to define efficient low-overhead event sessions that exploit fully the vast number of events, as well as the powerful filtering and data collection options, offered by this new event collection infrastructure. She also demonstrates simple techniques to analyze event data and identify and troubleshoot the causes of poor SQL Server performance, such as long-running queries that consume vast amounts of CPU and I/O resources. It is time to embrace Extended Events and understand all that it has to offer, and Erin's stairway is the perfect place to start.
2015-12-01
3,086 reads
Blogs
The PowerShell Basics If Statement–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
T-SQL Tuesday Retrospective #013: What the business wants
Click here to read previous retrospective entries. From Steve Jones (blog | Twitter) in December 2010...
Daily Coping 14 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SSRS Report doesn't refresh data
Hi all, I have SSRS Report that uses SP as a source. I have...
Last day of the previous month - Format MM/DD/YYYY
I use the below to get Last day of Previous Month, but I want...
How to change schema of all tables, views and stored procedures in MSSQL
Hello Community, I trying to use the following sql code to change the Schema...
Ask SSC