Last Weeks Top 10 “Reading” Links #16
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2013-01-21
754 reads
Blog Posts
Managed Path || Wildcard Inclusion || Explicit Inclusion || Basic Concept
Yesterday I was working with my team mates and their came a requirement to create a site collection but with...
2013-01-21
1,139 reads
New Year Aspirations – Thomas La Rock – Blogging
Most readers will know you already, but before we start on the main part of the interview, tell us all...
2013-01-21
1,019 reads
Notes From The January 2012 OPASS Meeting
OPASS meetings are held at Logans Roadhouse in Sanford now, I think the fourth location over the past couple years,...
2013-01-21
696 reads
Power View Matrix Drill Capabilities
The features and capabilities of Power View have definitely improved since its release. One of my favorite features is the...
2013-01-21
3,733 reads
Pro SQL Server 2012 Practices: Chapter 12
I was very privileged to get the opportunity to write a chapter in a book with some of my friends...
2013-01-21
1,103 reads
Reminder about your invitation from Rohit Garg – MCTS, Microsoft Community Contributor
This is a reminder that on January 14, Rohit Garg – MCTS, Microsoft Community Contributor sent you an invitation to become...
2013-01-21
938 reads
Re-writing MDX calculated members as DAX measures
I have been working on re-creating some logic in a tabular cube that was originally implemented in multidimensional. This involved...
2013-01-21
1,354 reads
SQL Server Reserve 1 user connection for DAC (Dedicated Administrator Connection)……want to confirm ?
Sometime before, I was giving training on basics of SQL Server. One of attendee is having doubt & want to confirm...
2013-01-21
760 reads
Photo cataloguer
If you are anything like me, by know you will have a few thousand digital images spread across multiple directories...
2013-01-20
731 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