2023-02-22 (first published: 2022-02-28)
561 reads
Stairways
To keep up to date with all the technologies in SQL Server, the DBA or developer who wants to stay ahead is faced with the struggle of constant learning. How do you keep up while avoiding information overload, unnecessary detours and dead-ends?
The SQL Server Stairways is our solution to this problem. Designed to smooth out even the steepest learning curve, each Stairway is a SQL tutorial series focused on a single topic and is arranged into no more than a dozen easily-navigable tutorials that we call 'steps'. Each step is the length of a typical magazine tutorial, and emphasizes practical, hands-on learning, with just enough background theory to help you understand the topic at a deeper level.
Using straightforward language and avoiding jargon and marketing babble, each Stairway tutorial series is designed to take you from zero knowledge of a particular SQL Server topic to a level of practical understanding that will allow you to start using that feature in a production environment. The learning gradient is steady and manageable, but also brisk. You won't be wasting time.
Happy climbing!
Stairway to SQL Server Automated Database Testing
Automated testing is a way to ensure you can repeatedly examine your code as you make changes by running a series of tests. Since these are automated, you have the ability to execute all tests with one programmatic call rather than hoping a developer runs all tests. This also allows the effort of writing tests […]
2023-02-22
67 reads
Stairway to DAX and Power BI
Data Analysis Expressions (DAX) can be used in formulas or expressions to calculate and return information from data already in our Power BI models. This Stairway series serves as a progressive introduction to DAX within the context of Power BI, examining the functions, operators and values involved, and examining their operation in practice examples. As a part of introducing DAX functions and overall capabilities, the Levels of the series will also offer a wealth of practical exposure to Power BI features as a part of putting DAX to work in our data models and visualizations.
2023-02-14 (first published: 2011-08-09)
14,576 reads
Stairway to Snowflake
Snowflake is a cloud data warehouse platform that runs on AWS, Azure, and Google Compute Platform. This series looks at the structure and setup of a Snowflake data warehouse.
2021-05-19
1,921 reads
Stairway to Database Containers
Containers are a lightweight way of building applications that run on a host. Similar to virtualization, the container is a virtual OS rather than a full machine. This stairway will walk you through the basis of containers using Docker for Windows and SQL Server inside of a container.
2019-07-06
6,900 reads
Stairway to Data
IT projects can hit problems that turn out to be due to an insufficient understanding of the basic data and data-types, rather than the database design. It is a sorely neglected topic that might seem to be trivial, but certainly isn't. The DBA, with a broad perspective on corporate data can do a great deal to help application developers to avoid the common mistakes that so often happen, and Joe Celko's Stairway gives the busy IT professional a crash course to understanding the nature of the data being processed.
2019-03-26 (first published: 2011-04-07)
3,814 reads
Stairway to Database Design
New to the task of designing and creating a database? Joe Celko, who is one of the most widely read of all writers about SQL, explains the basics. As usual, he comes up with the occasional surprise for even the most seasoned database professional. Joe was the winner of the DBMS Magazine Reader's Choice Award four consecutive years. He has taught SQL in the US, UK, the Nordic countries, South America and Africa.
He served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards.
2019-03-26 (first published: 2011-02-04)
8,068 reads
Stairway to Integration Services
Integration Services is one of the most popular subsystems in SQL Server. It allows you to Extract, Transform, and Load (ETL) data between a variety of data sources and programmatically change data in any manner you can think of and script in C#.
2019-03-26 (first published: 2011-02-10)
26,541 reads
Stairway to Server-side Tracing
Learn how to use the SQL Trace subsystem in SQL Server to audit your instances. This series will examine the basics of SQL Trace and teach you how to set up, schedule, and manage traces and the data generated.
2019-03-26 (first published: 2011-02-01)
2,635 reads
Stairway to SQL Server Agent
SQL Server Agent is at the heart of any live database system. The Agent has a number of uses which aren't always obvious, and so a knowledge of the system is always useful, to developers as well as DBAs. Richard Waymire provides a simple explanation of its many uses.
2019-03-26 (first published: 2011-02-04)
4,144 reads
Blogs
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find...
SQL Server 2022 Administration Inside Out
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
WIT/DEI Mental Health and Wellness Day Challenge to Present
Back in December 2019, I started presenting my session on mental health with lots...
Forums
Calculate log space required on principle for maintenance activity
Hi all, We have a database configured for asynchronous mirroring. We have some planned...
Get a Date Time Stamp of table when another columns value changes.
I have created a table as per below query CREATE TABLE [dbo].[mydbtemp]( [Datetime] [datetime]...
how to write a query by using some filter patterns in SQL Server?
what I want is to apply some filter patterns to search the data. For...
Ask SSC