PowerShell Week at SQL University – Post 5
In the previous posts we’ve just been poking around with PowerShell and trying to make the examples something that actually...
2011-01-20
1,205 reads
SQLvariant
PowerShell Week at SQL University – Post 5
In the previous posts we’ve just been poking around with PowerShell and trying to make the examples something that actually means something to a SQL person whenever we ca. ...
2011-01-20
9 reads
PowerShell Week at SQL University – Post 4
Recap
So far we’ve walked though how to turn on PowerShell and add modules, adding SQL Server 2008 snapins and using...
2011-01-18
1,374 reads
PowerShell Week at SQL University – Post 4
Recap So far we’ve walked though how to turn on PowerShell and add modules, adding SQL Server 2008 snapins and using PowerShell variables, what cmdlets and functions are, what...
2011-01-18
27 reads
PowerShell Week at SQL University – Post 3
Providers
What are Providers? Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and...
2010-05-20
813 reads
PowerShell Week at SQL University – Post 3: Providers, PSDrive
Providers
What are Providers? Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and...
2010-05-20
1,284 reads
PowerShell Week at SQL University – Post 3: Providers, PSDrive
Providers What are Providers? Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and traverse-able just like a directory structure hard drive....
2010-05-20
23 reads
PowerShell Week at SQL University – Post 2
Cmdlets, Functions and Snapins
So far we’ve learned how to open up PowerShell and add on to it with some modules;...
2010-05-19
1,073 reads
PowerShell Week at SQL University – Post 1
Getting Started With PowerShell Variables
Yesterday we laid the ground work for PowerShell Week. Today we will learn about Variables in PowerShell. You will...
2010-05-18
997 reads
PowerShell Week at SQL University – Post 0
Welcome to PowerShell Week at SQL University. For regulars at SQLvariant, SQL University is something Jorge Segarra organized to get...
2010-05-17
1,064 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers