PowerHour - Online PowerShell Lightning Talks!
Earlier this week, the PowerHour was announced. What is it? It’s kind of like a virtual user group. One hour, 6(ish) lightning demos (10 minutes or less), centered on...
2018-08-03
21 reads
Azure Runbook Configuration
Hello everybody! Greetings from the very warm state of Texas! One of the most popular questions I get when talking...
2018-08-23 (first published: 2018-08-02)
2,120 reads
The Mystery of the Exploding T-Log
There were a stack of errors overnight in the DB123 database on SQL01, including one horror show error:
--
Log Name: ApplicationSource: MSSQLSERVERDate: 5/24/2018...
2018-08-20 (first published: 2018-08-02)
2,906 reads
Dear SQL DBA: Remembering Robert Davis, DBA Hero
What makes a person a DBA Hero? In this episode, I talk about how Robert Davis made a huge impact on the SQL Server community, and the traits that...
2018-08-02
38 reads
How to Change SQL Server License or Product Key?
Yesterday, I was doing SQL Server Database stress and benchmarking testing on the client side. When I started ramping-up more...
2018-08-02
138,459 reads
First time speaker at Denver’s SQL local group
06/21 was the date that marked my career as data professional, for the first time ever I decided to participate as...
2018-08-01
268 reads
Using the built-in System Health session
When Microsoft introduced Extended Events (XE) in 2008, they also gave us a built-in XE session called system_health (though it’s...
2018-08-16 (first published: 2018-08-01)
5,561 reads
Don’t do these things in SQL Server
Recently Brent Ozar posted a link to the PostgreSQL “Don’t do this” page, which I am shamelessly reproducing below, re-tailored...
2018-08-01
525 reads
SQL Homework – August 2018 – Set up database mail
This month’s homework is pretty simple to say, not necessarily easy to do. Set up database mail.
Why database mail?...
2018-08-01
341 reads
A PowerShell Conference In A Book
A Question
Shortly after the European PowerShell Conference and the PowerShell and Devops 2018 summit in the USA Mike Robbins b...
2018-08-17 (first published: 2018-08-01)
2,756 reads
Blogs
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Kantor Resmi BCA KCU KUDUS Telp:0821°7555°651
Telp/Wa 628217555651 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
Kantor Resmi BCA KCU GANG TENGAH Telp:0817°825°533
Telp/Wa 62817825533 Gg. Tengah No.88, Kranggan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50137
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