Do You Document Your SQL Server Instances?
When I was a novice DBA, I spent little time documenting my SQL Servers. But as I became more experienced,...
2012-06-12 (first published: 2012-06-05)
4,746 reads
Blog Posts
SQL Saturday Pensacola presentation file downloads
I had a great weekend at my fourth annual visit to Pensacola for SQL Saturday, which had many great sponsors,...
2012-06-12
726 reads
SQL Server 2005 Diagnostic Information Queries (June 2012)
Here is the latest version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements, including...
2012-06-12
1,144 reads
T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore
T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore
This blog entry is participating in T-SQL Tuesday #31, hosted this month...
2012-06-12
1,903 reads
T-SQL Tuesday #31 – Logging
This month’s T-SQL Tuesday is hosted by Aaron Nelson (@SQLvariant | Blog). The topic is about logging. Many will talk about...
2012-06-12
1,050 reads
T-SQL Tuesday #31 – Logging
It’s T-SQL Tuesday time again, and this month Aaron Nelson (blog | @sqlvariant) is hosting. The topic is logging, and if...
2012-06-12
1,645 reads
Using PowerPivot to Monitor Reporting Services
PowerPivot is a powerful new tool from Microsoft that has been improved even more in the 2012 release, which you...
2012-06-12
1,533 reads
Creating a Filetable
How do you create a filetable? I assume you’ve enabled Filestream and created a filegroup for your filestream and filetable...
2012-06-11 (first published: 2012-06-05)
5,421 reads
ORM Tools
ORM tools. They’re great. They’re evil.
In the right hands, used the proper way, they can be a very powerful, very...
2012-06-11
3,489 reads
Performance reviews – Self-evaluations
My annual performance review at work is coming up shortly, and this year they’ve decided to do things a bit...
2012-06-11
3,071 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