Refreshing the SQL Server PowerShell Provider
Sometimes SSMS gives you stale results and there you have the Refresh button to fix that.
In SQL PowerShell, the same...
2017-01-06
550 reads
Easy Database Space with dbatools
One of the things that I’ve seen DBAs query for is free space in a database. In fact, this is...
2017-01-20 (first published: 2017-01-06)
3,096 reads
What is ETL?
In my ongoing series on ETL Best Practices, I am illustrating a collection of extract-transform-load design patterns that have proven...
2017-01-16 (first published: 2017-01-06)
2,520 reads
Columnstore Indexes – part 94 (“Use Partitioning Wisely”)
Continuation from the previous 93 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post will talk about some...
2017-01-06
583 reads
Friday Reading 2017-01-06
Happy New Year to all of you out there! I know, I know it’s a week late but hey I’ve...
2017-01-06
343 reads
New String Function – TRIM – in SQL Server vNext
As SQL developer, you must have often come across a scenario where you need to remove the empty spaces at...
2017-01-06
2,083 reads
On Stepping Down and Out… For a Bit
For those of you on the Denver SQL Server User Group e-mail list, you probably heard the news I am...
2017-01-05
356 reads
Database snapshots for everyone!
If you're lucky enough to have SQL Server 2016, go on and upgrade to SP1....you get extra-lucky special database snapshots...
2017-01-05
625 reads
Watch the Manual DBA v Automated Deployment Challenge
At last year’s SQL in the City, I played the part of a manual DBA making changes and deploying those...
2017-01-12 (first published: 2017-01-05)
1,565 reads
Hold The Fort
Have you ever heard the phrase “Hold The Fort”? Long ago in battle supply routes were targeted by enemy regiments...
2017-01-12 (first published: 2017-01-05)
1,323 reads
Blogs
Speeding Up Patching – Beyond Patch Delivery
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
Monday Monitor Tips: Query Recommendations
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Forums
Azure SQL Hyperscale Unveiled
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers