New SQL Saturdays Coming
Quite a few new SQL Saturday events were announced recently in Louisville, Phoenix, and Raleigh.
Smart Virtualization
With so many people looking at virtualizing their environments, it's easy to assume it's easy to get done. Steve Jones, however, points out some advice from a very performance oriented company: the NYSE.
Light Weight Monitoring using Extended Events
Extended events provide DBAs with a new lightweight tool to monitor SQL Server performance.
TSQL Challenge 28 - SELECT TOP N articles from each category from a SQL Server 2000 database
The challenge is to write a query that returns the articles to be displayed in the home page of the website. N number of articles from each category is to be selected where N is configured in the Categories table. Each category should select the most recent N articles. ArticleID can be used to identify the most recent articles. An article with a higher number indicates a more recent article.
Clustered instance will not start after removing builtin admins
After removing the builtin administrators group the clustered services do not start. Perry Whittle walks through the issue and what you can do to correct things.
Company Rewards
Is there something that your company could do for you that would show that they valued your employment? That you were somehow important to them? Answer this Friday's poll.
Microsoft Access: Business Intelligence on a Shoestring
Learn how to deliver dynamic content by building a meaningful Business Intelligence Application, utilizing only what is available on the client's desktop, when a Data Warehouse BI Application, SQL Server and SSIS/SSRS aren't an option.
How to find unused Stored Procedures in SQL Server 2005/2008
Use dynamic PivotTables to identify unused Stored Procedures in a SQL Server 2005/2008 database
Adding Actions to a Cube in SQL Server Analysis Services 2008
Actions are powerful way of extending the value of SSAS cubes for the end user. They can click on a cube or portion of a cube to start an application with the selected item as a parameter, or to retrieve information about the selected item. Actions haven't been well-documented until now; Robert Sheldon once more makes everything clear.
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