Notes From the March 2014 oPASS Meeting
Rodney Landrum presentingLots of free form demos, very light on slides – nice changeLooked at Power Pivot, Power Query, and Power...
2014-03-24
607 reads
Speaking At SQLSaturday #298 in Jacksonville on May 10, 2014
Got the email confirmation yesterday that I’m on the schedule – looking forward to being back in Jacksonville.
2014-03-24
502 reads
The case for SQL Server 2012 Enterprise (vs. Standard) edition
In celebration of the impending SQL Server 2014 release, and in recognition that a large percentage of my clients are...
2014-03-24
1,064 reads
Collation: Location
I started reading about collations after I had a recent run in with them. As I read I started to...
2014-03-24
644 reads
Collation: Location
I started reading about collations after I had a recent run in with them. As I read I started to...
2014-03-24
847 reads
SQL Server 2012 and 2014 and Windows 8.1 Professsional CPU goes up to 100% all freezes and Analysis Services Crashes
<p>Hi All This is a note that I just sent out. I hope that this helps those contemplating upgrading to...
2014-03-24
1,105 reads
Using Variables and Parameters SSIS
When creating an SSIS package it is always a best practice to use variables, and parameters in 2012, to avoid...
2014-03-24
432 reads
Using Variables and Parameters SSIS
When creating an SSIS package it is always a best practice to use variables, and parameters in 2012, to avoid...
2014-03-24
2,611 reads
SQL Server Enterprise is Cheaper than Standard
Free Month of Plural Site
I'm interested in seeing your responses. Any relevant response will be accepted and a free month...
2014-03-24
1,498 reads
Common Table Expressions in SQL
In SQL Server 2005, Microsoft introduced the Common Table Expression (CTE). CTEs share similarities with VIEWS and derived tables, but...
2014-03-23
1,619 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