Video: Bringing Together Databases, Virtualization and Storage
Bala Narasimhan, Vice President of Products from PernixData, and I recently sat down and discussed the convergence of infrastructure, SQL Server,...
2015-05-07
372 reads
Blog Posts
Azure SQL Data Warehouse
Analytics Platform System (APS) is Microsoft’s massively parallel processing (MPP) data warehouse technology. This has only been available as an on-prem...
2015-05-06
1,342 reads
Backup your SQL Server jobs using PowerShell script
This post will help you create a SQL Server job to backup all the jobs in a SQL Server Agent...
2015-05-06
163 reads
Backup your SQL Server jobs using PowerShell script
This post will help you create a SQL Server job to backup all the jobs in a SQL Server Agent of an instance. It’s an useful job that you...
2015-05-06
7 reads
Backup your SQL Server jobs using PowerShell script
This post will help you create a SQL Server job to backup all the jobs in a SQL Server Agent...
2015-05-06
195 reads
Backup your SQL Server jobs using PowerShell script
This post will help you create a SQL Server job to backup all the jobs in a SQL Server Agent of an instance. It’s an useful job that you...
2015-05-06
11 reads
Join me Tues, May 12 – Consumption Based Architecture for BI
Join me on Tuesday, May 12 as I discuss consumption based architecture for BI Solutions with Pragmatic Works.
2015-05-06
576 reads
May 2015 – SQL Server Monthly Maintenance Checklist
image source
It’s time for a monthly reminder to review you SQL Server environment. Hopefully over the last few months of...
2015-05-06
654 reads
Moving SQL Server data between filegroups – Part 2 – The implementation
In this post we are going to show the implementation of a PowerShell script using SMO to move data between filegroups...
2015-05-06 (first published: 2015-04-28)
7,175 reads
Notes on Presenting
As you may know I’m preparing to write my first presentation. I have a great abstract and an outline of...
2015-05-06
546 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers