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
29 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
454 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
77 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
56 reads
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
40 reads
Hi, I’m Hamish Watson and I’m running for the PASS Board of Directors.
Hi, I’m Hamish Watson and I am running for the PASS Board of Directors: https://www.pass.org/Governance/Elections.aspx This blog post is why I decided to run for the board, why I...
2019-11-06
31 reads
PASS Summit 2019 – Day 1 Keynote
Today is the first full day of the PASS Summit, and this morning we kicked things off with a 2-hour opening ceremony and keynote. Networking and Growth PASS president...
2019-11-11 (first published: 2019-11-06)
478 reads
MS Ignite Day #2 Recap
Day 2 was my opportunity to be focused and dive into a few technologies that were really peaking my interest, namely Azure Synapse Analytics and SQL Server 2019. Since...
2019-11-13 (first published: 2019-11-06)
333 reads
Microsoft Ignite Announcements
Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform...
2019-11-13 (first published: 2019-11-06)
732 reads
SQL Server 2019 is here
With the release of SQL Server 2019, I wanted to highlight in a single place some things that I’m excited about. Drawing on sessions I presented this year at...
2019-11-06
19 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers