Dear #SQLAwesomesauce: Is this idea batsh** crazy?
I’ve been out of town and off the grid – nothing like 10 days of family camping and roadtripping to unwind!...
2012-08-15
868 reads
Blog Posts
Excel 2013 and BI
On July 16, 2012, Office 2013 Preview was released to the public (download). Excel 2013 now includes a lot of the...
2012-08-15
1,856 reads
Find failed SQL Agent jobs using Transact-SQL script
Today, I’m sharing the following T-SQL script which you can use to find which SQL Server Agent Jobs failed yesterday....
2012-08-15
2,309 reads
JSSUG Speaker Idol 2012
The Jacksonville SQL Server User Group (JSSUG) has always encouraged new talent to be added to the pool of local...
2012-08-15
1,104 reads
PowerShell Saturday in Charlotte, NC
If you are in or around the Charlotte, NC area, there is a PowerShell Saturday coming your way on September...
2012-08-15
1,352 reads
SCRIPT: Find the row count of all tables and views
Today I’m sharing another script that I often find useful – Queries to find the count of rows from tables and...
2012-08-15
15,371 reads
SQL Server: Understanding the Data Page Structure
We all know very well that SQL server stores data in 8 KB pages and it is the basic unit...
2012-08-15 (first published: 2012-08-12)
8,780 reads
The Home Server is Back
After reading about the Amazon/Apple attack this morning, I grabbed a second cup of coffee and went in search of...
2012-08-15
714 reads
VM Guest Memory – Watch these numbers !
I have been using VMware vSphere client for a while now and the person who inspired me to use this...
2012-08-15
1,430 reads
Choosing a Mobile Workstation
I get a lot of e-mail and Twitter requests for advice about what laptop someone should buy. I don’t mind...
2012-08-14 (first published: 2012-08-11)
2,269 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