SQL Server 2012 Virtual Launch
Microsoft organized a virtual event for SQL Server 2012 on March 7, 2012.
You can register the event by using the...
2012-02-02
925 reads
CHECKSUM vs HashBytes
Hashing can be useful in Data Warehousing as well It can give you the ability to break large problems into...
2012-02-01
30,440 reads
SSAS: Currency Conversion Using Measure Expressions
Currency conversions can be implemented several ways as part of a business intelligence solution. In some scenarios it may be...
2012-02-01
5,146 reads
Atlanta MDF Presents Three Awesome Pre-Cons in Atlanta April 13, 2012
Atlanta MDF presents: SQL Saturday #111 Pre-Conference Sessions SQL Saturday is coming back to Atlanta on April 14, and once again, we’ve managed to schedule 3 awesome pre-con sessions...
2012-02-01
12 reads
Atlanta MDF Presents Three Awesome Pre-Cons in Atlanta April 13, 2012
Atlanta MDF presents:
SQL Saturday #111 Pre-Conference Sessions
SQL Saturday is coming back to Atlanta on April 14, and once again, we’ve...
2012-02-03 (first published: 2012-02-01)
1,606 reads
Your Road to Becoming a DBA: Acquiring Experience is Key
Knowing precisely how to start on your next adventure is tricky. With so many options and decisions in front of...
2012-02-01
1,081 reads
Using the Error Output of the Derived Column
The other day I was building a simple data import package when I ran into a common situation; invalid conversions in a Derived Column. The conversion was taking an...
2012-02-01
22 reads
Using the Error Output of the Derived Column
The other day I was building a simple data import package when I ran into a
common situation; invalid conversions in a Derived Column. The conversion
was taking an ISBN13...
2012-02-01
34 reads
Using the Error Output of the Derived Column
The other day I was building a simple data import package when I ran into a common situation; invalid conversions...
2012-02-01
747 reads
Need to create a time dimension down to the millisecond?
Ok, I know that creating a time dimension down to the millisecond is extremely rare. After all, we are talking...
2012-02-01
1,281 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
Question of the Day
RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers