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
16 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
Scheduling Ola Hallengrens Maintenance Solution Default Jobs with Powershell
If you are a SQL Server DBA you should know about Ola Hallengren and will probably have investigated his Maintenance...
2015-05-20 (first published: 2015-05-06)
5,894 reads
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,350 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
579 reads
Learn tSQLt and Unit Testing in Philadelphia
SQL Saturday #390 is in Philadelphia on June 6, 2015. This is my second time attending the event, and not...
2015-05-15 (first published: 2015-05-06)
5,734 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
672 reads
Identity Removal - WaterOx Consulting
Reading Time: 2 minutesMen In Black are not the only ones that can remove an...
The post Identity Removal appeared first...
2015-05-19 (first published: 2015-05-06)
6,426 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
555 reads
Putting Your Head in the Clouds 1 – An introduction to Cloud Computing
By David Postlethwaite
Although the concept of Cloud Computing and Microsoft Azure have been around for a number of years it...
2015-05-06
734 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers