SQL Saturday 220 Atlanta GA
That latest installment of SQL Saturday Atlanta was just announced. On May 18th 2013 SQL Server experts from all over...
2013-02-04
636 reads
Blog Posts
SQL Server Analysis Services Tabular KPIs
A few weeks ago, I wrote a blog post that discusses implementing KPIs in SQL Server Analysis Services Multidimensional. For...
2013-02-04
2,625 reads
SQLSaturday #184 in New Haven, CT - March 2, 2013
So much SQL, and so little Saturdays. SQLSaturday is truly a world-class event
happening all over the globe. Just this
past Saturday,...
2013-02-04
1,248 reads
SSIS Webinar in 3 days... 6 seats left
Our first SSIS 1h Free webinar will take place in 3 days (Thursday) and has only 6 seats left (out...
2013-02-04
643 reads
Where Should Database Administration Go?
For the past 5 or 6 years, we have seen lots of innovative products emerged, from smartphone to tablets, from...
2013-02-04
786 reads
A Month of PowerShell – Day 3 (Security)
Welcome to Day 3 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-03
1,615 reads
A Month of PowerShell – Day 2 (Variables and Operators)
Welcome to Day 2 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-02
1,859 reads
Using Inline “With” Blocks to Augment a VB.NET Default Constructor
Say you have a simple data transfer class that looks like this:
Public Class Employee
Public Property Name As String
Public...
2013-02-02
1,153 reads
A Month of PowerShell – Day 1 (Getting Started)
Welcome to Day 1 of my “A Month of PowerShell” series. PowerShell is one of those things that I know...
2013-02-01
2,210 reads
Activating Windows 8 from MSDN
I installed Windows 8 recently and needed to activate it. I didn’t do this on the install since I didn’t...
2013-02-01
1,132 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers