Quick T-SQL Performance Comparison
I’m not a T-SQL guru. When I have something that will run often, or I have performance concerns, I’ll ask...
2012-09-03
1,290 reads
Blog Posts
sp_helptext
My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and...
2012-09-02
4,115 reads
Demonstration of a simple dashboard created with the Tableau Software
Like I said on Twitter, here’s the post about the dashboard I created using Tableau, a BI visualization software. I’ve...
2012-09-01
1,865 reads
Personal Goals
With fall quickly approaching, I thought this would be an ideal time to set some personal goals for the upcoming...
2012-09-01
1,514 reads
Troubleshooting Oracle Link Server - Part2
It's my bad that I did not made a post since long lately. I would not make an excuse like...
2012-09-01
1,069 reads
Building My Event Bag-Part 4
Back to the list, what should go in this minimalist creation? Here’s what I have so far:
laptop (yes)
charger (yes – buy...
2012-08-31
1,517 reads
SQL Server 2012 and SharePoint 2013: Installing on a Virtual Machine
With the preview of SharePoint 2013 now available, I have updated my post SQL Server 2012: Installing on a Virtual Machine to...
2012-08-31 (first published: 2012-08-27)
15,676 reads
SQL Server Guest User – Still a Serious Security Threat
One of the security recommendation inside SQL Server Security Best Practice white paper for guest user is that, to disable...
2012-08-31 (first published: 2012-08-28)
5,273 reads
Thinking on Execution
I read a lot, one the most recent books is The 4 Disciplines of Execution which is, of course, about...
2012-08-31
1,546 reads
Three Not SQL Blogs To Read
Here are three blogs I’ve been reading recently that are interesting. None about SQL, but you might find some value...
2012-08-31
1,937 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers