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,273 reads
Blog Posts
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
16 reads
Preparing for SQLSaturday #49
We’re still in the early stages so the pace is comfortably slow. We’ve got about 30 sessions in already (plenty...
2010-05-20
516 reads
SQL Server MasterClass – London
Further to my post on May 18th regarding the above event – I have been able to secure a further £50...
2010-05-20
526 reads
Using PATINDEX to Split Column Data
A colleague of mine received an Excel file that he needed to load into a table for future lookup values....
2010-05-20
1,176 reads
What 5 things should SQL Server get rid of?
Paul Randal (Blog|Twitter) recently kicked off this meme by listing the 5 things he thinks SQL Server should get rid of....
2010-05-20
918 reads
Daily SQL Server 2008 New Feature – Day 10
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-05-19
667 reads
It’s a Data World
I saw this blog about a report from CITA (wireless industry group) that people tend to use their cell phones...
2010-05-19
671 reads
June OPASS Meeting Date Change
Andy Warren (@sqlandy) already blogged about the change here, but I there might actually be someone who reads my blog...
2010-05-19
264 reads
oPASS June 2010 Meeting Date Change
Normally we meet on the second Tuesday of the month, but in June we’re going to have to push the...
2010-05-19
566 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers