PowerShell – Deleting those files
Usually I prefer to use C# to delete files (as part of my retention policy for backups) as a stored...
2016-06-01
182 reads
Blog Posts
PowerShell : Script Method Error -Method invocation failed because [Microsoft.SqlServer.Management.Smo.ServerRole] does not contain a method named ‘Script’.
I was working on generating scripts for logins, users and server roles and I could able to to generate scripts...
2016-06-01
630 reads
Powershell, when were my servers rebooted?
One of my servers wasn’t rebooted when it should have been and I never realized it until after the outage was over. The big deal wasn’t that it didn’t...
2016-06-01
63 reads
Powershell, when were my servers rebooted?
One of my servers wasn’t rebooted when it should have been and I never realized it until after the outage...
2016-06-01
531 reads
SQL Server 2016 general availability and Feature-Support // allgemeine Verfügbarkeit und Feature-Support
(DE)
Es ist soweit: Der neue SQL Server, in meinen Augen das beste Release seit vielen, wenn nicht gar überhaupt,...
2016-06-01
547 reads
SQL Server 2016 is here!
Today is the day: SQL Server 2016 is available for download! You can download all the versions (enterprise, standard, web,...
2016-06-01
974 reads
SQL Server Random Workload Generator
Hello Dear Reader! Before I start this blog I want to give credit to Jonathan Kehayias (@SQLPoolBoy | Blog). He’s an...
2016-06-01 (first published: 2016-05-20)
2,200 reads
SSMS bug #1
This happens at my instance of SSMS and at the colleagues' one it doesn't. The SQL Server Agent duplicates its...
2016-06-01
232 reads
“Tuesday Morning” SQL Break – May 31, 2016
Yesterday it was Monday, which is when I usually aim to post a weekly blog and twitter round-up. But since I...
2016-05-31
847 reads
Analyzing David and Goliath datasets on a same chart; Dual Axis in Excel, Power BI and SSRS
[2016-May-31] Two different metrics, two different datasets, one may represent a very high value and the other one is very low....
2016-05-31
1,705 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers