Transact SQL – Windowing Functions – Lag and Lead

Background Have used Windowing Functions for years now. But, never used Lag and Lead. Just thought it was too hard to layer on top of what was already hard for me.   Easy Finally today, I ended up dealing with something actually hard for me. A good man gracefully scaled it and he sprinkled in … Continue reading Transact SQL – Windowing Functions – Lag and Lead

Pastor John Gray

  Background There are things each of us needs to learn about leadership. I like how John Gray delivers this message on spiritual attack.   Videos Maggie Dow Pastor John Gray*** NEW ** I Confess ** I'm Broken and Sorry ** 8.30.2020 Videos Video #1 Channel:- Maggie Dow Published On:- 2020-August-30th Link   Scripture   … Continue reading Pastor John Gray

SQLCMD:- Informational Message – “Changed database context to ….”

Background Let us quickly address a message pattern that is familiar to those who use sqlcmd. Message The message reads "Changed database context to ...." Source It is sourced to the presence of "use [database]" within a SQL command or file.   Remediation We have a bit of control over whether SQL Server emits the … Continue reading SQLCMD:- Informational Message – “Changed database context to ….”

Transact SQL – STRING_AGG – Error – “Multiple ordered aggregate functions in the same scope have mutually incompatible orderings.”

Background Working on some Transact SQL code yesterday. Ran into an error that was new to me. Error Error - Image Error - Text Sample Code The original code is a bit complex and sharing it will distract from this post's point. So here we go with sample code:-   Outline Original The original code … Continue reading Transact SQL – STRING_AGG – Error – “Multiple ordered aggregate functions in the same scope have mutually incompatible orderings.”

SQL Server Management Studio ( SSMS ) – Editor – Tabs and Spaces

Background When writing code, one gets to decide whether Tabs are kept as is; or have the editor automatically converts tabs to spaces.   SQL Server Management Studio ( SSMS ) Let us review SSMS Toolings as it relates to tabs and spaces.   Outline Editor Editing Choose Tabs or Spaces Selected Text Convert "Tabs … Continue reading SQL Server Management Studio ( SSMS ) – Editor – Tabs and Spaces

Shamar Bennett ( Prophet Bennett Ministries )

  Videos Midnight Prayer Altar Videos Video - Streamed live on September 15, 2020 Channel:- Shamar Bennett Added On:- 2020-September-21st Link Video - Streamed live on Aug 21st, 2020 Channel:- Shamar Bennett Added On:- 2020-September-22st Link Video - Streamed live on Aug 14, 2020 Channel:- Shamar Bennett Added On:- 2020-September-21st Link Video - Streamed live … Continue reading Shamar Bennett ( Prophet Bennett Ministries )

A Sober Holiday Season

Holiday Season As we near the fourth quadrant of the year, we have ahead of us the Holiday Season.   Rosh Hashanah Rosh Hashanah is this weekend. Rosh Hashanah is the Jewish New Year. It started on the evening of Friday, September 18th. And, ended on Sunday, September 20th.   Prophetic Crowd The prophetic crowd … Continue reading A Sober Holiday Season

Maverick City

  Videos Have My Heart (feat. Chandler Moore & Chris Brown) - Maverick City | TRIBL Videos Video #1 Channel:- TRIBL Date Published:- 2020-July-3rd Link My Soul Sings (feat. Dante Bowe from Bethel Music) - Maverick City Music | TRIBL Music Profile Official Video for "My Soul Sings (featuring Dante Bowe from Bethel Music)". Written … Continue reading Maverick City

Akon Through the Lens of DJ VLAD

Profile DJ VLAD Wikipedia Link Vladislav Lyubovny (Russian: Владислав Любовный; born June 28, 1973), commonly known as DJ Vlad, is an American interviewer, journalist, director and former disc jockey. He is the CEO of video and news website VladTV.com. His YouTube channel, djvlad, features his interviews of multiple music artists and entertainers and currently has … Continue reading Akon Through the Lens of DJ VLAD

Pastor/Prophet Sylvester Ofori

Background Here is a short story. A pastor and prophetic voice. And, his beautiful wife.   Videos Videos - Wedding The Matter TV WEDDING VIDEO OF PROPH SYLVESTER OFORI & LATE WIFE' ANNIVERSARY MARKS THIS SEPTEMBER Profile WEDDING ANNIVERSARY VIDEO!!!! Prophet are also human with body n blood, and with marital issues no one can … Continue reading Pastor/Prophet Sylvester Ofori