The Truth about SQLPS and PowerShell V2
With the release of SQL Server 2008 R2 there have been claims that sqlps is really PowerShell V1 under the...
2010-05-28
5,537 reads
Chad Miller
SQL Agent Visual Job Schedule Viewer
If you have experience with the SQL Server Agent you quickly realize the difficulty in managing job schedules. On a...
2010-05-15
4,786 reads
T-SQL Tuesday #006 Blobs, FileStream and PowerShell
In case you’re wondering about the title T-SQL Tuesday, it’s a monthly collection of SQL Server related content where a...
2010-05-11
4,160 reads
T-SQL Tuesday #005: SSIS Reporting
Automating SQL Server Integration Services (SSIS) administration through PowerShell is very different than writing scripts against the core database engine....
2010-04-13
1,204 reads
Parsing SQL for Table Names
Visual Studio Team System 2008 Database Edition (VSDB) ships with a .NET class for parsing T-SQL. I’ve previously blogged about...
2010-04-04
2,180 reads
Powerscripting Podcast 2
I was interviewed by Jon (@JonWaltz) and Hal (@Halr9000) in episode 106 of the PowerScripting Podcast. This was my second...
2010-03-25
1,925 reads
Goodbye Live Spaces, Hello WordPress
After blogging on Live Spaces for a 517 days, I’ve made the difficult decision to move to my own domain...
2010-03-25
659 reads
I’ve Moved and So Should You
After blogging on Live Spaces for a couple of years, I’ve made the difficult decision to move to my own...
2010-03-21
522 reads
SQLIse A Powershell Based SQL Server Query Tool
SQL Server Powershell Powershell Extensions (SQLPSX) has been updated to version 2.1. The most notable change is the addition of...
2010-03-10
1,977 reads
Querying Oracle from Powershell Part 2
In part one we installed and configured the Oracle client software, in this post we will query an Oracle database...
2010-03-01
3,206 reads
Blogs
AI Experiments: Claude Solved a DAB Issue
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Audit – Security Compliance Frameworks (Part 1)
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Forums
Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened
Comments posted to this topic are about the item Can You Really Downgrade from...
What is CPU Usage?
Comments posted to this topic are about the item What is CPU Usage?
Limiting Checkpoints
Comments posted to this topic are about the item Limiting Checkpoints
Question of the Day
Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers