How To Get The Boss To Pay For Training
How do you get the boss to pay for training? In my experience you have to:
Ask. The boss isn’t sitting...
2014-07-31 (first published: 2014-07-24)
8,383 reads
Blog Posts
Log Shipping - Exclusive access could not be obtained because the database is in use
This story began as they almost always do - with a page at 4am local time...
--
'Alert: SQL Failed Jobs on InstanceName...
2014-07-31
10,820 reads
Power View report migration from SharePoint 2010 to 2013
With the latest changes to the Microsoft Power BI and ability to create Power View reports within an Excel file...
2014-07-31 (first published: 2014-07-24)
8,224 reads
Website Pulse
Short blog post this time as Website Pulse contacted me a few weeks ago with a few questions about working...
2014-07-31
1,173 reads
Building The SQLSaturday Orlando Marketing Plan–Part 27
Notes:
Email with the schedule went out this week, nice bump in registrations – we’re at 229 todayMailed the list twice (bad)...
2014-07-30
1,059 reads
Make an SSIS package Delay or Wait for Data
Packages can be scheduled to run at a time when you expect data to be in a database. Instead of...
2014-07-30 (first published: 2014-07-21)
12,807 reads
PASS SQL Saturday in Parma
This year, 22 November, PASSSQL Saturday will come to Parma, my birth town. I’m proud to be the organizer of that event.Our community,...
2014-07-30
959 reads
Please open this page in the Admin panel only
I am taking a slight deviation from the usual type of posts that I share. This time, I just want to share a quick and easy fix that I...
2014-07-30
3 reads
Please open this page in the Admin panel only
I am taking a slight deviation from the usual type of posts that I share. This time, I just want...
2014-07-30
1,396 reads
Quick Tips–SQL Prompt Custom Aliases
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2014-07-30 (first published: 2014-07-24)
8,038 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers