The Best Solution for SQL Server Partitioning Sliding Window
Turns out there's a shortage of solutions online for easily managing partitioned tables in SQL Server. Well... That's where I come in!
top of page
Guy Glantser
- Apr 26, 2022
- 1 min
Which Tables are Referenced by a View?
I published a very simple script to query for all the objects referenced by a specific object in the local database (e.g. a view)...
Guy Glantser
- Apr 24, 2022
- 5 min
Modernizing Your SQL Server
So you have an old SQL Server. It's time to make a change, but where do you start?
Guy Glantser
- Apr 10, 2022
- 4 min
When and How to Shrink Your Database
Shrinking a database is a bad thing, but if you have to do it, then here is how to do it right...
Eitan Blumin
- Apr 5, 2022
- 1 min
Remote Execution using Powershell and SQL Server
How to remotely control multiple computers without having to log into them? Do any task from one central location, and make it scalable?
bottom of page