Run For the PASS Board
When the word comes around for elections to the PASS Board, are you one of those people who, even in...
2016-08-22
419 reads
The Scary DBA
Updates to Azure Data Platform Learning Resources
I’m acting as the curator to a list of Azure Data Platform Learning Resources. It’s speakers and teachers, blogs, articles...
2016-08-17
509 reads
Query Store, Force Plan and Dropped Objects
I love the Query Store. Seriously. It’s a huge leap forward in the capabilities of Azure SQL Database and SQL...
2016-08-23 (first published: 2016-08-15)
1,804 reads
Azure SQL Database For Your First Database
This is post 8 supporting Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
In post #6, I talked about...
2016-08-15 (first published: 2016-08-09)
1,462 reads
There Is No Difference Between Table Variables, Temporary Tables and Common Table Expressions
I actually saw the above statement posted online. The person making the claim further stated that choosing between these three constructs was “personal...
2016-08-01
1,387 reads
Monitor Query Performance
Blog post #7 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel. Read about it here.
Sooner or later when you’re working...
2016-07-28 (first published: 2016-07-25)
2,622 reads
Common Table Expression, Just a Name
The Common Table Expression (CTE) is a great tool in T-SQL. The CTE provides a mechanism to define a query that...
2016-07-21 (first published: 2016-07-18)
3,601 reads
Same Query, Different Servers, Different Performance. Now What?
Based on the number of times I see this question on forums, it must be occurring all the time. You...
2016-07-19 (first published: 2016-07-11)
2,417 reads
Carpenters vs. DBAs
Let’s get the caveat out of the way up front, I work for a tool vendor.
If you look around at...
2016-07-05
1,233 reads
CASE Statement in GROUP BY
Set based operations means you should put everything into a single statement, right?
Well, not really. People seem to think that...
2016-07-06 (first published: 2016-06-28)
4,820 reads
Blogs
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers