How Search works in SharePoint || Basic Concept
Hey Friends,
Let’s today discuss on the topic How search works. We have already discussed the crawling concept in previous blog:
How...
2013-01-14
690 reads
Blog Posts
Last Weeks Top 10 “Reading” Links #15
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-14
583 reads
MVVM Page Navigation Using MVVM Light On WP7
Page navigation can be a pain to achieve in a true MVVM way, I recently ran in to this problem...
2013-01-14
82 reads
New Year Aspirations
Every year millions of people around the world decide to make new years resolutions. In these resolutions they promise themselves...
2013-01-14
656 reads
Observe Carefully When Things Are Running Fine
Cross-posted from The Goal Keeping DBA blog:
As a worker in information technology, I’ve always been a big proponent of studying systems...
2013-01-14 (first published: 2013-01-10)
2,161 reads
SQL Server Performance Tuning with Free Tools!
The following is a recording of my Performance Tuning for Pirates session recorded by UserGroup.TV at SQL Saturday 125 in...
2013-01-14
933 reads
Day 11 of 31 Days of Disaster: Converting LSN Formats
31 Days of Disaster Recovery
Welcome back to my series 31 Days of Disaster Recovery. Today is day 11, and...
2013-01-12
3,946 reads
Day 12 of 31 Days of Disaster Recovery: Extreme Disaster Recovery Training
31 Days of Disaster Recovery
Fittingly, today’s focus on disaster recovery as part of my 31 Days of Disaster Recovery...
2013-01-12
1,336 reads
SQL Server 2008 Diagnostic Information Queries (Jan 2013)
Here is the January 2013 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-01-12
892 reads
SQL Server 2012 Diagnostic Information Queries (Jan 2013)
Here is the January 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-01-12
902 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