Searching SQL Servers & Saving Results, with Write-SqlTableData
The other day I was chatting with my friend Tom Roush ( B | T ) and he mentioned needing to scan every database on every SQL Server instance...
2016-10-14
48 reads
Aaron Nelson
Get-SqlLogin and Remove-SqlLogin Are Here
Learn how to use the login commands included with SSMS2016 from PowerShell.
2016-09-01
3,387 reads
Next for the PoSh VC: PowerShell, SQL and Power BI
That’s right, PowerShell & Power BI.
How does this work you ask?
Well back in July, Rob Sewell ( b | t ) gave us...
2016-08-12
233 reads
Next for the PoSh VC: PowerShell, SQL and Power BI
That’s right, PowerShell & Power BI. How does this work you ask? Well back in July, Rob Sewell ( b | t ) gave us a preview of this,...
2016-08-12
5 reads
The cmdlets Are Coming! The cmdlets Are Coming!
A number of new SQL Server PowerShell cmdlets have been released and the Microsoft is asking for feedback on what else you'd like to see.
2016-07-01
1,208 reads
Webinar on 25 New PowerShell cmdlets for SQL Server and more!
Next week Chrissy LeMaire ( b | t ), Laerte Junior ( b | t ), Rob Sewell ( b | t ) and I will be hosting a...
2016-06-30
547 reads
Webinar on 25 New PowerShell cmdlets for SQL Server and more!
Next week Chrissy LeMaire ( b | t ), Laerte Junior ( b | t ), Rob Sewell ( b | t ) and I will be hosting a...
2016-06-30
2 reads
Connect is Working! Get in While the Getting is Good!!!
TL;DR: Go Vote / File on Connect NOW! For years I’ve avoided Connect, it’s true. In an ironic twist fit for a recursive-CTE I think I quit using Connect...
2016-05-07
4 reads
Connect is Working! Get in While the Getting is Good!!!
TL;DR: Go Vote / File on Connect NOW!
For years I’ve avoided Connect, it’s true.
In an ironic twist fit for a recursive-CTE...
2016-05-07
263 reads
What Does the Near-Future of PowerShell & SQL Server Look Like? An Interview with Ken Van Hyning
Ken Van Hyning is the Engineering Manager for the SQL Server tools, including SQLPS.
2016-04-19
1,652 reads
Blogs
Regression Testing: DAX User Defined Functions
User Defined Functions is a new feature in PowerBI currently in public preview. There...
The fundamental requirements of a reporting system
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management
By Chris Yates
When it comes to managing complex database environments, having the right monitoring solution is...
Forums
SQL MI Next-gen general purpose tier
Has anyone used Azure SQL MI on the next-gen general purpose tier, Microsoft documentation...
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
The Last Good DBCC Run
Comments posted to this topic are about the item The Last Good DBCC Run
Question of the Day
The Last Good DBCC Run
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers