March 2014 – SQL Server Monthly Maintenance Checklist
image source
Make sure you start the month right by taking the time to make certain your SQL Server environment is...
2014-03-03
1,505 reads
INVENTORY – SQL- SSAS – SSRS – Excel Output – Email
Inventory
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2014-03-03
625 reads
INVENTORY – SQL- SSAS – SSRS – Excel Output – Email
Inventory
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2014-03-03
1,412 reads
Last Weeks Top “Reading” Links #73
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-03-03
998 reads
SQL Named Instance – Static Port Overrides with SQL Browser
I ran across an issue that I haven’t seen since SQL 2000 and had almost forgotten about. Let’s do a...
2014-03-03
1,273 reads
Configure static or dynamic IP and DNS with Powershell
I work in a lot of different offices and conference venues, in addition to my home office. At home, I need a...
2014-03-03
877 reads
Pocket’s Most Popular
I use Pocket for saving some stuff. It works well from Feedly when I see something I know I’ll want...
2014-03-03
712 reads
Virtual SQL Playground Adventure: Building The Virtual Environment
Few blog posts ago, I decided to build a virtual environment for a personal SQL Server sandbox. So, the Virtual...
2014-03-14 (first published: 2014-03-03)
3,677 reads
First Remote Presentation
I threw it out there and they said yes. They being Meredith Ryan of the Albuquerque PASS Chapter. They were...
2014-03-03
507 reads
Using SQLFiddle
SQL Fiddle is a free website that you can use to demonstrate and save a query example in any one...
2014-03-03
3,093 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