SSAS: One giant cube or many small ones?
When using SQL Server Analysis Services (SSAS) to build a cube, you may start out with one fact table, but...
2013-01-15
7,708 reads
Blog Posts
The server principal “xxxx” is not able to access the database “msdb” under the current security context.
Problem :
Yesterday Night, One of my team member called & report that some users are getting below error no. 1 while...
2013-01-15
34,371 reads
Top 10 Free SQL Server Tools
What better way to kick off a new year than with a look back at some of the top free...
2013-01-15
12,963 reads
T-SQL Tuesday #38 Recap
This is the wrap up for TSQL Tuesday #38. We had a good turnout this month with some new faces and with some regulars. In total, we had 22...
2013-01-15
9 reads
T-SQL Tuesday #38 Recap
This is the wrap up for TSQL Tuesday #38. We had a good turnout this month with some new faces...
2013-01-15
1,000 reads
Want to see me break SSIS this Thursday?
OK, I’m not really going to break it. I’m just going to beat it up a little bit.
This Thursday evening,...
2013-01-15
886 reads
100 Video and Why BI Projects fail
We thought that our 100 YouTube video on our Katie and Emil YouTube Channel should be a special one... so...
2013-01-14
812 reads
1h SSIS Webinar
1h Free SSIS Webinar - 7th of Feb 2013
We recently submitted a session for SQL Bits and SQL Saturday (UK) and...
2013-01-14
725 reads
Find the (available) amount of memory available to SQL Server (instance / machine)
From time to time, I see the following question posted on various SQL forums asking how we can determine the...
2013-01-14
4,369 reads
Full-Text Search – Word Breakers and Stemmers
There are numerous components to the Full-Text Search (FTS) subsystem in SQL Server that help provide efficient, relative answers to...
2013-01-14
4,508 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