Lunch is for Wimps
A real life DBA tale from the trenches with some awesome advice. That’s what one reader chose to share with...
2012-07-03
1,275 reads
SQL Server Get Identity after Insert using SP
I thought I will share my experience how you can get identity value after insert using SQL Server. I have...
2012-07-03
632 reads
RSS pubDate format in SQL Server
Today I had to write T-SQL code to convert date into very specific date format (Mon, 02 Jul 2012 19:24:05...
2012-07-02
400 reads
Colorado Wildfires
More than a few people have asked how I’m doing with all the fires in Colorado, so I wanted to...
2012-07-02
986 reads
Three reasons for normalization
In this article we cover three reasons for normalization (from our point of view). We created the article and included...
2012-07-02
294 reads
July Question: If you could pick your manager, what ideal qualities would he or she have?
I think all of us have had poor, good, and great managers at one time or another in our career....
2012-07-02
1,963 reads
Comparing DirectQuery and ROLAP for real-time access
In the multidimensional model in SSAS, there is a storage mode called relational OLAP (ROLAP), which is the multidimensional solution...
2012-07-02
1,377 reads
Why Isn’t Everyone Accountable? A Work Conundrum
A pattern I’ve seen over and over again at many different jobs is that some people are not held accountable...
2012-07-02
774 reads
Lost in Translation – Deprecated System Tables – syscacheobjects
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-02
1,059 reads
Speaker Selection for SQLSaturday Orlando-Group #3
So far we’ve selected 8 speakers for SQLSaturday #151 in Orlando this year (see Group #1 and Group #2), today...
2012-07-02
761 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers