Simple batch script to generate XMLA and deploy SSAS DB
Reblogged from Data on Wheels - Steve Hughes: As I was working through some issues with my cube design, I realized...
2012-06-17
1,074 reads
Blog Posts
Storage options available in Windows for SQL Server
There are several options available for configuring your storage media in Windows Server 2003 and Windows Server 2008. By understanding...
2012-06-16
2,473 reads
Connection Pooling :At a Glance
What is a Connection Pool?
A connection pool is a group of database connections (with same connection properties) maintained in the...
2012-06-15
8,102 reads
Find unused indexes using sys.dm_db_index_usage_stats
The SQL Server maintains all indexes defined against a table regardless of their usage. Index maintenance can cause significant amounts...
2012-06-15
10,052 reads
Interview questions
Lately, I’ve been asked by several folks about the interview questions that I use when I interview candidates for SQL...
2012-06-15 (first published: 2012-06-11)
11,972 reads
One week after #sqlsat132
It has been nearly one week since SQL Saturday 132 in Pensacola Florida. I was chosen to give my talk...
2012-06-15
711 reads
Slacking Off: The Right Side of the Brain
I think it’s only fitting to follow up a post about performance reviews and self-evaluations with a post about slacking...
2012-06-15
1,016 reads
TechEd North America 2012 videos online
Microsoft has posted ALL the session videos for TechEd North America 2012 and they are available for free! What a...
2012-06-15
1,045 reads
Contained Databases – Preventing Collation Conflicts
One of the demos from my Contained Databases talk looks at the issues you can have when your database collation...
2012-06-14 (first published: 2012-06-07)
2,330 reads
Latest Presentation on SQL Server Mirroring Given at Transcontinental's Offices
With a handful of System Administrators, Network Specialists and DBAs, I gave my third presentation on SQL Server Mirroring this...
2012-06-14
1,513 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