SQL Lunch #68 – Designing Your First Power View Report
Next week I will be speaking on designing your first Power View report for SQL Lunch. Be sure to join me...
2012-07-11
1,137 reads
Blog Posts
Baton Rouge SQLSaturday #150 & Tech Day .Net 1 track
August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. LSU has offered...
2012-07-10
2,980 reads
Book: Expert Performance Indexing for SQL Server 2012
After about a year of work and a month of waiting, the book I wrote with Ted Krueger (Blog | @Onpnt)...
2012-07-10
1,877 reads
Retrieving password policy settings for SQL login accounts
Today, I wrote the following query for our internal audit report for SAS70. This query provides all the necessary details...
2012-07-10
3,426 reads
Service Broker Adventures: Stucked Queue Monitors
This week I'm in London helping a client with its large scale Service Broker deployment,
mainly troubleshooting some strange problems with...
2012-07-10 (first published: 2012-07-03)
4,286 reads
SQLSaturday #122, Louisville
Date: July 21, 2012
Session: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe you’ve...
2012-07-10
670 reads
SQLSaturday #164, Cleveland
Date: August 18, 2012
Session 1
Title: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe...
2012-07-10
705 reads
SSIS 2012 Change Data Capture (CDC) Control Task
Change data capture was introduced in SQL Server 2008 and has been pretty popular ever since. The basic concept behind...
2012-07-10
4,117 reads
Time Zones
Why don’t we have a function like the one in this article to convert from time zone to time zone?...
2012-07-10
962 reads
Back Across the Pond
This coming weekend is SQL in the City – London 2012. Friday, July 13, and Saturday, July 14, I’ll be at...
2012-07-09
999 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