PASS Summit 2012 - Done!!!
Thursday afternoon
Thursday afternoon concluded with How to run SSRS in Sharepoint integration mode, Enriching Tabular with DAX and Monitoring SSAS....
2012-11-23 (first published: 2012-11-13)
1,191 reads
The Smiling DBA
Live Blog: PASS Summit–WIT Luncheon
WIT – Women In Technology 10 anniversary PASS Summit Luncheon
Please go to this link for more info on the speakers and...
2012-11-08
887 reads
PASS Summit 2012–Thursday morning
Using SSIS 2012 for ETL in a Data Warehouse
Well, I feel great relief that my session has been completed, and...
2012-11-08
713 reads
PASS Summit 2012–Day 1
Morning
Could not sleep past 4:30AM this morning, daylight savings time and 2 time zone changes did not help. So, exercise...
2012-11-05
682 reads
PASS Summit 2012–My Schedule
Using SSIS 2012 for Data Warehouse ETL
I have been fortunate to be selected this year to speak at the PASS...
2012-11-01
1,041 reads
When a Covering Index no longer covers
I received an email from my boss on the morning supervisors approve timesheets. He stated that they are complaining about...
2012-10-14
2,069 reads
Part II - Louis Davidson (Dr SQL)–Designing for Common Problems in SQL Server…continued
The PASS Data Architecture Virtual Chapter will host part II of Designing for Common Problems in SQL Server by Dr....
2012-10-09
598 reads
24 Hours of PASS: Hosting Rod Colledge–BI in Sharepoint
The Virtual Chapters of PASS are asked to host sessions during this Fall’s 24 Hours of PASS preview for the...
2012-09-18
999 reads
Lookup transformation in SSIS: Performance Improvements
There are 2 suggestions I hear about when performance tuning the Lookup transformation on a large dimension table when getting...
2012-08-28
9,140 reads
PASS Virtual Chapter August presentations
If you do not know by now, PASS has many virtual chapters that give free webcasts all month long. I...
2012-08-19
772 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