Stairway to Server Management Objects (SMO) Level 5: Moving to the SQLServer Module
In this level you will learn about the SQLServer PowerShell module that ships with modern versions of SSMS.
In this level you will learn about the SQLServer PowerShell module that ships with modern versions of SSMS.
This week I had the opportunity to join many of the U.S.-based Redgaters in Austin to talk about 2024 plans, hear from the product teams, and have some much-needed fellowship. One thing was particularly clear as I listened to various leaders and product managers – the customer drives everything we do. And I have to […]
How do you determine if you're at the top of your profession? Andy Warren has a few thoughts today.
Buy your on-demand ticket today to get access to hundreds of high-quality sessions across all 5 tracks at PASS Data Community Summit 2023. It’s a great way of learning at your leisure if you weren’t able to join us in person last year.
On-demand access is available for non-attendees to purchase for $1295. This will grant you access to all session recordings until November 17, 2024. Click here to buy.
MongoDB is a document database. As such, the data is stored as individual documents. A document is a data structure made up of one or more field/value pairs.
NoSQL is an option for a database platform and Steve wonders if you can discuss and debate the use of NoSQL for your business partners? Or are you going to learn more? He is.
The key finding from our annual ‘State Of’ survey is that there’s a need for skill diversification to keep up with the pace of technological advances in IT world.
How will this skills gap affect you?
Whether you’re just starting out in your career, you’re a seasoned data professional or you’re a senior IT leader wanting to stay ahead of business growth, join our free livestream on January 23rd.
Redgaters Steve Jones, Ryan Booz and Beca Parker will introduce key findings from the survey and offer their thoughts on the big changes coming in 2024 and what you can do to thrive in this changing landscape.
Packing intervals is a classic SQL task that involves packing groups of intersecting intervals to their respective continuous intervals. In mathematics, an interval is the subset of all values of a given type, e.g., integer numbers, between some low value and some high value.
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three similar DAX Time Intelligence functions related to Date: OPENINGBALANCEMONTH(), OPENINGBALANCEQUARTER(). and OPENINGBALANCEYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.
Learning DAX is easy once you install the PowerPivot for Excel 2010 add-in and get practical exposure to using functions, operators and values in DAX formulas. Bill Pearson, business intelligence architect and author, kicks off another Stairway series designed to get you using DAX and PowerPivot quickly to provide actionable business intelligence in your own environment.
This June, LearnSQL is throwing down the gauntlet with a fresh SQL Practice challenge....
By Steve Jones
I delivered a talk today on database deployment best practices at the Denver Dev...
By Steve Jones
desanté – n. the brooding delirium of being sick, which makes time slow to...
Comments posted to this topic are about the item On Being an "Expert"
Advice on how to script out existing Azure (logical) SQL Server logins and mapped...
Hi I have a sequence container which contains an execute package task which loads...
I have a query that is being tracked in the SQL Server 2022 Query Store. I want to add a hint to this query to ensure that the MAXDOP for this query is one. How can I do this with minimal code changes
See possible answers