Four Data Integration Design Questions to Ask
We get requests to move data between custom systems regularly, even within systems. I was advising a client on something fairly simple—a collection of tables out of one vendor...
2019-04-29
7 reads
Blog Posts
It’s all just data.
Tables, stored procedures, views, logins, constraints, etc, etc. It’s all just data. In every database system I’ve ever worked on ... Continue reading
2019-04-29 (first published: 2019-04-17)
493 reads
More Software Quality with DevOps and CD
Tomorrow is the SQL in the City Summit in London. Right now I’m in a Heathrow airport hotel, finalizing some prep for the event. I have to run a...
2019-04-29
14 reads
Speaking at PowerShell Summit 2019
Speaking at PowerShell Summit 2019!
I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2019 the conference runs from April 29th 2018 through...
2019-04-29
6 reads
Speaking at PowerShell Summit 2019
Speaking at PowerShell Summit 2019! I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2019 the conference runs from April 29th 2018 through...
2019-04-29
28 reads
SQL Server Management Studio 18.0 is available now.
SSMS 18.0 is available for download now.Microsoft has released the new version of SSMS, the free client tool from Microsoft to manage to the SQL Server infrastructure from SQL...
2019-04-29
16 reads
SQL Server Management Studio 18.0 is available now.
SSMS 18.0 is available for download now.Microsoft has released the new version of SSMS, the free client tool from Microsoft to manage to the SQL Server infrastructure from SQL...
2019-04-29
1,064 reads
Weekly reading #13
#13, #13, #13 – that must be a good week! This firs week of May we call a “long weekend” as we have at least 2 days off! This...
2019-04-29
41 reads
What is Automation?
Today I got a bit closer to a meaningful definition of automation, as it applies to the software development process. I’ve been turning this concept over in my head...
2019-04-29
17 reads
What is Implicit Conversion?
Another quick post of simple changes you can make to your code to create more optimal execution plans. This one is on implicit conversions. An implicit conversion is when...
2019-04-29 (first published: 2019-04-17)
1,149 reads
Blogs
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...
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...
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