Create Azure Data Studio SQL Notebooks with PowerShell
At PASS Summit today I gave a presentation about SQL Notebooks in Azure Data Studio for the DBA. I demo’d the PowerShell module ADSSQLNotebook. which you can also find...
2019-11-07
24 reads
Blog Posts
Finding out the most cached database in the buffer cache - The DMV Way
While there are many ways and criteria to find out what database is the most used, under optimized, trouble maker etc....., here is one more to find out the...
2019-11-07
192 reads
Getting Started With Terraform
TEST Getting started with using Terraform for infrastructure can be a bit daunting if you've not dived into this stuff before. I put this together as a write up...
2019-11-07
35 reads
Pass Summit 2019 Keynote Day 2
I’m blogging they Keynote! One of my bucket list things has always to live blog a keynote at Pass Summit ... Continue reading
2019-11-07
100 reads
PASS Summit 2019: Day 1 Keynote – my takeaways
I’ve been at the bloggers table for two years now. I felt honored to be selected this year too. The day has started a bit differently – bloggers were...
2019-11-07
3 reads
Personal Goal Accomplished: Speaking at the PASS Summit
I mentioned on twitter that a family tragedy about a decade ago had resulted in a false start with respect to this goal: After a false start about a...
2019-11-07
17 reads
Removing SSMS Completion Time–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. If you’ve upgraded your SSMS lately, you might...
2019-11-07 (first published: 2019-10-30)
774 reads
SQL Server Backup / Restore from URL
I think many have covered how you should backup your SQL Server database to Azure storage (also known as backup to URL) but what about restoring? Lets assume you...
2019-11-07
436 reads
That slippery slope
We need to have processes and rules. They are important to any business. That said, exceptions are also going to ... Continue reading
2019-11-07 (first published: 2019-10-30)
404 reads
Voting for the PASS Board
Voting is open for the PASS Board, as of yesterday (Nov 6). The candidate page is up, and there are 6 amazing candidates for 3 slots. They are: Chris...
2019-11-07
67 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers