SSIS-DTS Package Search 2.0.18 released
SSIS-DTS Package Search 2.0.18 has been released. This is a bug fix release that addresses a problem with the search...
2010-06-08
815 reads
Blog Posts
TechEd 2010 – BI Keynote – Part 1
The second day’s keynote is by Ted Kummert and focuses on BI.
This keynote is in one of the smaller...
2010-06-08
562 reads
TechEd 2010 – BI Keynote Part 2
In the customer demo, a few reports that were built with PowerPivot and Report Builder 3.0, which are helpful to...
2010-06-08
565 reads
TechEd 2010 – Interview With Herain Oberoi
Herain Oberoi is a Group Product Manager for SQL Server and spent 30 minutes with me talking about StreamInsight and...
2010-06-08
553 reads
TechEd 2010 – Monday Afternoon/Evening
After the keynote went back to the press room to write up notes (which I posted already), check email, eat...
2010-06-08
491 reads
TechEd 2010 – Tuesday Morning
Leisurely morning, leaving for the convention center about 8 am. Bus service has been great, they have a staff person...
2010-06-08
477 reads
The BI Conference at TechEd
It’s a bad idea. Co-locating the BI conference at TechEd has created a lot of confusion and annoyance. If people...
2010-06-08
538 reads
The Parallel Data Warehouse Edition of SQL Server 2008 R2 – TechEd 2010
It’s the million dollar question. Literally.
I stopped by the SQL Server area at TechEd in the expo to talk to...
2010-06-08
1,184 reads
T-SQL Tuesday # 07: Walkthrough for Sysprep in SQL Server 2008 R2
T-SQL Tuesday # 07: Walkthrough for Sysprep in SQL Server 2008 R2
This blog entry is participating in T-SQL Tuesday #007, hosted...
2010-06-08
4,928 reads
T-SQL Tuesday #007 - Policy Based Management
It's that time of the month again, time for the next round of T-SQL Tuesday posts. This month is being...
2010-06-08
984 reads
Blogs
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...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
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